RMAN: Backup and restore tablespace drop
I am in Oracle 10gR2, I made a full backup in the controlfile that went well (backup database ....), I drop a tablespace (tablespace tbs DRP contents and datafiles) after I have restored The restoration went smoothly without problem (restore database recover database .... then ..) but I do not see the tablespace deleted after the backup.
I do not understand, the backup is OK, but I can not find my tbs?
Thanks in advance.
Re: RMAN: Backup and restore tablespace drop
There are limitations on the restoration of deleted tablespaces:
To restore a tablespace which is deleted you can try to duplicate the basis for a state before the deletion of tablespace with RMAN DUPLICATE and transport the tablespace of the database replicated in the correct basis.
The FIFA Manager 2009 PC Game
|Tags: oracle, rman, tablespace drop|
|Thread Tools||Search this Thread|
|Similar Threads for: "RMAN: Backup and restore tablespace drop"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Unable to restore backup by using Symantec backup exec on MS Exchange 2007||Charu Sharma||Windows Software||2||27-04-2012 08:48 AM|
|Internal hard drive and backup location is not shown in windows 7 Backup and Restore||AADI-JI||Windows Software||4||13-12-2010 10:16 AM|
|best backup software for Vista Home Ultimate that will allow me to select files and folders to backup and restore||Lynette||Windows Vista Performance||3||03-07-2010 12:57 PM|
|Cold Backup using RMAN Vs. OS||Garlands||Operating Systems||4||06-02-2010 10:50 PM|
|Vista Backup and Restore and System Restore points||MrChris-||Guides & Tutorials||1||05-01-2009 09:05 PM|