RMAN and recovering data - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 11 of 11

Thread: RMAN and recovering data

  1. #11
    Join Date
    Apr 2006
    The error has nothing to do with the use of a recovery catalog or not and whether the entries are expired from the control file. It is the error you would expect to encounter if you simply DROP a tablespace and then go into RMAN and issue a restore tablespace <tablespace_name>, which is what the OP is doing.

    C:\>rman target /
    Recovery Manager: Release - Production
    Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
    connected to target database: ORCL9 (DBID=3074164973)
    RMAN> restore tablespace test_restore;
    Starting restore at 11-AUG-06
    using target database controlfile instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=9 devtype=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 08/11/2006 08:19:12
    RMAN-20202: tablespace not found in the recovery catalog
    RMAN-06019: could not translate tablespace name "TEST_RESTORE"
    Last edited by ebrian; 11-12-2007 at 06:32 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width