ORA-19625: error identifying file string

I got ” ORA-19625: error identifying file string ”  error in Oracle database.

 

ORA-19625: error identifying file string

 

Details of error are as follows.

ORA-19625: error identifying file string
Cause: A file specified as input to a copy or backup operation, or as the target for an
 incremental restore, could not be identified as an Oracle file. An OS-specific error
 accompanies this error to help pinpoint the problem.

Action: Specify an different file and retry the operation.

RMAN-06059: expected archived log not found, lost of archived log  recoverability
ORA-19625: error identifying file /var/opt/arch_oltp28_1_744738.arc
ORA-27037: unable to obtain file status

 

 

error identifying file string

This ORA-19625 errors are related with file specified as input to a copy or backup operation, or as the target for an
incremental restore, could not be identified as an Oracle file. An OS-specific error accompanies this error to help pinpoint the problem.

To solve this error, Specify an different file and retry the operation.

Try to run the following commands.

RMAN> crosscheck copy of archivelog all
RMAN> crosscheck archivelog all
RMAN> resync catalog
RMAN> delete force obsolete;
RMAN> delete expired archivelog all ;

 

If the problem is not solved,then Files were deleted at OS level and Archive log files were deleted at OS level.

To solve this error, Run the following commands.

 

RMAN> Change archivelog '<Archive log which was deleted>' UNCATALOG ; 

Please note the first archive log name would be present in the error message ORA-19625:


For example :-

RMAN-06059: expected archived log not found, lost of archived log 
ORA-19625: error identifying file /var/opt/arch_oltp28_1_744738.arc 
ORA-27037: unable to obtain file status 


RMAN> Change archivelog '/var/opt/arch_oltp28_1_744738.arc'  uncatalog;

Run the archive log backup command check if you still get the error

Keeping specify the archive log file name reported in ORA-19625 till backup of archive log goes fine

Or

RMAN> Change Archivelog all Uncatalog ;

Please note the above command will uncatalog the information about the Archive log from catalog database.

 

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

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

 

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

Your email address will not be published. Required fields are marked *