2015. 6. 17. 14:09 오라클
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
