DG丢失归档，使用增量备份恢复一例

发生了这种错误，主库丢失了归档，而备库无法同步日志Media RecoveryWaiting for thread 1 sequence 70Fetching gapsequence in thread 1, gap sequence 70-72Completed: ALTERDATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSIONWed Mar 07 18:26:312012FAL[client]: Failedto request gap sequence GAP - thread 1 sequence 70-72 DBID 3857759336 branch 768793323FAL[client]: Alldefined FAL servers have been attempted.-------------------------------------------------------------Check that theCONTROL_FILE_RECORD_KEEP_TIME initializationparameter is definedto a value that is sufficiently largeenough to maintainadequate log switch information to resolvearchivelog gaps.-------------------------------------------------------------1.备库上面查看丢失的归档idle> SELECTTHREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#----------------------- -------------- 1 70 722.主库查看归档是否存在先查看文件在系统中的位置sys@DEX> SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND DEST_ID=1 AND SEQUENCE# BETWEEN 70 AND 72; NAME------------------------------/u01/arch1/1_70_768793323.arc/u01/arch1/1_71_768793323.arc/u01/arch1/1_72_768793323.arc使用系统命令查看，如果看到没有找到文件，那么进入下面的阶段。file /u01/arch1/1_70_768793323.arc/u01/arch1/1_70_768793323.arc:cannot open `/u01/arch1/1_70_768793323.arc" （No such file or directory）3.备库查看丢失的归档时的scn号idle> select current_scn from v$database; CURRENT_SCN----------- 11020634.主库创建基于丢失归档scn号为起始的增量备份（要确定主库和备库的目标目录有足够的空间，这里使用/tmp文件夹）RMAN> run{BACKUP DEVICE TYPEDISK INCREMENTAL FROM SCN 1102063 DATABASEFORMAT "/tmp/stb_bk/%U_for_stb.bk"include current controlfile for standby ;}

RMAN中各种format参数说明搭建DataGuard环境相关资讯数据库

数据库范式详解（06/20/2014 08:59:37）
rman 创建catalog实验及说明（10/07/2012 19:00:24）
SYSTEM用户删除后怎么重新创建和原（09/09/2012 10:00:38）

分布式数据库：dblink （10/27/2012 15:57:32）
AutoMySQLBackup实现数据库定期备（09/14/2012 08:08:02）
利用dbstart和dbshut脚本自动启动（08/21/2012 06:16:21）

本文评论查看全部评论（0）