OraFAQ Forum: Backup & Recovery » Retrieve truncated data (merged)

Home » RDBMS Server » Backup & Recovery » Retrieve truncated data (merged)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Retrieve truncated data (merged) [message #419423]

Sat, 22 August 2009 01:41

ibcsdba
Messages: 1
Registered: August 2009
Location: Dhaka

Junior Member

can anybody help to retrieve truncated data from oracle 10g database. The database is in "noarchive" log mode. we have truncated 1007 million data from a table. Embarassed

Report message to a moderator

Re: Retrieve truncated data [message #419425 is a reply to message #419423]

Sat, 22 August 2009 02:05

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

If you don't run the database in archivelog mode, then you can't talk about RECOVERY process. Because recovery means, you apply archived redo log files on restored backup. While you haven't archived redo log files, you can't recover

If you have cold backup, just restore it. This is one and only chance.

Report message to a moderator

Re: Retrieve truncated data (merged) [message #419427 is a reply to message #419423]

Sat, 22 August 2009 02:24

Michel Cadot
Messages: 54195
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Always post your Oracle version (with 4 decimals).

Also if you have an export of the table you can re-import it.
Of course, with cold backup or export you lose all modifications that have been made since.

Now switch you database in archivelog mode. There is no reason to be in noarchivelog mode unless you choose to never recover.

Regards
Michel

Report message to a moderator

Previous Topic:	rman backup type
Next Topic:	RMAN hotbackup (merged 3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 18:46:26 CDT 2013

Total time taken to generate the page: 0.15333 seconds