9 Replies Latest reply: Jul 14, 2009 2:35 AM by 583730 RSS

    RMAN - "crosscheck archivelog all"

    583730
      Hello everybody.

      I am kind of confused with the output of *"crosscheck archive log all"* and not able to understand clearly. Can somebody please help me understand the output of following two commands.

      LIST ARCHIVELOG ALL;
      CROSSCHECK ARCHIVELOG ALL;

      Is it that "LIST ARCHIVELOG ALL" displays the list of archivelogs that have been backed up by RMAN? and "CROSSCHECK ARCHIVELOG ALL" cross checks those backups taken are available in backup set on disk location or not?

      But if this "LIST ARCHIVELOG ALL" displays the list of archivelogs that have been backed up by RMAN then "LIST BACKUP SUMMARY" should show "A" for archivelog in LV column but it doesn't show "A"

      Any help would be greatly appreciated..

      Thanks
        • 1. Re: RMAN - "crosscheck archivelog all"
          539769
          Is it that "LIST ARCHIVELOG ALL" displays the list of archivelogs that have been backed up by RMAN?
          LIST ARCHIVELOG ALL - is the all archivelogs backed up or not, irrespective of that.
          "CROSSCHECK ARCHIVELOG ALL" cross checks those backups taken are available in backup set on disk location or not?
          No. It cross checks if these archived log files are available in on disk location or not, also irrespective of backups.


          Thanks.
          • 2. Re: RMAN - "crosscheck archivelog all"
            711732
            You can understand "list archivelog all " is equal to "list copy of archivelog all". Following result shown by command is only for list all archived logfiles.
            But "Crosscheck archivelog all" is very usefull for backup or restore to do.You also make attension to status in result of crosschecking.Then,you user delete noprompt obsolete or backup database plus archivelog delet input command to delete those archived logfiles with failed check status .
            • 3. Re: RMAN - "crosscheck archivelog all"
              539769
              "Crosscheck archivelog all" is very usefull for backup or restore to do.
              Backup and restore has got nothing to do with this command. During backup it should be the checklist to do the same but during restore it is not needed. OP is more interested in the result of command.

              Thanks.
              • 4. Re: RMAN - "crosscheck archivelog all"
                583730
                I Appreciate your quick reply...

                But this "LIST ARCHIVELOG ALL" shows only some few archivelog files... but i have lot more archivelogs actually available on my disk.. Why LIST command only shows few not all of these? Any idea..

                Thanks
                • 5. Re: RMAN - "crosscheck archivelog all"
                  711732
                  RMAN> list copy of archivelog sequence 25;


                  List of Archived Log Copies
                  Key Thrd Seq S Low Time Name
                  ------- ---- ------- - --------- ----
                  44 1 25 A 14-JUL-09 D:\ORACLE\PRODUCT\10.2.0\ORADATA\EMREP\ARCH1\ARC00025_0691924459.001

                  RMAN> backup as copy archivelog sequence 25;

                  Starting backup at 14-JUL-09
                  using channel ORA_DISK_1
                  channel ORA_DISK_1: starting archive copy
                  input archive log thread=1 sequence=25 recid=44 stamp=692198588
                  output filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\EMREP\ARCHIVELOG\2009_07_14\O1_MF_1_25_55R7COF5_.ARC recid
                  =106 stamp=692200437
                  channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
                  Finished backup at 14-JUL-09

                  RMAN> list archivelog sequence 25;


                  List of Archived Log Copies
                  Key Thrd Seq S Low Time Name
                  ------- ---- ------- - --------- ----
                  106 1 25 A 14-JUL-09 D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\EMREP\ARCHIVELOG\2009_07_14\O1_MF_1_25_55R7COF5_.ARC
                  44 1 25 A 14-JUL-09 D:\ORACLE\PRODUCT\10.2.0\ORADATA\EMREP\ARCH1\ARC00025_0691924459.001

                  RMAN> list copy of archivelog sequence 25;


                  List of Archived Log Copies
                  Key Thrd Seq S Low Time Name
                  ------- ---- ------- - --------- ----
                  106 1 25 A 14-JUL-09 D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\EMREP\ARCHIVELOG\2009_07_14\O1_MF_1_25_55R7COF5_.ARC
                  44 1 25 A 14-JUL-09 D:\ORACLE\PRODUCT\10.2.0\ORADATA\EMREP\ARCH1\ARC00025_0691924459.001

                  Manually delete archivelog:

                  C:\Documents and Settings\zhao>d:

                  D:\>del D:\ORACLE\PRODUCT\10.2.0\ORADATA\EMREP\ARCH1\ARC00025_0691924459.001

                  RMAN> list copy of archivelog sequence 25;


                  List of Archived Log Copies
                  Key Thrd Seq S Low Time Name
                  ------- ---- ------- - --------- ----
                  106 1 25 A 14-JUL-09 D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\EMREP\ARCHIVELOG\2009_07_14\O1_MF_1_25_55R7COF5_.ARC
                  44 1 25 A 14-JUL-09 D:\ORACLE\PRODUCT\10.2.0\ORADATA\EMREP\ARCH1\ARC00025_0691924459.001


                  RMAN> backup archivelog sequence 25;

                  Starting backup at 14-JUL-09
                  allocated channel: ORA_DISK_1
                  channel ORA_DISK_1: sid=133 devtype=DISK
                  archived log D:\ORACLE\PRODUCT\10.2.0\ORADATA\EMREP\ARCH1\ARC00025_0691924459.001 not found or out of sync with catalog

                  trying alternate file for archivelog thread 1, sequence 25
                  channel ORA_DISK_1: starting archive log backupset
                  channel ORA_DISK_1: specifying archive log(s) in backup set
                  input archive log thread=1 sequence=25 recid=106 stamp=692200437
                  channel ORA_DISK_1: starting piece 1 at 14-JUL-09
                  channel ORA_DISK_1: finished piece 1 at 14-JUL-09
                  piece handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\EMREP\BACKUPSET\2009_07_14\O1_MF_ANNNN_TAG20090714T135825_55R
                  7N31G_.BKP tag=TAG20090714T135825 comment=NONE
                  channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
                  Finished backup at 14-JUL-09

                  You found that if you don't crosscheck archivelog, rman first try to backup original archived log ,but it is invalid ,rman try to other copy or backups. Process of restore is the same.
                  So I mean that crosscheck is a auxiliary function for backup or restore.
                  • 6. Re: RMAN - "crosscheck archivelog all"
                    709855
                    LIST ARCHIVELOG ALL;
                    It show the list of archive log backup but if some files are physical deleted from OS it did not check and
                    CROSSCHECK ARCHIVELOG ALL;
                    RMAN check the files are physical check the location that backup list of archive log are presented or not if some files are missing it show you error. and as precaution measure you should take the backup of whole database.

                    Hope it will give you clear idea.

                    Regards,
                    Muzafar
                    • 7. Re: RMAN - "crosscheck archivelog all"
                      583730
                      That's a good description.

                      But i am concerned with the output of "LIST ARCHIVELOG ALL" if this command displays all archive logs of the database then i wanted to know why it displays only few archive files and doesn't display all the files and seq num which exists in my archive log disk location..

                      And when i run CROSSCHECK it does crosscheck all the files successfully which are displayed in LIST command but those only few files not all.

                      Any idea.. any help or suggestion would be great.

                      Thanks
                      • 8. Re: RMAN - "crosscheck archivelog all"
                        539769
                        Post the commands and outputs.

                        Regards.
                        • 9. Re: RMAN - "crosscheck archivelog all"
                          583730
                          RMAN> LIST ARCHIVELOG ALL;

                          List of Archived Log Copies
                          Key Thrd Seq S Low Time Name
                          ------- ---- ------- - --------- ----
                          24512 1 9644 A 04-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_9644_1_663312703.arc
                          24515 1 9645 A 04-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_9645_1_663312703.arc
                          24518 1 9646 A 04-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_9646_1_663312703.arc
                          24521 1 9647 A 04-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_9647_1_663312703.arc
                          ..
                          ..
                          ..
                          25733 1 10051 A 14-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_10051_1_663312703.arc
                          25736 1 10052 A 14-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_10052_1_663312703.arc
                          25739 1 10053 A 14-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_10053_1_663312703.arc
                          25742 1 10054 A 14-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_10054_1_663312703.arc
                          25745 1 10055 A 14-JUL-09 /u01/app/oracle/archive/oracle/ARCH_ORACL_10055_1_663312703.arc

                          Totally its 412 files

                          And then i ran following

                          RMAN>CROSSCHECK ARCHIVELOG ALL:

                          It crosschecked all 412 archivelog successfully..

                          At Unix cmd prompt i went to archive dest location and did "ls" following is the output..

                          *$ pwd*
                          Archivelog destionation
                          *$ ls -ltr*
                          -rw-r----- 1 oracle oinstall 5241856 May 15 20:15 ARCH_ORACL_7669_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 5241856 May 15 20:57 ARCH_ORACL_7670_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 5913600 May 15 20:59 ARCH_ORACL_7671_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 8413184 May 15 21:02 ARCH_ORACL_7672_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 9550848 May 15 22:00 ARCH_ORACL_7673_1_663312703.arc
                          ..
                          ..
                          -rw-r----- 1 oracle oinstall 5243392 Jul 14 01:01 ARCH_ORACL_10051_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 5421056 Jul 14 01:39 ARCH_ORACL_10052_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 5241856 Jul 14 02:01 ARCH_ORACL_10053_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 5467648 Jul 14 02:50 ARCH_ORACL_10054_1_663312703.arc
                          -rw-r----- 1 oracle oinstall 5241856 Jul 14 03:06 ARCH_ORACL_10055_1_663312703.arc

                          This shows more than 412 files..

                          So why the LIST command only shows few files from seq# 9644 to 10055, where as physically i have archives from 7669 to 10055..

                          Any idea.. Or what exactly do this "LIST ARCHIVELOG ALL;" output indicate?

                          Please any help would be great.

                          Thanks