DATAGURAD常见问题

-- 检查日志应用情况：
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博客 ” ，链接：http://blog.itpub.net/22818880/viewspace-2077077/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22818880/viewspace-2077077/