Enable Archivelog Mode

Problem Description

One of the requirements if you want to create a standby database is to make sure that your primary database is in archivelog mode. This is important especially if you want to perform online backups.

To perform this task, please take note that your primary database will require an outage. Meaning you will need to shutdown/restart the database.

Steps Performed

The recommended approach is to make use of the Fast/Flash recovery area (10g and above).

First review the recovery area destination example:

SQL> show parameter db_recovery_file_dest

db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 10G

Note: The above is an example. You might need to adjust these to values to your environment.

The next step is to enable archivelog mode in the database:

sql> connect / as sysdba
sql> shutdown immediate;
sql> startup mount;
sql> alter database archivelog;
sql> shutdown immediate;
sql> startup;

The database should now be in archivelog mode. To review you can execute the following:

sql> archive log list;


SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 530
Next log sequence to archive 532
Current log sequence 532

You should now be able to perform online backups or start with the creation of your standby database.

Anton Els June 19, 2013 07:38

Have more questions? Submit a request