Hi,
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.
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-00569: ====== ERROR MESSAGE STACK FOLLOWS ========
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
Join the conversationComment
Share
Comments
Results
Contribute to the conversation