Ask the Expert

Errors while trying to restore dropped tablespace

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: