This discussion is archived
4 Replies Latest reply: May 1, 2012 5:00 PM by user409261 RSS

Rman clone error

user409261 Newbie
Currently Being Moderated
Hi:

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: 11.1.0.7, 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
    damorgan Oracle ACE Director
    Currently Being Moderated
    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
    user409261 Newbie
    Currently Being Moderated
    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
    damorgan Oracle ACE Director
    Currently Being Moderated
    Where on the control files on the source database?

    Consider
    ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
    from the original and then create the control files manually.
  • 4. Re: Rman clone error
    user409261 Newbie
    Currently Being Moderated
    Thanks.
    The problem is resolved. I made sure this time all the directories are there and rerun ram.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points