11g Data Guard 维护手顺

#--duplicate数据库
rman target / auxiliary sys/sys@phydb
duplicate target database for standby;
duplicate target database for standby from active database;
duplicate target database for standby NOFILENAMECHECK dorecover;

#--判断DG是否安装
select * from v$option where parameter = 'Oracle Data Guard';
#--是否强制日志模式
select FORCE_LOGGING from v$database; 
#--查看数据库角色
select database_role,protection_mode,protection_level from v$database;

#--1、启动到管理模式  
SQL>shutdown immediate; 
SQL>startup nomount;  
SQL>alter database mount standby database;  
SQL>alter database recover managed standby database disconnect from session;
#--2、如果在管理恢复模式下到只读模式 
SQL> recover managed standby database cancel; 
SQL> alter database open read only;
#--3、启动到只读方式  
SQL>shutdown immediate; 
SQL>startup nomount; 
SQL>alter database mount standby database; 
SQL>alter database open read only; 
#--4、只读模式到管理模式
SQL> recover managed standby database disconnect from session;

v$archive_dest 
v$archive_dest_status
v$log_history
v$archvied_log
v$managed_standby
v$archive_gap 

#--Physical Database--

#--数据库状态状态
select dbid,name,switchover_status,db_unique_name,database_role,open_mode,current_scn from v$database;

#日志应用结果查旬
select sequence#,name, applied from v$archived_log;

#--停止主数据库日志发送
alter system set log_archive_dest_state_2=defer

----------------------------------------------------------------------------------------------
#--Standby Database--


#--开启Standby日志实时应用模式
alter database recover managed standby database using current logfile disconnect from session;


#--查看日志应用模式
select recovery_mode from v$archive_dest_status where dest_id=1;


#--察看备库是否和主库同步
SELECT ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ# FROM V$ARCHIVE_DEST_STATUS;


#--察看备库已经归档的redo
SELECT REGISTRAR, CREATOR, THREAD#, SEQUENCE#, FIRST_CHANGE#,NEXT_CHANGE# FROM V$ARCHIVED_LOG;


#察看备库已经应用的redo
SELECT THREAD#, SEQUENCE#, FIRST_CHANGE#, NEXT_CHANGE# FROM V$LOG_HISTORY;


#察看备库接收,应用redo数据过程
SELECT MESSAGE FROM V$DATAGUARD_STATUS;


#日志应用结果查旬
select sequence#,name, applied from v$archived_log;


#备库察看RFS(Remote File Service)接收日志情况和MRP应用日志同步主库情况
SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS  FROM V$MANAGED_STANDBY;


#--数据库同步状态
select dbid,name,switchover_status,db_unique_name,database_role,open_mode,current_scn from v$database;


#--停止standby数据库日志接收
recover managed standby database cancel; 
alter database recover managed standby database finish;