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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Temporary failure resolving ‘archive.ubuntu.com‘AIHiveUbuntu
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- Resolving archive.cloudera.com... failed: Temporary failure in nameHiveCloudAI
- How To Turn SNMP On/Off ? [ID 472530.1]
- What is OPAQUE_TRANSFORM Hint and how to Control it [ID 780503.1]OpaqueORM
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- 【CURSOR】How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
- 【ASM】ORA-27504 ORA-27300 ORA-27303 while starting ASM (Doc ID 2281441.1)ASMWhile
- How to redirect to a specific web page after sign out from Entra IDWeb
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- Rust Reference Cycles: Resolving and Avoiding themRust
- Swift iOS : ArchiveSwiftiOSHive
- Manually Evolve and Accept SQL PLAN BASELINES in Oracle 12cSQLOracle
- Ten examples of git-archiveGitHive
- 什麼叫archive log expired?Hive
- Flashback Data Archive原理詳解Hive
- Archive log mining steps(logminer to html)HiveHTML
- How to ssh
- log_archive_dest與log_archive_dest_n與USE_DB_RECOVERY_FILE_DESTHive
- When should reread of cl_crm_bol_entity and $scope.$apply be called manuallyAPP
- 【Hudi】原始碼解讀——Archive 流程原始碼Hive
- 【FLASHBACK】Oracle flashback data archive 介紹OracleHive
- How to find dependency
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- 【ASM】ASM磁碟頭被重寫,如何修復ASM
- goldengate + asm + racGoASM
- gnu inline asminlineASM
- 【ASM】ASM啟動無法找到spfile問題原因ASM
- 從定位資料塊所在ASM磁碟到ASM strippingASM
- [譯] WebAssembly: How and whyWeb
- How OpenStack integrates with Ceph?
- How to Build a Cybersecurity CareerUI
- CISO之What & How
- How to Restart Qt ApplicationRESTQTAPP
- How Python list works?Python
- How to Install psql on MacSQLMac
- How to Install LibreOffice on UbuntuUbuntu
- ASM叢集檔案系統ACFS(ASM Cluster File System)ASM
- [20220610][轉載]Is my table marked for archive.txtHive