1

检查归档文件是否完整；

select distinct THREAD#,MAX(SEQUENCE#) OVER(PARTITION BY THREAD#) A FROM V$ARCHIVED_LOG;

2

检查归档文件是否连续

select * from v$archive_gap;

3

查看日志是否应用

SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG;

4

查看数据库当前模式

select open_mode from v$database;

5

查看实例状态

select status from v$instance;

6

查看数据库当前角色

select DATABASE_ROLE from v$database;

7

验证是否支持switchover操作

select SWITCHOVER_STATUS from v$database;

8

将Primary 数据库转换为 Standby角色

alter database commit to switchover to physical standby;

9

转换Standby数据库为Primary角色

alter database commit to switchover to primary;

10

查看当前归档日志数量

select max(sequence#) from v$archived_log;

11

启动redo应用

alter database recover managed standby database disconnect from session；（从归档 发送）

12

启动redo实时应用

alter database recover managed standby database using current logfile disconnect from session;（从standby redo log发送）

13

启动failover

alter database recover managed standby database finish force；

14

转换Standby数据库到Maximize Performance模式

alter database set standby database to maximize performance； 

15

修改Standby数据库到Maximize Availability

alter database set standby database to maximize availability；