Data Guard出现gap sequence修复.docx

Data Guard出现gap sequence修复一、出现gap sequence现象备库Fetching gap sequence inthread 1, gap sequence 710-716 Tue May 31 15:02:38 2011 FAL[client]: Failed to request gap sequence? ?GAP - thread 1 sequence 710-716 ?DBID 3240478808 branch 746916894 FAL[client]: All defined FAL servers have been attempted. ------------------------------------------------------------- Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that is sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps. -------------------------------------------------------------主库Tue May 31 13:50:47 2011 FAL[server]: Fail to queue the whole FAL gap ?GAP - thread 1 sequence 710-716 ?DBID 3240478808 branch 746916894二、修复操作1、查询备库的scnSQL SELECTCURRENT_SCN FROMV$DATABASE; CURRENT_SCN ----------- ????1154337 --在出现意外datafile header scn不一致的时候,需要根据提示归档日志,找出最小scn2、确定主库是否添加数据文件SQL selectFILE#,namefromv$datafile whereCREATION_CHANGE# =1154337; norowsselected确定主库在这个scn之后是否有添加数据文件，如果添加文件，需要手工在备库添加3、备库停止日志应用SQL ALTERDATABASERECOVER MANAGED STANDBY DATABASECANCEL;4、主库增量备份并传输到备库上主库进行增量备份RMAN BACKUP INCREMENTAL FROMSCN? 1154337 DATABASE?FORMAT /home/oracle/xff_%Utag XIFENFEI; [oracle@localhost ~]$ scpxff* 192.168.1.30:/home/oracle/rman说明：主库之前必须要做过rman的全备（没有全备的库，基于scn的增量备份也能够成功）5、备库上进行恢复RMAN CATALOG START WITH/home/oracle/rman; RMAN RECOVER DATABASENOREDO;RMAN-03002: failure of restore command at 12/11/2012 16:07:19ORA-19870: error reading backup piece /home/oracle/backup/dbf_07nsjs47_1_1.bakORA-19573: cannot obtain exclusive enqueue for datafile 1该问题的原因是由于数据库处于open状态导致的，将数据库置于mount状态该问题即可解决。说明：CATALOG START WITH是10g及其以后版本中才存在功能，没有该功能可以采用catalog或者复制主库的控制文件，rman备份放置和主库备份时相同目录实现。6、主库上创建standby controlfile文件并传输到备库RMAN BACKUP CURRENTCONTROLFILE FORSTANDBY? FORMAT /home/oracle/xff_ctl.bck; [oracle@localhost ~]$ scp xff_ctl.bck 192.168.1.30:/home/oracle/rman创建standby controlfile两步可以需要根据实际情况考虑,大多数情况下不需要7、备库恢复控制文件RMAN shutdown; RMAN STARTUP NOMOUNT; RMAN RESTORE