jobby1
asked on
How to retrive deleted tablespace
I have deleted a table space with contents. But I have the RMAN back of the database. But when i gave the command restore tablespace users i am getting the below error
RMAN> restore tablespace users;
Starting restore at 07-AUG-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-00579: the following error occurred at 08/07/2009 17:20:53
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "USERS"
RMAN> restore tablespace users;
Starting restore at 07-AUG-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-00579: the following error occurred at 08/07/2009 17:20:53
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "USERS"
is this 9i 10g or 11g?
try
restore tablespace 'USERS';
restore tablespace 'USERS';
how did you lose this tablespace have you droped this TS from target ;as this may be a differnt situation?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree with it-rex, at least your controlfile doesn't know about the tablespace right now, as far as the current database structure is concerned, whether it is in the catalog or not. But you can at least look and see what is in the controlfile / catalog.
RMAN> list backup of database;
-- OR
--See when the last backup of the tablespace was
RMAN> list backup of tablespace users;
If it is not there, it isn't backed up or the controlfile isn't aware of it. Several reasons for that, but try these commands first.
RMAN> list backup of database;
-- OR
--See when the last backup of the tablespace was
RMAN> list backup of tablespace users;
If it is not there, it isn't backed up or the controlfile isn't aware of it. Several reasons for that, but try these commands first.
I recommend accept of it-rex's comment: http:#25043109
The ora errors in the question are exactly what happens if you try to restore a dropped tablespace using the current controlfile. He is correct, the only options are restore and do incomplete recovery with a previous controlfile from a point before the tablespace was dropped, or to do TSPITR which will use an auxiliary instance.
The ora errors in the question are exactly what happens if you try to restore a dropped tablespace using the current controlfile. He is correct, the only options are restore and do incomplete recovery with a previous controlfile from a point before the tablespace was dropped, or to do TSPITR which will use an auxiliary instance.