1. 为主库添加standby logfile

alter database add standby logfile group 7 ('/u02/oldyang/redo01/stdredo07a.LOG','/u02/oldyang/redo02/stdredo07b.LOG') size 10M;
alter database add standby logfile group 8 ('/u02/oldyang/redo01/stdredo08a.LOG','/u02/oldyang/redo02/stdredo08b.LOG') size 10M;
alter database add standby logfile group 9 ('/u02/oldyang/redo01/stdredo09a.LOG','/u02/oldyang/redo02/stdredo09b.LOG') size 10M;
alter database add standby logfile group 10 ('/u02/oldyang/redo01/stdredo10a.LOG','/u02/oldyang/redo02/stdredo10b.LOG') size 10M;
alter database add standby logfile group 11 ('/u02/oldyang/redo01/stdredo11a.LOG','/u02/oldyang/redo02/stdredo11b.LOG') size 10M;
alter database add standby logfile group 12 ('/u02/oldyang/redo01/stdredo12a.LOG','/u02/oldyang/redo02/stdredo12b.LOG') size 10M;
alter database add standby logfile group 13 ('/u02/oldyang/redo01/stdredo13a.LOG','/u02/oldyang/redo02/stdredo13b.LOG') size 10M;

2. 主库部分

[oracle@oracle01 ~]$ lsnrctl stop --关闭主库监听

SQL> shutdown immediate; --关闭主库（切断进程）

SQL> startup --开库进行切换

SQL> select switchover_status from v$database; --确认是否可转换

SQL> alter database commit to switchover to physical standby with session shutdown; --切换角色

SQL> shutdown immediate; --再次关库

[oracle@oracle01 ~]$ lsnrctl start --开启主库监听

SQL> startup mount --启动到mount状态

SQL> alter database recover managed standby database disconnect from session; --开启MRP

SQL> select message from v$dataguard_status; --查看状态

3. 备库部分

SQL> select switchover_status from v$database; --确认是否可转换

SQL> alter database commit to switchover to primary; --切换角色

SQL> shutdown immediate; --关库

SQL> startup --启动转换后的主库

SQL> select switchover_status from v$database; --确认切换后的角色

SQL> select message from v$dataguard_status; --查看状态

SQL> alter system switch logfile; --切换日志

SQL> select message from v$dataguard_status;