How to configure oracle 11g database in archivelog mode

Connect database as sys user to configure it in archivelog mode.

[oracle@PR ~]$ sqlplus / as sysdba

Verify your database is in archivelog log mode or not, In our case obviously not.

SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG

OR

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence     1
Current log sequence           3

To configure database in archivelog mode, follow the steps below:

Step-I: Shutdown database:

SQL> shutdown immediate;

Step-II: Startup your database in mount mode:

SQL> startup mount;

Step-III: Configure database in archivelog:

SQL> alter database archivelog;

Step-IV: Open database in read write mode:

SQL> alter database open;

Database is in archive log mode now, you can verify with following SQL command, Result shows Database log mode is “Archive Mode” and “Automatic archival” is Enabled.

SQL> archive log list;
Database log mode               Archive Mode
Automatic archival              Enabled
Archive destination             /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence      1
Next log sequence to archive    3
Current log sequence            3

You can change archive log destination with following:

SQL> alter system set log_archive_dest_1='LOCATION=/home/oracle/archdir' scope=both;

Following command shows, the database is in archivelog mode:

SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG

 

Your comment and suggestion are highly appreciated.

Thank you. Stay Tune. 🙂

4 thoughts on “How to configure oracle 11g database in archivelog mode

Leave a Reply

%d bloggers like this: