Errors while trying to restore dropped tablespace

I took a hot backup with RMAN and am trying to restore a dropped tablespace. I am getting errors including RMAN-06004 and RMAN-20202.

I have taken a hot backup of my database with RMAN on 28.04.2007 at 2030 hrs. It is backup.rec. It includes system, undo, tmp and TEST tablespaces. Now I dropped the tablespace 'TEST' from the database. I am trying to restore/recover my dropped tablespace using RMAN only and executing this script, but it is giving some error during restoring the tablespace from backupset backup.rec.
RMAN> run{
2> allocate channel ch1 type disk format '/mnt43/db/backup.rec;
3> restore tablespace 'TEST';
4> }

starting full resync of recovery catalog
full resync complete
allocated channel: ch1
channel ch1: sid=17 devtype=DISK

Starting restore at 29-APR-07

released channel: ch1
RMAN-00571: =============================================
RMAN-00571: =============================================
RMAN-03002: failure of restore command at 04/29/2007 14:47:20
RMAN-06004: ORACLE error from recovery catalog database: 
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TEST"
How can it restore this dropped tablespace? Please help.
Try removing the double quotes from your tablespace name. The double quotes tell RMAN to be case-sensitive and RMAN could be storing the tablespace name with different case.
This was first published in May 2007

Dig deeper on Oracle database backup and recovery



Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:


This Content Component encountered an error