Home » RDBMS Server » Backup & Recovery » RMAN control File auto backup error (10.2.0.5 solaris 10)
RMAN control File auto backup error [message #535376] Tue, 13 December 2011 15:33 Go to next message
rickpep
Messages: 1
Registered: December 2011
Location: St. Louis
Junior Member
I'm not sure what is happening:

This is what I run
run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dd_oraback/tkprod/%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
sql 'alter system archive log current';
delete noprompt obsolete;
crosscheck archivelog all;
delete noprompt expired archivelog all backed up 1 times to disk completed before 'sysdate-2';
backup format '/dd_oraback/tkprod/%d_ARC_%T_%U' archivelog all not backed up 1 times filesperset=1 TAG='tkprod_ARC_13-Dec-11_14:54';
delete noprompt archivelog all backed up 1 times to disk completed before 'sysdate-2';
backup format '/dd_oraback/tkprod/%d_CF_%T_%U' current controlfile TAG='tkprod_CF_13-Dec-11_14:54';
sql 'alter system archive log current';
}


This is show all
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dd_oraback/tkprod/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/dd_oraback/tkprod/rman/snapcf_tkprod.f';


Here's the end of the output
skipping archive log file /u09/ora_arch/tkprod/arch_1_210433_596995708.arc; already backed up 1 time(s)
skipping archive log file /u09/ora_arch/tkprod/arch_1_210434_596995708.arc; already backed up 1 time(s)
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=210435 recid=208452 stamp=769792201
channel ORA_DISK_1: starting piece 1 at 13-DEC-2011 15:10:36
channel ORA_DISK_1: finished piece 1 at 13-DEC-2011 15:10:43
piece handle=/dd_oraback/tkprod/TKPROD_ARC_20111213_mcmu467b_1_1 tag=TKPROD_ARC_13-DEC-11_15:09 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=210436 recid=208453 stamp=769792234
channel ORA_DISK_1: starting piece 1 at 13-DEC-2011 15:10:44
channel ORA_DISK_1: finished piece 1 at 13-DEC-2011 15:10:47
piece handle=/dd_oraback/tkprod/TKPROD_ARC_20111213_mdmu467j_1_1 tag=TKPROD_ARC_13-DEC-11_15:09 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 13-DEC-2011 15:10:47

Starting Control File and SPFILE Autobackup at 13-DEC-2011 15:10:47
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 12/13/2011 15:10:49
ORA-01580: error creating control backup file /dd_oraback/tkprod/snapcf_tkprod.f
ORA-27086: unable to lock file - already in use
SVR4 Error: 22: Invalid argument
Additional information: 9
Additional information: 22

Recovery Manager complete.


Do an ls -al and its there and current.
ls -al /dd_oraback/tkprod/snapcf_tkprod.f
-rw-r-----   1 oracle   dba      20103168 Dec 13 15:10 /dd_oraback/tkprod/snapcf_tkprod.f


anybody got an idea whats going on?

So you know /dd_oraback is a Data Domain mount. Not sure if that makes any difference or not.

Thanks -Rick

Re: RMAN control File auto backup error [message #535381 is a reply to message #535376] Tue, 13 December 2011 21:20 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Most probably your NFS mount is not properly mounted and Oracle is not happy about it.
Post your mount options.
Also check if nfslock status is good.
Previous Topic: obselete backup
Next Topic: Restore dabase + copied archivelogs
Goto Forum:
  


Current Time: Thu Mar 28 10:50:39 CDT 2024