-- 检查日志应用情况：
select max(sequence#) from v$log_history;
select max(sequence#),applied from v$archived_log group by applied;
select max(sequence#),thread# from v$log_history GROUP BY thread#;

-- 检查MRP进程：
set line 600
select * from v$managed_standby;
select process,status,sequence#,thread#,BLOCK#,BLOCKS from v$managed_standby;

select process,status,sequence#,thread#,BLOCK#,BLOCKS from v$managed_standby where status <> 'IDLE' OR PROCESS LIKE 'MRP%';

-- WAIT FOR GAP,手工传输日志后注册：
ALTER DATABASE REIGSTER LOGFILE 'XXXX';

select group#,bytes,sequence#,status,thread# from v$standby_log;

alter system archive log current;

select dest_name,destination,status,error from v$archive_dest

ORA-16191: 主日志传送客户机没有登录到备用数据库
ORA-01033: ORACLE 正在初始化或关闭
检查SYS用户是否open(11.2.0.4.2)
检查密码文件是否一致，尤其是RAC，或者后来重新OPEN过SYS用户。如有必要可以重建密码文件
检查密码文件属主是否正确，必须是DB OS用户

alter database recover managed standby database using current logfile parallel 128 disconnect;

alter database recover managed standby database cancel;

归档目标报权限不足

SQL> select dest_name,status,error from v$archive_dest;

DEST_NAME   STATUS ERROR
-------------------------------------- ------------   -----------------------------------------------------------------
LOG_ARCHIVE_DEST_2   ERROR    ORA-01031: insufficient privileges

把主库所在主机密码文件copy到备库主机：生产库和灾备库需要有同样的SYS用户密码；

当MRP进程启动不了：
查看alert log:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: 'xxxxxxxx/system01.dbf'

对比生产和DG库的incarnation:
生产：
RMAN> list incarnation;
using target database control file instead of recovery catalog

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 LUGZ0 203185647 PARENT 386286 2008-11-04 16:55:57
2 2 LUGZ0 203185647 CURRENT 386674 2008-11-04 17:00:37

DG的与生产的不一致，需要reset一下：
RMAN> list incarnation;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 LUGZ0 203185647 PARENT 386286 2008-11-04 16:55:57
2 2 LUGZ0 203185647 PARENT 386674 2008-11-04 17:00:37
3 3 LUGZ0 203185647 CURRENT 9495663514914 2014-09-20 09:24:59

RMAN> reset database to incarnation 2;

ITPub博客

DATAGURAD常见问题

最新文章