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