下配置六物业

switchover过程：

12.把数据库切换回到主节点

先将standby此时的a恢复为以前是standby时的参数。

在主节点（standby主机上）

SQL alter database commit to switchover to physical standby;

Database altered.

SQL shutdown immediate

颇受欢迎。 ORA-01507: database not mounted

statORACLE instance shut down.

SQL startup nomountpfile=/home/oracle/product/9.2.0/dbs/a;

;

ORACLE instance started.

Total System Global Area bytes

Fixed Size 452044 bytes

Variable Size bytes

Database Buffers bytes

Redo Buffers 667648 bytes

SQL alter database mount standby database;

Database altered.

SQL ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

在备用节点（在primary主机上）

先将primary此时的a恢复为以前是primary时的参数。

SQL alter database commit to switchover to primary;

Database altered.

SQL shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL startuppfile=/home/oracle/product/9.2.0/dbs/a;

ORACLE instance started.

Total System Global Area bytes

Fixed Size 452044 bytes

Variable Size bytes

Database Buffers bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.

衷心致谢: CU oracle斑竹 sshd ,我在配置dataguard时得到他的很多帮助！！

参考文献

Dataguard配置Step by step (eygle大作)

查看本文来源

上海哪医院妇科好
呼和浩特阴道炎治疗费用
南通妇科哪家医院好