DATAGUAR_gap处理(11.2.0.3)RAC--Single
1：主库alert.log 报错信息(两节点报错信息一致)
//////////////////////////////////////////////////////////////////////////////////////////////////////
Mon Apr 29 17:04:57 2013
LNS: Standby redo logfile selected for thread 1 sequence 1062 for destination LOG_ARCHIVE_DEST_2
Mon Apr 29 17:04:57 2013
Archived Log entry 4271 added for thread 1 sequence 1061 ID 0xc5c1969d dest 1:
Mon Apr 29 17:04:58 2013
ARC3: Standby redo logfile selected for thread 1 sequence 1061 for destination LOG_ARCHIVE_DEST_2
Mon Apr 29 17:05:55 2013
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
Mon Apr 29 17:05:55 2013
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
Mon Apr 29 17:05:55 2013
FAL[server, ARC1]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC1]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC1]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC1]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance testdb1 - Archival Error. Archiver continuing.
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
2：数据库DG归档检查；
SQL> select dest_name,status,target,archiver,schedule, valid_type,valid_role,db_unique_name from v$archive_dest;
DEST_NAME STATUS TARGET ARCHIVER SCHEDULE VALID_TYPE VALID_ROLE DB_UNIQUE_NAME
----------------- -------- ---------- --------- ---------- ------------- ----------- --------------
LOG_ARCHIVE_DEST_1 VALID PRIMARY ARCH ACTIVE ALL_LOGFILES ALL_ROLES NONE
LOG_ARCHIVE_DEST_2 error STANDBY LGWR ACTIVE ONLINE_LOGFILE PRIMARY_ROLE testdg
3：检查DG数据库的alert.log
Mon Apr 29 16:05:16 2013
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 1089-1089
DBID 3317796511 branch 801792548
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's sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
------------------------------------------------------------
Mon Apr 29 16:05:41 2013
4：数据库GAP检查
select * from v$archive_gap;
thread# low_sequence# high_sequence#
-------- -------------- --------------
1 1045 1060
2 1089 1104
5: 主库检查归档是否存在
select * from v$archive_log where sequebce#=1045;(检查1045-1160；1089-1104)
+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_1_seq_1045.486.814036677
.
.
.
.
+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1104.505.814035367
6：使用RMAN从ASM设备中拷贝出来所需的归档文件,上传至DG服务器
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1089.346.814031367' to '/tmp/log/thread_2_seq_1089';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1090.303.814031723' to '/tmp/log/thread_2_seq_1090';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1091.470.814032087' to '/tmp/log/thread_2_seq_1091';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1092.376.814032447' to '/tmp/log/thread_2_seq_1092';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1093.407.814032807' to '/tmp/log/thread_2_seq_1093';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1094.417.814033111' to '/tmp/log/thread_2_seq_1094';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1095.411.814033469' to '/tmp/log/thread_2_seq_1095';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1096.365.814033829' to '/tmp/log/thread_2_seq_1096';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1097.385.814034189' to '/tmp/log/thread_2_seq_1097';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1098.357.814034551' to '/tmp/log/thread_2_seq_1098';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1099.391.814034911' to '/tmp/log/thread_2_seq_1099';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1100.410.814035335' to '/tmp/log/thread_2_seq_1100';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1101.518.814035363' to '/tmp/log/thread_2_seq_1101';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1102.349.814035365' to '/tmp/log/thread_2_seq_1102';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1103.399.814035365' to '/tmp/log/thread_2_seq_1103';
copy archivelog '+RECO_DM02/testDB/ARCHIVELOG/2013_04_29/thread_2_seq_1104.505.814035367' to '/tmp/log/thread_2_seq_1104';
.
.
.
7：取消备库的日志应用
alter database recover managed standby database cancel;
8：缺失的归档日志注册至DG数据库
alter database register logfile '/tmp/log/thread_1_seq_1045';
alter database register logfile '/tmp/log/thread_1_seq_1046';
alter database register logfile '/tmp/log/thread_1_seq_1047';
alter database register logfile '/tmp/log/thread_1_seq_1048';
alter database register logfile '/tmp/log/thread_1_seq_1049';
alter database register logfile '/tmp/log/thread_1_seq_1050';
.
.
.
.
9: shutdown DG数据库；
SQL>shutdown immediate;
10：reboot DG主机
reboot
11：startup DG数据库
SQL>startup
12：开启日志恢复进程
alter database recover managed standby database disconnect from session;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31362743/viewspace-2129061/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle锁机制
请登录后发表评论
登录
全部评论
