RMAN backup fails with Ora-00245 And Rman-08132 [ID 1365484.1]

尛樣兒發表於2013-01-25

RMAN backup fails with Ora-00245 And Rman-08132 [ID 1365484.1]
修改時間:2011-10-7型別:PROBLEM狀態:MODERATED優先順序:3

In this Document
  Symptoms
  Cause
  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 - Standard Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

RMAN backups report errors like :

ORA-00245: control file backup operation failed

RMAN-08132: WARNING: cannot update recovery area reclaimable file list

Cause

Incorrect specification for the Snapshot Controlfile

Solution

Incase of a RAC environment, than the Snapshot Controlfile needs to be stored on a shared location among the nodes in the RAC.

You can check the existing location for the snapshot controlfile using :

RMAN> show all;

....
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/rdbms/11.2.0/dbhome_1/dbs/snapcf_LVSP1.f'; # default

Especially when it is NOT explicit set, the default location is used, being $ORACLE_HOME/dbs

This directory might exist on all the related RAC-nodes, but are not necessary shared.
Depending on the configuration, the snapshot controlfile might be created on 'Node 1', but is than read on 'Node 2' as that related channel is making a backup of the controlfile.

Therefor the Snapshot Controlfile location needs to on a shared location between the nodes.

Example :

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/backup/snapcf_V112.f';



If the location is on an NFS-filesystem, than ensure the following parameters when mounting the NFS :

rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0,noac

        如果控制檔案快照沒有放在共享儲存上,那麼控制檔案快照只在RAC的其中一個節點存在,其他節點備份current controlfile的時候通過channel到該節點讀取控制檔案快照。

--end --

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-753311/,如需轉載,請註明出處,否則將追究法律責任。

相關文章