ORA-19505

Failed to identify file in RMAN: ORA-19505

 

After configuring the target database with the RMAN first time. I try to take database backup through RMAN and found the following error:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ch00 channel at 03/26/2012 13:01:03

ORA-19505: failed to identify file “/oraback/arch/1_1100721_664058960.dbf”

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

 

In this case nothing happened with your backup command. If you read the error, it is saying particular archive logfile is not available. This may be due to file deleted at OS level due to some reason. In this situation, do the following

 

1. Run crosscheck command against archivelogs

RMAN>Crosscheck archivelog all;

 

2. If you find any archives marked as EXPIRED, then delete those expired archives

RMAN>Delete expired archivelog all;

 

This will prompt you YES or NO. If you don’t want a prompt

RMAN>Delete noprompt archivelog all;

 

3. Then take a fresh archivelog backup

RMAN>Backup archivelog all;