RMAN error missing .arc file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN error missing .arc file

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    RMAN error missing .arc file

    I run my crosscheck script

    rman catalog rman/rman target / > $LOG_FILE 2>&1 < CROSSCHECK BACKUP DEVICE TYPE DISK;
    CROSSCHECK ARCHIVELOG ALL;
    DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT OBSOLETE;
    LIST BACKUP SUMMARY;
    EOF
    exit 0

    Than I run my rman backup of archive files code


    rman < connect target /
    connect catalog rman/rman
    sql "alter system archive log current";
    backup filesperset 5 archivelog until time 'sysdate-1/24'
    format $FILE_DEST_ARCH
    delete input ;
    resync catalog;
    EOT

    I get the error below. The errror message is correct as the .arc file is not there but can someody suggest a RMAN command I can use to get rid of
    the error?



    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    ORA-19625: error identifying file /archive/ifdtest3/ifdtest3_2098_1_754908462.arc
    SVR4 Error: 2: No such file or directory


    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name IFDTEST3 are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    CONFIGURE BACKUP OPTIMIZATION OFF; # default
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/ifdtest3/spfile_control_files/%F';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11g/dbs/snapcf_ifdtest3.f'; # default


    I am runing Oracle 11.1.0.7.0 version of the DB,

    Thanks to all who answer

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    'skip inaccessible'

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    The skip innaccessible appeared to work thanks... can somebody explain
    why my crosscheck script did not fix the issue? Or what do I need to add to
    my crosscheck script to fix instead of changing the backup script.

    Thanks

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    crosscheck archivelog all should also work. can you please post the log output from first block?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Jul 2006
    Posts
    195
    ViJay, It appears that the crosscheck archive log all did fix my issue!! Also
    I the skip clause is a good thing to know. Thanks.


    INITIAL ERROR

    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    ORA-19625: error identifying file /archive/ifdtest3/ifdtest3_2752_1_754908462.arc
    SVR4 Error: 2: No such file or directory

    RAN CROSS CHECK SCRIPT

    rman catalog rman/rman target / > $LOG_FILE 2>&1 < CROSSCHECK BACKUP DEVICE TYPE DISK;
    CROSSCHECK ARCHIVELOG ALL;
    DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT OBSOLETE;
    LIST BACKUP SUMMARY;
    EOF
    exit 0

    CROSS CHECK OUTPUT FROM SCRIPT (ONLY INFO FOR PROBLEM .ARC file)

    validation failed for archived log
    archived log file name=/archive/ifdtest3/ifdtest3_2752_1_754908462.arc RECID=2755 STAMP=756824416

    Key Thrd Seq S Low Time
    ------- ---- ------- - -------------------
    10819 1 2752 X 07-18-2011 12:53:52
    Name: /archive/ifdtest3/ifdtest3_2752_1_754908462.arc

    deleted archived log
    archived log file name=/archive/ifdtest3/ifdtest3_2752_1_754908462.arc RECID=2755 STAMP=756824416


    RMAN SCRIPT

    rman catalog rman/rman target / > $LOG_FILE 2>&1 < show all;
    backup filesperset 5 archivelog until time 'sysdate-0/24'
    format '/backup/ifdtest3/arch/arch_%d_t%t_s%s_p%p'
    delete input;
    resync catalog;
    EOF
    exit 0

    RMAN OUTPUT

    Recovery Manager: Release 11.1.0.7.0 - Production on Tue Jul 19 09:28:17 2011

    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    connected to target database: IFDTEST3 (DBID=1448134763)
    connected to recovery catalog database

    RMAN>
    RMAN configuration parameters for database with db_unique_name IFDTEST3 are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    CONFIGURE BACKUP OPTIMIZATION OFF; # default
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/ifdtest3/spfile_control_files/%F';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11g/dbs/snapcf_ifdtest3.f'; # default

    RMAN> 2> 3>
    Starting backup at 07-19-2011 09:28:26
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=917 device type=DISK
    allocated channel: ORA_DISK_2
    channel ORA_DISK_2: SID=989 device type=DISK
    allocated channel: ORA_DISK_3
    channel ORA_DISK_3: SID=975 device type=DISK
    allocated channel: ORA_DISK_4
    channel ORA_DISK_4: SID=940 device type=DISK
    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=2900 RECID=2903 STAMP=756896422
    channel ORA_DISK_1: starting piece 1 at 07-19-2011 09:28:36
    channel ORA_DISK_2: starting archived log backup set
    channel ORA_DISK_2: specifying archived log(s) in backup set
    input archived log thread=1 sequence=2898 RECID=2901 STAMP=756892816
    channel ORA_DISK_2: starting piece 1 at 07-19-2011 09:28:36
    channel ORA_DISK_3: starting archived log backup set
    channel ORA_DISK_3: specifying archived log(s) in backup set
    input archived log thread=1 sequence=2899 RECID=2902 STAMP=756894611
    channel ORA_DISK_3: starting piece 1 at 07-19-2011 09:28:36
    channel ORA_DISK_4: starting archived log backup set
    channel ORA_DISK_4: specifying archived log(s) in backup set
    input archived log thread=1 sequence=2901 RECID=2904 STAMP=756896433
    channel ORA_DISK_4: starting piece 1 at 07-19-2011 09:28:36
    channel ORA_DISK_4: finished piece 1 at 07-19-2011 09:28:37
    piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s241_p1 tag=TAG20110719T092834 comment=NONE
    channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01
    channel ORA_DISK_4: deleting archived log(s)
    archived log file name=/archive/ifdtest3/ifdtest3_2901_1_754908462.arc RECID=2904 STAMP=756896433
    channel ORA_DISK_1: finished piece 1 at 07-19-2011 09:28:39
    piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s238_p1 tag=TAG20110719T092834 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
    channel ORA_DISK_1: deleting archived log(s)
    archived log file name=/archive/ifdtest3/ifdtest3_2900_1_754908462.arc RECID=2903 STAMP=756896422
    channel ORA_DISK_2: finished piece 1 at 07-19-2011 09:28:39
    piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s239_p1 tag=TAG20110719T092834 comment=NONE
    channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
    channel ORA_DISK_2: deleting archived log(s)
    archived log file name=/archive/ifdtest3/ifdtest3_2898_1_754908462.arc RECID=2901 STAMP=756892816
    channel ORA_DISK_3: finished piece 1 at 07-19-2011 09:28:40
    piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s240_p1 tag=TAG20110719T092834 comment=NONE
    channel ORA_DISK_3: backup set complete, elapsed time: 00:00:04
    channel ORA_DISK_3: deleting archived log(s)
    archived log file name=/archive/ifdtest3/ifdtest3_2899_1_754908462.arc RECID=2902 STAMP=756894611
    Finished backup at 07-19-2011 09:28:40

    Starting Control File Autobackup at 07-19-2011 09:28:40
    piece handle=/backup/ifdtest3/spfile_control_files/c-1448134763-20110719-00 comment=NONE
    Finished Control File Autobackup at 07-19-2011 09:28:48

    RMAN>
    starting full resync of recovery catalog
    full resync complete

    RMAN>

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    I didn't see any difference in the script which was through error and which was successful. could you you please high light?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width