IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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 )
