Home » RDBMS Server » Backup & Recovery » recover tablespace in noarchivemode (windows)
icon7.gif  recover tablespace in noarchivemode [message #400608] Wed, 29 April 2009 01:56 Go to next message
tamannasweetest
Messages: 7
Registered: April 2009
Location: dehu road
Junior Member

My database is in noarchive log mode

i have not backed up my database

and by mistake i dropped my tablespace

how can i recover the tablespace
Re: recover tablespace in noarchivemode [message #400614 is a reply to message #400608] Wed, 29 April 2009 02:14 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Without backup for your tablespace. You con't

Babu
Re: recover tablespace in noarchivemode [message #400616 is a reply to message #400608] Wed, 29 April 2009 02:20 Go to previous messageGo to next message
tamannasweetest
Messages: 7
Registered: April 2009
Location: dehu road
Junior Member

how to take backup in noarchive mode?

Re: recover tablespace in noarchivemode [message #400617 is a reply to message #400616] Wed, 29 April 2009 02:22 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Cold backup.

Babu.
Previous Topic: RMAN Slow backup (merged)
Next Topic: system datafile corrupted
Goto Forum:
  


Current Time: Sat Dec 10 13:03:36 CST 2016

Total time taken to generate the page: 0.08061 seconds