RAM&KRISHNA BLOG

Microsoft Windows [Version 6.1.7600] Copyright (c) 2009 Microsoft Corporation.  All rights reserved. C:\Users\computer>sqlplus Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name from v$database; NAME --------- ORACLE ------------------------------------------------------------------------------ NOTE - DATABASE SHOULD BE IN ARCHIVE LOG MODE ------------------------------------------------------------------------------ SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     8 Next log sequence to archive   10 Current log sequence           10 SQL> SQL> select name from v$datafile; NAME --------------------------------------------

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;