Oracle Database 11g Archivelog mode configuration


In this article we will show how to configure oracle database noarchive log mode to archive log mode. This post also describe how to change oracle default archive log destination.

@ Check our oracle database log mode using below command. We run below command from sysdba user and check the result if query output throw No Archive Mode it means our oracle database archiving is not enable. So we enable our oracle database No Archive mode to Archive mode using following steps.

sql> select log_mode from v$database;
OR
sql>sqlplus / as sysdba
sql> archive log list;

@ create the new archive location:
# mkdir -p /u01/app/oracle/oradata/orcl/arch
sql> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/orcl/arch' scope=both;

Now we check our archive log destination using below query

sql> archive log list;
sql> select destination,STATUS from v$archive_dest where statuS='VALID';

Now stop our oracle database, steps are given below

sql>sqlplus / as sysdba
sql> shutdown immediate;

@ Startup database in mount mode
sql>sqlplus / as sysdba
sql> startup mount;

Now we change our database No Archive log mode to Archive log mode
@ Configure database in archivelog

sql> alter database archivelog;

@ Open database in read write mode
sql> alter database open;

@ We check our oracle database archive log mode again we will see that our database will be converted to archive mode
sql> sqlplus / as sysdba
sql> archive log list;

@ You can change archive log destination following below steps
sql> alter system set log_archive_dest_1='LOCATION=/home/oracle/archdir' scope=both;

@ Below query show database log mode
sql> select log_mode from v$database;

Post a Comment

0 Comments

3