Originally Posted by BeefStu
rman> backup tablespace pbh'
sqlplus sys/"sys as sysdba"
sqlplus > drop tablespace pbh including contents;
rman> restore tablespace pbh;
Starting restore at 10-AUG-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 08/10/2006 15:01:11
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "PBH"