ORA-19505: failed to identify file “string”

I got ” ORA-19505: failed to identify file “string” ”  error in Oracle database.

 

ORA-19505: failed to identify file “string”

 

Details of error are as follows.

ORA-19505: failed to identify file "string"

Cause: call to identify the file returned an error

Action: check additional messages, and check if the file exists

During a RMAN DUPLICATE, the following errors occurs:

ORA-19505: failed to identify file "/<path>/flash_recovery_area/<SID>/backupset/2007_07_16/o1_mf_nnndf_FULL_DB_BKUP_39qkz853_.bkp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information:
ORA-19870: error reading backup piece /<path>/flash_recovery_area/<SID>/backupset/2007_07_16/o1_mf_nnndf_FULL_DB_BKUP_39qkz867_.bkp
ORA-19505: failed to identify file "/<path>/flash_recovery_area/<SID>/backupset/2007_07_16/o1_mf_nnndf_FULL_DB_BKUP_39qkz867_.bkp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information:
failover to previous backup

 

 

failed to identify file “string

This ORA-19505 error is related to the call to identify the file returned an error.

To solve this error, check additional messages, and check if the file exists.

Run the crosscheck, then delete the expired archivelog as follows.

RMAN> crosscheck archivelog all;



RMAN> delete expired archivelog all;

 

 

If you got this error during a RMAN DUPLICATE, A backup was taken on the target and moved to the auxiliary server in a different location.   The auxiliary instance is a separate standalone box with a different file structure.  RMAN duplicate is attempting to access the backup from the location from which it was taken.  I.e., from the target server location.

The error is occurring because the auxiliary server cannot access the backup files on the destination server.

 

NOTE: As of 11.2.0.4 and higher, if the backups on the auxiliary server are in a different location, you can run targetless duplicate with ‘backup location’ option. See: Note:1375864.1 Perform Backup Based RMAN DUPLICATE Without Connecting To Target Database For Both Disk & Tape Backups.

The following must work on the Auxiliary instance:

 

$ ls /<path>/flash_recovery_area/<SID>/backupset/2020_07_16/

As long as RMAN is able to connect to the primary and duplicate instances, the RMAN client can run on any machine. However, all backups, copies of datafiles, and archived logs used for creating and recovering the duplicate database must be accessible by the auxiliary instance on the auxiliary host.

If the duplicate host is different from the target host, then you must make backups and copies on the primary/target host available to the remote node with the same full path name as the primary/target database. You can accomplish this goal in two ways:

1) Using an operating system utility to move the backup pieces, image copies,
and archived logs from the primary host to the remote host to an identical path

2) Using NFS or shared disks and making sure that the same path is accessible in the remote host

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 578 views last month,  8 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply