OraFAQ Forum: Backup & Recovery » Issue in SPFILE Autobackup

Home » RDBMS Server » Backup & Recovery » Issue in SPFILE Autobackup (Oracle -11.2.0.3.0 /Rehat Linux x86_64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue in SPFILE Autobackup [message #577508]

Sun, 17 February 2013 14:01

sbmk_design
Messages: 88
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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Issue in SPFILE Autobackup [message #577513 is a reply to message #577509]

Sun, 17 February 2013 14:32

sbmk_design
Messages: 88
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 ?

Report message to a moderator

Re: Issue in SPFILE Autobackup [message #577514 is a reply to message #577513]

Sun, 17 February 2013 15:13

sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI

Member

If "insufficient OS permission" means.... control file get created in the same loaction.

Report message to a moderator

Re: Issue in SPFILE Autobackup [message #577515 is a reply to message #577508]

Sun, 17 February 2013 20:57

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 ?

Report message to a moderator

Previous Topic:	Rman status report
Next Topic:	crosscheck command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:10:27 CST 2024