oracle10g data guard(dg)__Adding or Dropping Online Redo Log Files

Consequently, when you add or drop an online redo log file at the primary site, it is important that you synchronize the changes in the standby database by following these steps:

1. If Redo Apply is running, you must cancel Redo Apply before you can change the log files.

2. If the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO, change the value to MANUAL.

3. Add or drop an online redo log file:

   • To add an online redo log file, use a SQL statement such as this:

     SQL> ALTER DATABASE ADD LOGFILE '/disk1/oracle/oradata/payroll/prmy3.log' SIZE 100M;
     

   • To drop an online redo log file, use a SQL statement such as this:

     SQL> ALTER DATABASE DROP LOGFILE '/disk1/oracle/oradata/payroll/prmy3.log';
     

4. Repeat the statement you used in Step on each standby database.

5. Restore the STANDBY_FILE_MANAGEMENT initialization parameter and the Redo Apply options to their original states.