ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to Manually Determining and Resolving Archive Gaps in ASM [ID 1271114.1]

How to Manually Determining and Resolving Archive Gaps in ASM [ID 1271114.1]

原创 Linux操作系统 作者:spider0283 时间:2011-08-21 10:03:05 0 删除 编辑
修改时间 17-FEB-2011     类型 HOWTO     状态 MODERATED  

In this Document
  Goal
  Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Goal

The note describes how to find a GAP and resolve it in case of ASM on both primary and standby or ASM on either primary or standby.

Solution

1. Check for the GAP,

On standby,


SQL>SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;


Ref : How To Check Whether Physical Standby is in Sync with the Primary? (Doc ID 861595.1)

2. On primary Check the location where the missing logfiles exist.

SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#= AND DEST_ID= AND SEQUENCE# BETWEEN AND ;


For example,


SQL> SELECT * FROM V$ARCHIVE_GAP;

THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
----------- ------------- --------------
1 1113 1115


SQL> SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND DEST_ID=1 AND SEQUENCE# BETWEEN 1113 AND 1115;

NAME
--------------------------------------------------------------------------------
+DGROUP2/PROD/datafile/ARC00001113_0732997804.001
+DGROUP2/PROD/datafile/ARC00001114_0732997804.001
+DGROUP2/PROD/datafile/ARC00001115_0732997804.001



3. Use RMAN to copy to someother local filesystem.


RMAN>copy archivelog '+DGROUP2/PROD/datafile/ARC00001113_0732997804.001' to '/u01/app/oracle/ARC00001113_0732997804.001';


Do the same for all the logs.

4. SCP to standby.

scp /u01/app/oracle/ARC00001113_0732997804.001 drs1.idc.oracle.com:/u04/standby/

5. Register manually by mentioning the copied file location.

On standby,


SQL>alter database register logfile '/u01/app/oracle/ARC00001113_0732997804.001';



NOTE : Alternatively we can copy this archive log to standby ASM location and then do a register.



On standby,

$rman target /

RMAN>copy archivelog '/u01/app/oracle/ARC00001113_0732997804.001' to '+DGROUP2/STDBY/datafile/ARC00001113_0732997804.001';


Now register,

SQL>alter database register logfile '+DGROUP2/STDBY/datafile/ARC00001113_0732997804.001';


显示相关信息 相关的


产品
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
VERSION; V$ARCHIVED_LOG; V$ARCHIVE_GAP; SYNC; RESOLVED

返回页首返回页首

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38267/viewspace-705474/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    645821