Converting Physical Standby to Logical Standby


  • „ Check Protection Mode is MaxPerformance or change it to MaxPerformance
  • „ Check LogXptMode is ‘ASYNC’ or change LogXptMode to ‘ASYNC’
  • „ Disable configuration and exit from dgmgrl

Archive all online redologfile

SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
System altered.
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
System altered.
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
System altered.

„ Following commands will be executed only on Secondary Database phyocm

SQL> SELECT db_unique_name,
database_role,
protection_mode,
protection_level
FROM v$database;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.

„ Open another terminal and check alert log file

[oracle@ocm bdump]$ tail -f alert_phyocm.log
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY phyocm;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> SELECT db_unique_name,
database_role,
protection_mode,
protection_level
FROM v$database;
SQL> ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
SQL> ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: