8 Replies Latest reply: Nov 29, 2012 2:55 PM by Osama_Mustafa RSS

    RMAN-06024: no backup or copy of the control file found to restore

      Dear all

      I am performing Tablespace Point-in-Time Recovery of users tablespace in Oracle 11g. But am getting errors. I have searched the forum but am getting solution that not helping my scenario

      I have performed backup of tablespace users as

      RMAN> backup tablespace users;

      Starting backup at 28-NOV-12
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=132 device type=DISK
      channel ORA_DISK_1: starting full datafile backup set
      channel ORA_DISK_1: specifying datafile(s) in backup set
      input datafile file number=00004 name=C:\APP\ORA\ORADATA\ORCL\USERS01.DBF
      channel ORA_DISK_1: starting piece 1 at 28-NOV-12
      channel ORA_DISK_1: finished piece 1 at 28-NOV-12
      F_TAG20121128T184604_8CDDFXRS_.BKP tag=TAG20121128T184604 comment=NONE
      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
      Finished backup at 28-NOV-12

      Starting Control File and SPFILE Autobackup at 28-NOV-12
      piece handle=C:\APP\ORA\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2012_11_28\O1_MF_S_8
      00563566_8CDDG056_.BKP comment=NONE
      Finished Control File and SPFILE Autobackup at 28-NOV-12


      Then run TSPITR in run block as follow

      RMAN> run{
      2> recover tablespace users
      3> until time "to_date('28-NOV-12 18:38:00', 'DD-MON-YY HH24:MI:SS')"
      4> auxiliary destination 'c:\app\auxiliary';
      5> }

      Starting recover at 28-NOV-12
      using channel ORA_DISK_1
      RMAN-05026: WARNING: presuming following set of tablespaces applies to specified
      point in time

      List of tablespaces expected to have UNDO segments
      Tablespace SYSTEM
      Tablespace UNDOTBS1

      Creating automatic instance, with SID='lbno'

      initialization parameters used for automatic instance:
      #No auxiliary parameter file used

      starting up automatic instance ORCL

      Oracle instance started

      Total System Global Area 200876032 bytes

      Fixed Size 1332104 bytes
      Variable Size 146803832 bytes
      Database Buffers 50331648 bytes
      Redo Buffers 2408448 bytes
      Automatic instance created

      contents of Memory Script:
      # set the until clause
      set until time "to_date('28-NOV-12 18:38:00', 'DD-MON-YY HH24:MI:SS')";
      # restore the controlfile
      restore clone controlfile;
      # mount the controlfile
      sql clone 'alter database mount clone database';
      # archive current online log for tspitr to a resent until time
      sql 'alter system archive log current';
      # avoid unnecessary autobackups for structural changes during TSPITR
      sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
      executing Memory Script

      executing command: SET until clause

      Starting restore at 28-NOV-12
      allocated channel: ORA_AUX_DISK_1
      channel ORA_AUX_DISK_1: SID=41 device type=DISK

      Removing automatic instance
      shutting down automatic instance
      Oracle instance shut down
      Automatic instance removed
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of recover command at 11/28/2012 19:50:31
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06026: some targets not found - aborting restore
      RMAN-06024: no backup or copy of the control file found to restore

      Plz any help to resolve this errors will be appreciated!!