How to Manually Determining and Resolving Archive Gaps in ASM [ID 1271114.1]
How to Manually Determining and Resolving Archive Gaps in ASM (Copy archivelog in ASM using RMAN) [ID 1271114.1] | |||||
| |||||
修改時間 04-JAN-2012 型別 HOWTO 狀態 MODERATED |
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.2Information 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;
2. On primary Check the location where the missing logfiles exist.
SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=
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
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';
$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';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-721588/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to drop Oracle RAC database manually?OracleDatabase
- How to Deinstall Oracle Clusterware Home ManuallyOracle
- Temporary failure resolving ‘archive.ubuntu.com‘AIHiveUbuntu
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- Resolving archive.cloudera.com... failed: Temporary failure in nameHiveCloudAI
- How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]ASM
- ASM Archive destination is full. [ID 351547.1]ASMHive
- How to Copy ASM Files Across Nodes [ID 1147859.1]ASMROS
- How to re-create the ASMASM
- How to restore ASM based OCRRESTASM
- How to cleanup ASM installationASM
- How to free space from an ASM diskgroup? (Doc ID 1553744.1)ASM
- How to move ASM spfile to a different disk group [ID 1082943.1]ASM
- How To Using Flashback Data Archive (Oracle Total Recall)HiveOracle
- How To Change The Asm Rebalancing PowerASM
- How to Find Sessions Generating Lots of Redo or Archive logsSessionHive
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- SQL: How to Find Sessions Generating Lots of Redo or Archive logsSQLSessionHive
- How to Check ASM Login for Oracle Goldengate (OGG) ? [ID 1311784.1]ASMOracleGo
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- ASM 11g New Features - How ASM Disk Resync WorksASM
- Oracle ASM How many allocation units per fileOracleASM
- How to config (no)archivelog mode and manage archive log files by RMANHive
- How does ASM work with RAID where striping and mirroring are already built-in?ASMAIUI
- Create database manuallyDatabase
- Rust Reference Cycles: Resolving and Avoiding themRust
- How to move ASM database files from one diskgroup to anotherASMDatabase
- How to use ASMCA in silent mode to configure ASMASM
- How To Setup ASM (11.2) On An Active/Passive Cluster (Non-RAC). [ID 1296124.1]ASM
- SQL: How to Find Sessions Generating Lots of Redo or Archive logs-167492.1SQLSessionHive
- How To Setup ASM (10.2 & 11.1) On An Active/Passive Cluster (Non-RAC). [ID 1319050.1]ASM
- How to copy a datafile from ASM to a file system not using RMANASM
- How To Upgrade ASM from 10.2 to 11.1 (RAC)ASM
- How to restore ASM based OCR after complete loss of the CRS diskgroupRESTASM
- AIX: Determining Oracle Memory Usage On AIX (Doc ID 123754.1)AIOracle
- Determining the Global Database Name (86)Database
- How To Kill Good IdeasGoIdea
- Linux BRIDGED 模式下的Determining IP information for eth0...failedLinux模式ORMAI