1 Reply Latest reply on Apr 14, 2013 7:59 AM by Hussein Sawwan-Oracle

    Error Encountered in Rapid Clone

    1002924
      Hi All,

      I have single node server
      EBS 12.1.3
      database 11.2.0.2
      and OS Win server 2003

      while running perl adcfgclone.pl dbTier

      i have encountered the following error*

      ERROR at line 1:
      ORA-01119: error in creating database file
      'E:\CLONEORA\CLONE11GDB\11.2.0\DATABASE\MISSING00050'
      ORA-27041: unable to open file
      OSD-04002: unable to open file
      O/S-Error: (OS 2) The system cannot find the file specified.
      ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4754
      ORA-06512: at line 1


      ORACLE instance shut down.
      Connected to an idle instance.
      ORACLE instance started.

      Total System Global Area 1071333376 bytes
      Fixed Size          1388344 bytes
      Variable Size          427819208 bytes
      Database Buffers     629145600 bytes
      Redo Buffers          12980224 bytes

      Control file created.


      Database altered.


      Tablespace altered.


      Database altered.


      Alert log file shows

      Tablespace 'TEMP' #2 found in data dictionary,
      but not in the controlfile. Adding to controlfile.
      File #50 found in data dictionary but not in controlfile.
      Creating OFFLINE file 'MISSING00050' in the controlfile.
      This file can no longer be recovered so it must be dropped.
      File #51 found in data dictionary but not in controlfile.
      Creating OFFLINE file 'MISSING00051' in the controlfile.
      This file can no longer be recovered so it must be dropped.
      File #52 found in data dictionary but not in controlfile.
      Creating OFFLINE file 'MISSING00052' in the controlfile.
      This file can no longer be recovered so it must be dropped.


      Plz help me to overcome this issue


      Many Thanks !!

      Regards,
      Saeed

      Edited by: 999921 on Apr 14, 2013 12:41 AM
        • 1. Re: Error Encountered in Rapid Clone
          Hussein Sawwan-Oracle
          Please see the following docs.

          How to quickly check that Database is consistent after incomplete recovery (Point in Time Recovery) before OPEN RESETLOGS [ID 1354256.1]
          Messages in the alert.log (ORA-00376 Error 376 encountered while recovering transaction) after partial restore and open resetlogs. [ID 283846.1]
          RMAN DUPLICATE completes with a missing datafile [ID 433099.1]

          Thanks,
          Hussein