-
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"
-
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.
-
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?
-
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 07: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|