Tuesday, September 26, 2017

Convert snapshot standby database to Physical standby database: Dataguard 11gR2


Step 1
SQL> shutdown immediate;

Step 2
SQL> startup nomount

Step 3
SQL> alter database mount;

Step 4
SQL>  ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

Step 5
SQL> shutdown database;

Step 6
SQL> startup nomount;
SQL> alter database mount standby database;

Step 7
SQL> alter database open;
SQL> alter database recover managed standby database disconnect;

Step 8
set pagesize 1000
set linesize 1000
col HOST_NAME for a20

select INSTANCE_NAME,OPEN_MODE,DATABASE_ROLE from v$instance,v$database;

No comments:

Post a Comment

Convert snapshot standby database to Physical standby database: Dataguard 11gR2

Step 1 SQL> shutdown immediate; Step 2 SQL> startup nomount Step 3 SQL> alter database mount; Step 4 SQL>  ALTER DATABASE CONV...