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: 1736
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: 1736
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: Sun Nov 03 01:26:10 CDT 2024