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';

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.