PROD - Primary database
COB - Physical standby database
2. Convert COB to standby Snapshot database and confirm it is in read/Write
(i)SQL> alter database recover standby database cancel;
or
DGMGRL > EDIT DATABASE 'COB_DATABASE' SET STATE = 'APPLY-OFF';
(ii)DGMGRL > convert database 'COB_DATABASE' to snapshot standby;
(iii)shutdown the database on the node and start the database like below
SRVCTL status database - d COB_DATABASE
SRVCTLstop database - d COB_DATABASE
SRVCTL start database - d COB_DATABASE
SRVCTL status database - d COB_DATABASE
(iv) SQL > SELECT database_role role, name, db_unique_name, platform_id, open_mode, log_mode, flashback_on, protection_mode, protection_level FROM v$ database;
Comments
Post a Comment