Home » RDBMS Server » Backup & Recovery » WARNING: cannot update recovery area reclaimable file list (Lunix Oracle 11.2..0.2)
WARNING: cannot update recovery area reclaimable file list [message #569025] Thu, 18 October 2012 14:31 Go to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
I just switched my STBDY DB to a PRIMARY DB and I am ran the following:


RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
ORA-00245: control file backup operation failed

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


RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORARZULB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/apps/oracle/product/11.2/dbs/snapcf_ORARZULP1.f'; # default




Can somebody explain to me what causes this warning and how to get rid of it?



Re: WARNING: cannot update recovery area reclaimable file list [message #569738 is a reply to message #569025] Wed, 31 October 2012 15:20 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 447
Registered: July 2003
Location: WPB, FL
Senior Member

Normally this is caused by the incorrect specification for the Snapshot Controlfile.
Re: WARNING: cannot update recovery area reclaimable file list [message #569801 is a reply to message #569738] Thu, 01 November 2012 13:32 Go to previous message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
LkBrwn,

My snapshot control was pointing to a local file system in my rac setup. This is what caused the error. When I changed the path to point to a shared area (Ie ASM disk) the problem was resolved.

Thanks for the reply and applogies for not posting the solution earlier
Previous Topic: recovery from RAC to standalone
Next Topic: Difference between 2 RMAN commands
Goto Forum:
  


Current Time: Wed Nov 26 20:13:02 CST 2014

Total time taken to generate the page: 0.17977 seconds