• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle 11g New Feature – Archived Redo Log Failover

By admin

Prior to 11g, if an archived log is corrupt in the FRA then RMAN command BACKUP RECOVERY AREA command will fail, even though the log has been archived to both the FRA and to a local archivelog destination.

Truncated log (10G):

ORA-19625: error identifying file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2007_10_29\O1_MF_1_23_3LBZC64C_.ARC 
ORA-27046: file size is not a multiple of logical block size 
OSD-04012: file size mismatch

Missing log (10G):

RMAN-03002: failure of backup command at 10/29/2007 10:16:04 
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability 
ORA-19625: error identifying file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2007_10_29\O1_MF_1_23_3LBZC64C_.ARC 
ORA-27041: unable to open file 
OSD-04002: unable to open file 
O/S-Error: (OS 2) The system cannot find the file specified.

The 11g Archived Redo Log Failover feature enables RMAN to complete a backup even when some archiving destinations are missing logs or contain logs with corrupt blocks where a local archivelog destination is configured alongside the FRA. If at least one log corresponding to a given log sequence and thread is available in the flash recovery area or any of the archiving destinations, then RMAN tries to back it up. If RMAN finds a corrupt block in a log file during backup, it searches other destinations for a copy of that log without corrupt blocks.

RMAN will failover to a local destination if the archivelog in the FRA is corrupt:

archived log /emea/rdbms/32bit/app/oracle/oradata/EMR111U3/FRA/EMR111U3/archivelog/2007_10_29/o1_mf_1_56_3lcb0tmh_.arc not found or out of sync with catalog 
trying alternate file for archived log of thread 1 with sequence 56 
channel ORA_DISK_1: starting archived log backup set 
channel ORA_DISK_1: specifying archived log(s) in backup set 
input archived log thread=1 sequence=56 RECID=1 STAMP=637234205

However, if the log is truncated then rman will fail:

RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/29/2007 09:42:18 
ORA-19575: expected 19359 blocks in file /emea/rdbms/32bit/app/oracle/oradata/EMR111U3/FRA/EMR111U3/archivelog/2007_10_29/o1_mf_1_56_3lcb0tmh_.arc, found 199

If the log is missing from the FRA then RMAN will failover to the corresponding local archivelog dest:

channel ORA_DISK_1: SID=138 device type=DISK 
archived log /emea/rdbms/32bit/app/oracle/oradata/EMR111U3/FRA/EMR111U3/archivelog/2007_10_29/o1_mf_1_56_3lcb0tmh_.arc not found or out of sync with catalog 
trying alternate file for archived log of thread 1 with sequence 56

Filed Under: oracle, Oracle 11g

Some more articles you might also be interested in …

  1. How to Split a Partition Into Multiple Partitions in Oracle 12c
  2. How To Cancel A SQL Query In Oracle Database 18c
  3. Oracle RMAN : Block-Level Media Recovery (Basics and Example)
  4. How To Resize An ACFS Filesystem/ASM Volume (ADVM)
  5. How to Recover From Lost or Missing Database Parameter Files (PFILE or SPFILE)
  6. CentOS / RHEL : Installing and Configuring ASMLib
  7. What are different Oracle Database Vault Roles
  8. How to change the SCAN IP address (SCAN VIP resources) in 11gR2 Grid (CRS) environment
  9. How to startup an Oracle Database Instance using spfile or pfile(init.ora) parameter file
  10. How to install and configure Oracle ASMLIB on Native Linux multipath mapper devices

You May Also Like

Primary Sidebar

Recent Posts

  • What are different Oracle Database Vault Roles
  • Unable to export realm protected table using data pump
  • Beginners Guide to Oracle Database Vault
  • How to Disable IPv6 on Ubuntu 18.04 Bionic Beaver Linux
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary