4 Replies Latest reply on May 2, 2012 12:00 AM by user409261

    Rman clone error


      I just did a rman clone and got following errors:
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 05/01/2012 12:24:03
      RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
      ORA-00200: control file could not be created
      ORA-00202: control file: '+DATADG/hcebs/onlinelog/cntrl02.dbf'
      ORA-17502: ksfdcre:4 Failed to create file +DATADG/hcebs/onlinelog/cntrl02.dbf
      ORA-15173: entry 'onlinelog' does not exist in directory 'hcebs'
      Would you please tell me how to fix it? It took about 3 hrs. Hope don't have to run it again.

      System: db:, ebs 12.1.3, linux

      Found from alert.log file
      ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
      ORA-00202: control file: '+DATADG/hcebs/datafile/cntrl01.dbf'

      We don't have controlfile 2 and 3. they were not copied from rman clone.

      Edited by: 907485 on May 1, 2012 11:36 AM
        • 1. Re: Rman clone error
          Tell you how to fix what?

          Do you see a single RMAN command in what you posted?

          We have absolutely no idea what you did other than try to duplicate something somewhere else. We don't know if it is RAC, we don't know whether ASM exists at the auxiliary location, we know next to nothing.

          Please fill in all of the blanks.
          • 2. Re: Rman clone error
            Sorry. This is not a RAC. It is an ASM.

            I am doing a EBS clone. the first step is to clone the database by using rman duplicate. Everything looks good until create controlfile. the first controlfile is created under DATADG/DATAFILE but it is corrupted. The second and the third are not created and the rman stopped at "ORA-17502: ksfdcre:4 Failed to create file DATADG/hcebs/onlinelog/cntrl02.dbf".

            Don't know why +DATADG/hcebs/onlinelog is not created.
            • 3. Re: Rman clone error
              Where on the control files on the source database?

              from the original and then create the control files manually.
              • 4. Re: Rman clone error
                The problem is resolved. I made sure this time all the directories are there and rerun ram.