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
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. 🙂
7 thoughts on “How to configure oracle 11g database in archivelog mode”
helpful material Stay Tuned 🙂 Keep it up with passion
Thank you Waqas for your kind words. 🙂
thanks a lot for your great jobe done
Thank you for writing! Stay tune. 🙂
Thanks a lot!
Welcome Dinhdu! Stay tune. 🙂
Thank you very much for this great job.