Home » RDBMS Server » Backup & Recovery » RMAN - ORA-19513 et ORA-27206
RMAN - ORA-19513 et ORA-27206 [message #253571] Tue, 24 July 2007 06:02 Go to next message
poc58
Messages: 3
Registered: July 2007
Location: Sion
Junior Member
Hi All !
I'm not an english speaker, please sorry for the errors...
I have a problem with Rman. I backup with this script :

connect catalog rman/rman@catalog
connect target system/manager@base
configure controlfile autobackup on;
run {
allocate channel t1 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=server,NSR_CLIENT=base-oracle)';
SQL 'alter system archive log current';
backup archivelog all delete input;
release channel t1;
}


and, first time all was OK, but the second time it is KO with the message :

RMAN-03009: failure of backup command on t1 channel at 07/24/2007 12:59:41
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog continuing other job steps, job failed will not be re-run


Someone has a idea?
Thanks Poc.
Re: RMAN - ORA-19513 et ORA-27206 [message #253650 is a reply to message #253571] Tue, 24 July 2007 09:11 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Do you have any archlog files that needs to be back up? If not, you can expect messages like this.

19513, 00000, "failed to identify sequential file"
// *Cause:  Unable to identify the sequential file.
// *Action: Check additional messages, and check if the file exists on media.



27206, 00000, "requested file not found in media management catalog"
// *Cause:  A backup file used in a recovery manager catalog maintenance
//          command was not found in the media management catalog.
// *Action: Retry the command with a different file.
Re: RMAN - ORA-19513 et ORA-27206 [message #253879 is a reply to message #253571] Wed, 25 July 2007 03:39 Go to previous messageGo to next message
poc58
Messages: 3
Registered: July 2007
Location: Sion
Junior Member
OK, but...
Why when I do that it's ok ?

connect catalog rman/rman@catalog
connect target system/manager@base
configure controlfile autobackup on;
run {
allocate channel d1 type disk;
send 'NSR_ENV=(NSR_SERVER=server,NSR_CLIENT=base_oracle)';
backup
filesperset 4
format='d:\cp_arc\test_cp'
current controlfile;

release channel d1;
}

I don't understand.
Thank.
Poc.
Re: RMAN - ORA-19513 et ORA-27206 [message #253970 is a reply to message #253879] Wed, 25 July 2007 07:09 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
That's because the controlfile is not deleted after it's backed up - you can backup it more than once.
Re: RMAN - ORA-19513 et ORA-27206 [message #253977 is a reply to message #253571] Wed, 25 July 2007 07:19 Go to previous message
poc58
Messages: 3
Registered: July 2007
Location: Sion
Junior Member
That does not explain me why that does not function with sbt_tape type ???
Poc.
Previous Topic: backup failed
Next Topic: Rman recovery its urgent
Goto Forum:
  


Current Time: Sun Dec 04 06:49:08 CST 2016

Total time taken to generate the page: 0.19911 seconds