Oracle 10g使用RMAN创建physical standby

　　ORA-01507: database not mounted

　　ORACLE instance shut down.

　　SQL> startup nomount

　　ORACLE instance started.

　　Total System Global Area 285212672 bytes

　　Fixed Size 1218992 bytes

　　Variable Size 96470608 bytes

　　Database Buffers 184549376 bytes

　　Redo Buffers 2973696 bytes

　　SQL> alter database mount standby database;

　　Database altered.

　　SQL> alter database recover managed standby database disconnect from session;

　　Database altered.

　　备库：

　　SQL> alter database commit to switchover to primary;

　　Database altered.

　　SQL> shutdown immediate;

　　ORA-01109: database not open

　　Database dismounted.

　　ORACLE instance shut down.

　　SQL> startup

　　ORACLE instance started.

　　Total System Global Area 285212672 bytes

　　Fixed Size 1218992 bytes

　　Variable Size 96470608 bytes

　　Database Buffers 184549376 bytes

　　Redo Buffers 2973696 bytes

　　Database mounted.

　　Database opened.

　　SQL>

　　至此完成自由切换。

文章来源于领测软件测试网 https://www.ltesting.net/