7 Replies Latest reply: Jul 23, 2013 10:12 PM by Hemant K Chitale RSS

    Getting "RMAN-20201: datafile not found  in the recovery catalog" Error

    ArniG

      Hi All,

      I am trying to perform TSPITR(Tablespace Point in Time Recovery).I am trying to bring back/recover a table of a self-contained tablespace upto certain point in time.

      I am using Oracle 11g version 11.2.0.1.0. I am getting the below error:

       

      RMAN> recover tablespace pun

      2> until time "to_date('18-07-13 19:33:00','dd-mm-yy hh24:mi:ss')"

      3> auxiliary destination 'E:\TSPITR';

       

      Starting recover at 18-JUL-13

      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='vdgo'

       

      initialization parameters used for automatic instance:

      db_name=ORCL

      db_unique_name=vdgo_tspitr_ORCL

      compatible=11.2.0.0.0

      db_block_size=8192

      db_files=200

      sga_target=280M

      processes=50

      db_create_file_dest=E:\TSPITR

      log_archive_dest_1='location=E:\TSPITR'

      #No auxiliary parameter file used

       

       

      starting up automatic instance ORCL

       

      Oracle instance started

       

      Total System Global Area     292278272 bytes

       

      Fixed Size                     2175128 bytes

      Variable Size                100667240 bytes

      Database Buffers             184549376 bytes

      Redo Buffers                   4886528 bytes

      Automatic instance created

      Running TRANSPORT_SET_CHECK on recovery set tablespaces

      TRANSPORT_SET_CHECK completed successfully

       

      contents of Memory Script:

      {

      # set requested point in time

      set until  time "to_date('18-07-13 19:33:00','dd-mm-yy hh24:mi:ss')";

      # restore the controlfile

      restore clone controlfile;

      # mount the controlfile

      sql clone 'alter database mount clone database';

      # archive current online log

      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 18-JUL-13

      allocated channel: ORA_AUX_DISK_1

      channel ORA_AUX_DISK_1: SID=81 device type=DISK

       

      channel ORA_AUX_DISK_1: starting datafile backup set restore

      channel ORA_AUX_DISK_1: restoring control file

      channel ORA_AUX_DISK_1: reading from backup piece C:\APP\ARNAB\BACKUPS\AUTOBACKU

      P\CONTROLFILE_C-1338224820-20130718-00

      channel ORA_AUX_DISK_1: piece handle=C:\APP\ARNAB\BACKUPS\AUTOBACKUP\CONTROLFILE

      _C-1338224820-20130718-00 tag=TAG20130718T162519

      channel ORA_AUX_DISK_1: restored backup piece 1

      channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

      output file name=E:\TSPITR\ORCL\CONTROLFILE\O1_MF_8YHZM0O3_.CTL

      Finished restore at 18-JUL-13

       

      sql statement: alter database mount clone database

       

      sql statement: alter system archive log current

       

      sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;

       

      contents of Memory Script:

      {

      # set requested point in time

      set until  time "to_date('18-07-13 19:33:00','dd-mm-yy hh24:mi:ss')";

      # set destinations for recovery set and auxiliary set datafiles

      set newname for clone datafile  1 to new;

      set newname for clone datafile  3 to new;

      set newname for clone datafile  2 to new;

      set newname for clone tempfile  1 to new;

      set newname for datafile  7 to

      "C:\APP\ARNAB\ORADATA\ORCL\PUN.DBF";

      # switch all tempfiles

      switch clone tempfile all;

      # restore the tablespaces in the recovery set and the auxiliary set

      restore clone datafile  1, 3, 2, 7;

      switch clone datafile all;

      }

      executing Memory Script

       

      executing command: SET until clause

       

      executing command: SET NEWNAME

       

      executing command: SET NEWNAME

       

      executing command: SET NEWNAME

       

      executing command: SET NEWNAME

       

      executing command: SET NEWNAME

       

      renamed tempfile 1 to E:\TSPITR\ORCL\DATAFILE\O1_MF_TEMP_%U_.TMP in control file

       

       

      Starting restore at 18-JUL-13

      using channel ORA_AUX_DISK_1

      One or more auxiliary set datafiles could not be removed

       

      Removing automatic instance

      shutting down automatic instance

      database dismounted

      Oracle instance shut down

      Automatic instance removed

      auxiliary instance file E:\TSPITR\ORCL\CONTROLFILE\O1_MF_8YHZM0O3_.CTL deleted

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of recover command at 07/18/2013 20:10:46

      RMAN-03015: error occurred in stored script Memory Script

      RMAN-06136: ORACLE error from auxiliary database: RMAN-20201: datafile not found

      in the recovery catalog

      RMAN-06010: error while looking up datafile: 7

       

      Please suggest!

       

      Arni