Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 22-05-2009
Member
 
Join Date: Apr 2008
Posts: 40
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.
Reply With Quote
  #2  
Old 22-05-2009
Member
 
Join Date: May 2008
Posts: 2,383
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
Reply With Quote
  #3  
Old 22-05-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: RMAN: Backup and restore tablespace drop

See this link for more help : http://asktom.oracle.com/pls/asktom/...D:515222144417
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 04:50 AM.