5 Replies Latest reply: Jun 19, 2011 3:13 PM by 571299 RSS

    11g RMAN clone error

    571299
      Hi all,

      Need a bit of advice/assistance here. I have rdbms 11gR2 installed on a Windows 32bit box.

      Trying to perform rman duplicate using active database:

      RMAN> duplicate target database
      2> to neworcl
      3> nofilenamecheck from active database
      4> spfile parameter_value_convert 'E:\oradata\orcl','E:\oradata\neworcl'
      5> SET LOG_FILE_NAME_CONVERT ='E:\oradata\orcl','E:\oradata\neworcl'
      6> SET DB_FILE_NAME_CONVERT ='E:\oradata\orcl','E:\oradata\neworcl'
      7> ;

      I keep getting an error even tho archive seq 17 does not exist in the backup folder?

      Any help is much appreciated.

      ############################################################

      sql statement: alter system archive log current

      contents of Memory Script:
      {
      backup as copy reuse
      archivelog like "E:\ORADATA\BACKUP\ARC0000000017_0753664914.0001" auxiliary for
      mat
      "E:\ORADATA\BACKUP\ARC0000000017_0753664914.0001" ;
      catalog clone archivelog "E:\ORADATA\BACKUP\ARC0000000017_0753664914.0001";
      switch clone datafile all;
      }
      executing Memory Script

      Starting backup at 19-JUN-11
      using channel ORA_DISK_1
      channel ORA_DISK_1: starting archived log copy
      input archived log thread=1 sequence=17 RECID=24 STAMP=754253358
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/19/2011 18:49:19
      ORA-19599: block number 1 is corrupt in archived log E:\ORADATA\BACKUP\ARC000000001
      7_0753664914.0001
      channel ORA_DISK_1 disabled, job failed on it will be run on another channel
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 06/19/2011 18:49:19
      RMAN-03015: error occurred in stored script Memory Script

      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/19/2011 18:49:19
      ORA-19599: block number 1 is corrupt in archived log E:\ORADATA\BACKUP\ARC000000001
      7_0753664914.0001
        • 1. Re: 11g RMAN clone error
          sb92075
          I keep getting an error even tho archive seq 17 does not exist in the backup folder?
          Oracle seems to think the error is as stated below.
          RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/19/2011 18:49:19
          ORA-19599: block number 1 is corrupt in archived log E:\ORADATA\BACKUP\ARC0000000017_0753664914.0001
          how or why did this file get corrupted?
          • 2. Re: 11g RMAN clone error
            571299
            Hence my query. I am doing a simple clone with NO archivelogs or backups. The corrupted file does not exist inn the backup location either. My question too - how or why did this file get corrupted?
            • 3. Re: 11g RMAN clone error
              sb92075
              nickn wrote:
              Hence my query. I am doing a simple clone with NO archivelogs or backups. The corrupted file does not exist inn the backup location either. My question too - how or why did this file get corrupted?
              It is your system; not mine.
              I only know what you post.

              Do any clues exist within OS log files?
              Do any clues exist within alert_SID.log file for this DB?
              • 4. Re: 11g RMAN clone error
                571299
                Thanks. Sorry for not making it clear in my initial post!

                Nothing is OS logs.

                The alert logs shows. But the fact that this archive does not exist , could it be an issue with the redo3?

                Thread 1 advanced to log sequence 18 (LGWR switch)
                Current log# 3 seq# 18 mem# 0: E:\ORADATA\ORCL\REDO03.LOG
                Archived Log entry 24 added for thread 1 sequence 17 ID 0x4c618378 dest 1:
                Sun Jun 19 18:49:19 2011
                ***
                Corrupt block seq: 17 blocknum=1.
                Bad header found during backing up archived log
                Data in bad block - seq:0. bno:0. time:0
                beg:0 cks:0
                calculated check value: 0
                Reread of seq=17, blocknum=1, file=E:\ORADATA\BACKUP\ARC0000000017_0753664914.0001, found same corrupt data
                • 5. Re: 11g RMAN clone error
                  571299
                  Any advice would be appreciated !