dataguard stop, start 절차

- Dataguard stop 절차

 

standby에서

 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

 

Primary에서

 

SQL> ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH SID='*';

 

        srvctl stop database -d RAC or shutdown immediate

 

- Dataguard start 절차

 

standby에서

 

SQL> startup mount

 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DICONNECT;

 

primary에서

SQL> ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH SID='*';

       

        srvctl start database -d RAC  or startup