ADG[如有错误请不吝斧正]



--1、开启dg数据库，确认dg库的lsnrctl status是否启动

--2、mount  dg数据库

--3、查询不到【MRP和ARCH进程】
select process,status,sequence# from v$managed_standby;

--4、手动的启动MRP进程
alter database recover managed standby database disconnect from session;

--5、查询进程

select process,status,sequence# from v$managed_standby;
--查询到ARCH和MRP0进程，可以查询到【MRP】

--6、取消备库的自动恢复
alter database recover managed standby database cancel;

--7、【启动主数据库】确认网络、listener和tns

--8、开启主数据库，正常情况可以查询到【ARCH】，查询不到【MRP】此处正常
select process,status,sequence# from v$managed_standby;

--9、修改read only
alter database open READ ONLY;

--10、在“READ ONLY”状态下进一步启动备库的恢复
alter database recover managed standby database using current logfile disconnect;

--11、日志传送
SELECT a.th, a.seq transfered, b.seq archived
  FROM (SELECT local.thread# th, MAX(local.sequence#) seq    
          FROM (SELECT thread#, sequence#       
                  FROM v$archived_log        
                 WHERE dest_id = 1) local 
         WHERE local.sequence# IN        
               (SELECT sequence#      
                  FROM v$archived_log      
                 WHERE dest_id = 2
                   AND thread# = local.thread#)
         GROUP BY local.thread#) a,
       (SELECT thread# th, MAX(sequence#) seq 
          FROM v$archived_log  
         WHERE dest_id = 1  
         GROUP BY thread#) b
 WHERE a.th = b.th
 ORDER BY 1;