RMAN backup fails with Ora-00245 And Rman-08132 [ID 1365484.1]
修改時間:2011-10-7

型別:PROBLEM

狀態:MODERATED

優先順序:3

In this Document

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 --

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

Applies to:

Symptoms

Cause

Solution

相關文章