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.
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 NAME TYPE VALUE
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