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

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

Applies to:

Symptoms

Cause

Solution

最新文章