OraFAQ Forum: Backup & Recovery » RMAN

Home » RDBMS Server » Backup & Recovery » RMAN - ORA-19513 et ORA-27206

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

RMAN - ORA-19513 et ORA-27206 [message #253571]

Tue, 24 July 2007 06:02

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.

Report message to a moderator

Re: RMAN - ORA-19513 et ORA-27206 [message #253650 is a reply to message #253571]

Tue, 24 July 2007 09:11

Frank Naude
Messages: 4596
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.

Report message to a moderator

Re: RMAN - ORA-19513 et ORA-27206 [message #253879 is a reply to message #253571]

Wed, 25 July 2007 03:39

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.

Report message to a moderator