Wednesday, October 8, 2014

ORA-19625: error identifying file

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Starting backup at 09-OCT-14
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 10/09/2014 00:16:23
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/oradata/archive/1_241_850299214.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Cause: RMAN can not find the following archive log file in corresponding destination cause of expire or delete file.

Solution: You can check your expire archive log list and delete expired archive log files from RMAN, If you really lost your archive log file and you are not able to collect this file.


RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=98 device type=DISK
validation failed for archived log
archived log file name=/u01/app/oracle/oradata/archive/1_241_850299214.arc RECID=351 STAMP=860457193
validation failed for archived log
archived log file name=/u01/app/oracle/oradata/archive/1_242_850299214.arc RECID=351 STAMP=860457670
validation succeeded for archived log
archived log file name=/u01/app/oracle/oradata/archive/1_243_850299214.arc RECID=352 STAMP=860458582
Crosschecked 3 objects


RMAN> DELETE EXPIRED ARCHIVELOG ALL;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=98 device type=DISK
List of Archived Log Copies for database with db_unique_name ORA11GS
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
2730    1    241     X 08-OCT-14
        Name: /u01/app/oracle/oradata/archive/1_241_850299214.arc

3002    1    242     X 08-OCT-14
        Name: /u01/app/oracle/oradata/archive/1_242_850299214.arc


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/app/oracle/oradata/archive/1_241_850299214.arc RECID=351 STAMP=860457193
deleted archived log
archived log file name=/u01/app/oracle/oradata/archive/1_242_850299214.arc RECID=351 STAMP=860457670
Deleted 2 EXPIRED objects

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;


Starting backup at 09-OCT-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=243 RECID=352 STAMP=860458582
input archived log thread=1 sequence=244 RECID=353 STAMP=860459023
channel ORA_DISK_1: starting piece 1 at 09-OCT-14
channel ORA_DISK_1: finished piece 1 at 09-OCT-14
piece handle=/u01/rman_backup/ora11gs_bkp_1gpkj40g tag=TAG20141009T002344 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/oradata/archive/1_243_850299214.arc RECID=352 STAMP=860458582
archived log file name=/u01/app/oracle/oradata/archive/1_244_850299214.arc RECID=353 STAMP=860459023
Finished backup at 09-OCT-14

Starting backup at 09-OCT-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ora11gp/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ora11gp/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ora11gp/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ora11gp/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-OCT-14
channel ORA_DISK_1: finished piece 1 at 09-OCT-14
piece handle=/u01/rman_backup/ora11gs_bkp_1hpkj40h tag=TAG20141009T002345 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
Finished backup at 09-OCT-14

Starting backup at 09-OCT-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=245 RECID=354 STAMP=860459111
channel ORA_DISK_1: starting piece 1 at 09-OCT-14
channel ORA_DISK_1: finished piece 1 at 09-OCT-14
piece handle=/u01/rman_backup/ora11gs_bkp_1ipkj437 tag=TAG20141009T002511 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/oradata/archive/1_245_850299214.arc RECID=354 STAMP=860459111
Finished backup at 09-OCT-14

Starting Control File and SPFILE Autobackup at 09-OCT-14
piece handle=/u01/rman_backup/bkp_cf_c-3519562480-20141009-01 comment=NONE
Finished Control File and SPFILE Autobackup at 09-OCT-14

RMAN>

6 comments:

  1. HI Rajiv,

    I am facing the above same issue. But that particular archive log file is very important. So is there any way for us to recover that file. We don't have that file in out /databasr/archives/ location.

    Thanks,
    Param

    ReplyDelete
  2. I have Datafiles (dbf) only. Deleted Archive Log does not exist on the production server(Source) , I have a completely new Archivelog with different Datafiles name. But would like to Restore the old Datafiles and import these datafiles into another oracle Instance (Destination). I am testing the dbf file on a windows server 2008 (Destination) while the Datafiles (Source) from HP-Unix OS. Getting Error 19625,Ora-04001 RMAN-03002 failure of conversion,Ora-27048 and OSD-04001 Kindly advise

    ReplyDelete
    Replies
    1. You can use the DB_FILE_NAME_CONVERT='old location' ,'new location' and LOG_FILE_NAME_CONVERT='old location' ,'new location' in your pfile before restore database.

      or

      use SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/orcl/system01.dbf';
      in your RMAN restore scripts

      Delete
  3. I have Datafiles (dbf) only. Deleted Archive Log does not exist on the production server(Source) , I have a completely new Archivelog with different Datafiles name. But would like to Restore the old Datafiles and import these datafiles into another oracle Instance (Destination). I am testing the dbf file on a windows server 2008 (Destination) while the Datafiles (Source) from HP-Unix OS. Getting Error 19625,Ora-04001 RMAN-03002 failure of conversion,Ora-27048 and OSD-04001 Kindly advise

    ReplyDelete
  4. Explanation is very good the way u explained is very nice,want more information about oracle oracle fusion financials online training

    ReplyDelete

  5. Iam so thrilled because of finding your alluring website here.Actually i was searching for Oracle DBA.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle APEX.Thank you soo much..

    ReplyDelete