4 Replies Latest reply: Mar 25, 2013 12:39 AM by Mihael RSS

    ORA-19599: block number 1985 is corrupt in archived log +FG/

    998799
      Hi Team,

      I couldn't take backup of the RAC database archivelog. Please help me

      RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

      Starting backup at 24-MAR-13
      using channel ORA_DISK_1
      channel ORA_DISK_1: starting full datafile backupset
      channel ORA_DISK_1: specifying datafile(s) in backupset
      input datafile fno=00001 name=+DG1/kvxcprd/datafile/system.260.777756857
      input datafile fno=00003 name=+DG1/kvxcprd/datafile/sysaux.268.777756857
      input datafile fno=00002 name=+DG1/kvxcprd/datafile/undotbs1.263.777756857
      input datafile fno=00005 name=+DG1/kvxcprd/datafile/undotbs2.264.777756983
      input datafile fno=00004 name=+DG1/kvxcprd/datafile/users.267.777756857
      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
      channel ORA_DISK_1: starting archive log backupset
      channel ORA_DISK_1: specifying archive log(s) in backup set
      input archive log thread=2 sequence=17 recid=26 stamp=810915691
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/24/2013 14:37:11
      ORA-19599: block number 1985 is corrupt in archived log +FG/kvxcprd/archivelog/2013_03_24/thread_2_seq_17.269.810915689

      RMAN> backup archivelog all;

      Starting backup at 24-MAR-13
      current log archived
      using channel ORA_DISK_1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of backup command at 03/24/2013 14:39:52
      ORA-19563: header validation failed for file

      Thanks & Regards,


      Edited by: 995796 on Mar 24, 2013 2:26 AM

      Edited by: 995796 on Mar 24, 2013 2:27 AM
        • 1. Re: ORA-19599: block number 1985 is corrupt in archived log +FG/
          TSharma-Oracle
          Find which achivelog is corrupted and move the corrupted archive log to different directory, then crosscheck and take the backup. To do this,

          RMAN>Validate archivelog all; then, Move the corrupted archive log

          RMAN>crosscheck archivelog all;

          RMAN>Backup archivelog all;
          • 2. Re: ORA-19599: block number 1985 is corrupt in archived log +FG/
            mseberg
            Hello;

            RESTORE VALIDATE reads all of the backup files that would be needed to restore the specified objects, but the objects are not actually restored to disk.

            So run
            RMAN restore database validate check logical;
            If a backup piece is missing or corrupt the restore validate will automatically check for the availability of previous backups.

            Another option
            restore archivelog all validate;
            Repair block corruptions using Data Recovery Advisor in Oracle 11g

            http://www.oracleracexpert.com/2011/09/repair-block-corruptions-using-data.html

            Best Regards

            mseberg
            • 3. Re: ORA-19599: block number 1985 is corrupt in archived log +FG/
              Hemant K Chitale
              You need to exclude that archivelog from the backup. Rename the archivelog (using asmcmd) and then run CROSSCHECK ARCHIVELOG ALL so that Oracle would mark it as "Expired" when it doesn't find the archivelog. (You can also run a DELETE ARCHIVELOG or DELETE EXPIRED ARCHIVELOG to logically delete it).

              You must document that missing archivelog so that any future recovery required knows that this archivelog is not available, therefore a point in time recovery to any point from the last backup before this archivelog upto a point in time of the archivelog or subsequent to it upto the next backup would not be possible.

              Needless to say, take a fresh database backup.


              Hemant K Chitale
              • 4. Re: ORA-19599: block number 1985 is corrupt in archived log +FG/
                Mihael
                RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

                Starting backup at 24-MAR-13
                using channel ORA_DISK_1
                channel ORA_DISK_1: starting full datafile backupset
                channel ORA_DISK_1: specifying datafile(s) in backupset
                input datafile fno=00001 name=+DG1/kvxcprd/datafile/system.260.777756857
                input datafile fno=00003 name=+DG1/kvxcprd/datafile/sysaux.268.777756857
                input datafile fno=00002 name=+DG1/kvxcprd/datafile/undotbs1.263.777756857
                input datafile fno=00005 name=+DG1/kvxcprd/datafile/undotbs2.264.777756983
                input datafile fno=00004 name=+DG1/kvxcprd/datafile/users.267.777756857
                channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
                channel ORA_DISK_1: starting archive log backupset
                channel ORA_DISK_1: specifying archive log(s) in backup set
                input archive log thread=2 sequence=17 recid=26 stamp=810915691
                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/24/2013 14:37:11
                ORA-19599: block number 1985 is corrupt in archived log +FG/kvxcprd/archivelog/2013_03_24/thread_2_seq_17.269.810915689
                You can remove this log with command
                rman> delete archivelog '+FG/kvxcprd/archivelog/2013_03_24/thread_2_seq_17.269.810915689';