Oracle Data Guard Startup & Shutdown Steps
Data Guard Shutdown Sequence Stop log apply service or MRP and shutdown the standby SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL ; SQL > SHUT IMMEDIATE ; Stop log shipping from primary and shutdown primary database SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'DEFER' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'DEFER' ; SQL > SHUT Transactional ; Modes of Shutdown of the Oracle Database: Shutdown Normal Shutdown Transactional Shutdown Immediate Shutdown Abort Data Guard Startup Sequence Startup primary database and enable log shipping SQL > STARTUP ; SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'ENABLE' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'ENABLE' ; Startup standby and enable log apply service or MRP SQL > startup nomount ; SQL > alter database mount standby database ; SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNE...