RMAN and recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN and recovery

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    RMAN and recovery

    I am trying to recover a tablespace through RMAN. Below are the steps which I have taken. As you can see I get an error when trying to restore/recover a tablespace. Can somebody tell me what my problem is in regards to the recovery.


    rman> backup tablespace pbh'

    sqlplus sys/"sys as sysdba"

    sqlplus > drop tablespace pbh including contents;

    rman>
    restore tablespace pbh;

    Starting restore at 27-JUL-06
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=138 devtype=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 07/27/2006 15:01:11
    RMAN-20202: tablespace not found in the recovery catalog
    RMAN-06019: could not translate tablespace name "PBH"

    RMAN> recover tablespace pbh;

    Starting recover at 27-JUL-06
    using channel ORA_DISK_1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 07/27/2006 15:01:44
    RMAN-20202: tablespace not found in the recovery catalog
    RMAN-06019: could not translate tablespace name "PBH"

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Use uppercase and put in quotes:

    RMAN> restore tablespace 'PBH';
    RMAN> recover tablespace 'PBH';
    Last edited by ebrian; 07-27-2006 at 03:17 PM.

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    Thanks for responding but I tried all combinations/variations of the tablespace name with/without single/double quotes and I always got the same error.

    Any other suggestions?

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    Sorry, maybe I wasn't following what you were trying. Your original command should have worked without any quotes.

    If you are simply trying to simulate a dropped tablespace, you actually have two options, you can restore & recover the entire database back to a time BEFORE the tablespace was dropped or duplicate the entire database to another location and perform PITR so you can export the tablespace in question.
    Last edited by ebrian; 11-12-2007 at 06:33 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