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

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 08:16:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.