Home » RDBMS Server » Backup & Recovery » backup of controlfile on stdby node (Oracle 11.2.0..3)
backup of controlfile on stdby node [message #581267] Wed, 03 April 2013 17:29 Go to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
I am trying to backup my control on a STBBY DB(RAC) and I am getting the ollowing error.

ORA-00245: control file backup failed; target is likely on a local file system



Does anybody have any idea as to what the issue is? Note the FS is ACFS and can see on all my nodes


show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PA01INS_IM3L059B are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 6;
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 APPLIED ON STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/share/dbbkup/oracle/PA01INS/rman/snapcf_PA01INS.f';


cat control.rman

connect target /
run {
allocate CHANNEL d1 type disk format '/share/dbbkup/oracle/PA01INS/rman/controlfile_%s_%p_%t.bkp';
backup current controlfile;
release channel d1;
}

ACFS file system

df -h /share/dbbkup/oracle/PA01INS/rman
Filesystem            Size  Used Avail Use% Mounted on
/dev/asm/pa01ins-33    75G  2.6G   73G   4% /share/dbbkup/oracle/PA01INS



rman cmdfile=control.rman

RMAN> connect target *
2> run {
3> allocate CHANNEL d1 type disk format '/share/dbbkup/oracle/PA01INS/rman/controlfile_%s_%p_%t.bkp';
4> backup current controlfile;
5> release channel d1;
6> }
7>
connected to target database: PA01INS (DBID=6439697)

using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=1944 instance=PA01INS1 device type=DISK

Starting backup at 03-APR-13
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d1 channel at 04/03/2013 18:24:58
ORA-00245: control file backup failed; target is likely on a local file system

Recovery Manager complete.



Thanks to all who answer
Re: backup of controlfile on stdby node [message #581268 is a reply to message #581267] Wed, 03 April 2013 22:10 Go to previous messageGo to next message
dia.william923@gmail.com
Messages: 5
Registered: February 2013
Junior Member
Oracle documentation shows following description and action for error message:
ORA-00245 "control file backup failed; target is likely on a local file system"
// *Cause: Failed to create a control file backup because some process
// signaled an error during backup creation. This is likely caused
// by the backup target being on a local file system so it could not
// be accessed by other instances. It can also be caused by other
// I/O errors to the backup target. Any process of any instance that
// starts a read/write control file transaction must have access
// to the backup control file during backup creation.
// *Action: Check alert files of all instances for further information.
backup of controlfile on stdby node [message #581333 is a reply to message #581267] Thu, 04 April 2013 10:46 Go to previous message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
Problem solved.

Though we can place the actual backup in /share/dbbkup/oracle/PA01INS/rman
RMAN creates a copy of the control file for read consistency, this is the snapshot controlfile.
Due to the changes made to the controlfile backup mechanism in 11gR2 any instances in the cluster may write to the snapshot controlfile. Therefore, the snapshot controlfile file needs to be visible to all instances.


Since the ACFS is mounted like this:

Filesystem Size Used Avail Use% Mounted on
/dev/asm/pa01ins-33 75G 2.7G 73G 4% /share/dbbkup/oracle/PA01INS

The following RMAN configuration failed. Note: "rman" in the directory not seen in the mount point

FAILED
=======
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/share/dbbkup/oracle/PA01INS/rman/snapcf_PA01INS.f';

To fix the issue we need to configure RMAN snapshot directory to a place shared by all 4 nodes. Note: the "rman" no longer in the directory.

WORKS
======
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/share/dbbkup/oracle/PA01INS/snapcf_PA01INS.f';

Previous Topic: RMAN Incremental Backup & Import
Next Topic: ISSUE WITH shutting down database
Goto Forum:
  


Current Time: Thu Oct 02 07:21:36 CDT 2014

Total time taken to generate the page: 0.07972 seconds