#物理备用数据库到快照备用数据库 (oracle 11g中的snapshot standby特性)
#查看当前备用数据库的角色
#备机
[oracle@DB196 ~]$ sqlplus / as sysdba
SQL> select open_mode,database_role from v$database;
READ ONLY WITH APPLY PHYSICAL STANDBY
SQL> shutdown immediate;
SQL> startup mount;
#转换物理standby到快照standby
SQL> alter database convert to snapshot standby;
SQL> select status from v$instance;
MOUNTED
SQL> alter database open;
SQL> select open_mode,database_role from v$database;
READ WRITE SNAPSHOT STANDBY
SQL> select name,storage_size from v$restore_point;
SNAPSHOT_STANDBY_REQUIRED_07/30/2018 22:18:20 209715200
--测试是否可以修改数据库 OK
SQL> exit
#快照备用数据库到物理备用数据库 (oracle 11g中的snapshot standby特性)
[oracle@DB197~]$ sqlplus / as sysdba
SQL> select open_mode,database_role from v$database;
READ WRITE SNAPSHOT STANDBY
SQL> shutdown immediate;
SQL> startup mount;
#转换快照standby 到 物理standby
SQL> alter database convert to physical standby;
SQL> shutdown immediate;
ORA-01109: database not open
SQL> startup
SQL> alter database recover managed standby database using current logfile disconnect from session;
SQL> select open_mode,database_role from v$database;
READ ONLY WITH APPLY PHYSICAL STANDBY
