Home » RDBMS Server » Backup & Recovery » Retrieve truncated data (merged)
icon8.gif  Retrieve truncated data (merged) [message #419423] Sat, 22 August 2009 01:41 Go to next message
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
Re: Retrieve truncated data [message #419425 is a reply to message #419423] Sat, 22 August 2009 02:05 Go to previous messageGo to next message
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.
Re: Retrieve truncated data (merged) [message #419427 is a reply to message #419423] Sat, 22 August 2009 02:24 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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
Previous Topic: rman backup type
Next Topic: RMAN hotbackup (merged 3)
Goto Forum:
  


Current Time: Sun Dec 08 07:27:05 CST 2024