Home » RDBMS Server » Backup & Recovery » Tablespace recovery
Tablespace recovery [message #152423] Fri, 23 December 2005 01:47 Go to next message
vrsmanian
Messages: 1
Registered: December 2005
Junior Member
Hi,
Consider this scenario, I have cold backup taken at 12.00 in the night and in the morning I add a datafile to a tablespace, extend segments etc and after some time, I accidentally deleted the tablespace including contents. How can I recover the tablespace with the changes made after the backup.

Regards,
Ram
Re: Tablespace recovery [message #152451 is a reply to message #152423] Fri, 23 December 2005 04:32 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
HI,

That depends on whehter you are operating on archivelog mode or in noarchivelog mode...If you are in the first mode, then you can, else you can not.

N.
Previous Topic: Find higest "next scn" in rman catalog
Next Topic: recover db
Goto Forum:
  


Current Time: Thu Mar 28 20:57:34 CDT 2024