Home » RDBMS Server » Backup & Recovery » Issue in SPFILE Autobackup (Oracle -11.2.0.3.0 /Rehat Linux x86_64)
Issue in SPFILE Autobackup [message #577508] Sun, 17 February 2013 14:01 Go to next message
sbmk_design
Messages: 87
Registered: April 2007
Location: CHENNAI
Member
My RMAN setup
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora/backup/db/abcd/autobackup/%F';

Error
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on c1 channel at 02/17/2013 03:28:54
ORA-19504: failed to create file "/ora/backup/db/abcd/autobackup/c-2045358238-20130217-00"
ORA-17502: ksfdcre:/ora/backup/db/abcd/autobackup/c-2045358238-20130217-00 Failed to create file

But actually I checked @ /ora/backup/db/abcd/autobackup
Two files exist
-rw-r----- 1 oracle oinstall 9994240 Feb 17 01:31 c-2045358238-20130217-00
-rw-r----- 1 oracle oinstall 10027008 Feb 17 04:00 c-2045358238-20130217-01

RAMN > List backup summary ;
There is only one entry. I think both the above are control files. There is no entry for spfile
369 17-FEB-13 TAG20130217T040050

I also ensured database is running on spfile.
Please how to fix this issue.

Regards
sbmk

[Updated on: Sun, 17 February 2013 14:24]

Report message to a moderator

Re: Issue in SPFILE Autobackup [message #577509 is a reply to message #577508] Sun, 17 February 2013 14:10 Go to previous messageGo to next message
BlackSwan
Messages: 23133
Registered: January 2009
Senior Member
19504, 00000, "failed to create file \"%s\""
// *Cause:  call to create file returned an error
// *Action: check additional messages, check access permissions
[oracle@localhost ~]$ oerr ora 17502
17502, 00000, "ksfdcre:%s Failed to create file %s"
// *Cause:  file creation failed due to either insufficient OS permission or
//          the file already exists
// *Action: check additional error messages

file got created at 01:31 so error gets thrown at 03:28:54 when when it is run AGAIN.
Re: Issue in SPFILE Autobackup [message #577513 is a reply to message #577509] Sun, 17 February 2013 14:32 Go to previous messageGo to next message
sbmk_design
Messages: 87
Registered: April 2007
Location: CHENNAI
Member
Ok.. spfile get created means.. there should be two entries on RAMN > List backup summary ;
But there is only one entry (I think its control file entry)
Any other rman configuration for spfile ?
Re: Issue in SPFILE Autobackup [message #577514 is a reply to message #577513] Sun, 17 February 2013 15:13 Go to previous messageGo to next message
sbmk_design
Messages: 87
Registered: April 2007
Location: CHENNAI
Member
If "insufficient OS permission" means.... control file get created in the same loaction.
Re: Issue in SPFILE Autobackup [message #577515 is a reply to message #577508] Sun, 17 February 2013 20:57 Go to previous message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
The SPFILE Backup is in the same BackupPiece as the Controlfile AutoBackup.

Have you tried
LIST BACKUP OF CONTROLFILE
LIST BACKUP OF SPFILE
commands ?
Previous Topic: Rman status report
Next Topic: crosscheck command
Goto Forum:
  


Current Time: Wed Dec 17 20:32:54 CST 2014

Total time taken to generate the page: 0.12472 seconds