Home » RDBMS Server » Backup & Recovery » recover table without backup
recover table without backup [message #459326] Fri, 04 June 2010 06:59 Go to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
Hi All

How to recover a table, without using backup (no backup) of a table and without using flashback (flashback off)techniques
can any one help me
Re: recover table without backup [message #459333 is a reply to message #459326] Fri, 04 June 2010 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recover from what?

Regards
Michel
Re: recover table without backup [message #459353 is a reply to message #459333] Fri, 04 June 2010 08:27 Go to previous messageGo to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
I lost my data before 7 days...now only i know this
how can i restore and recover the data i don't have the proper backup...
Re: recover table without backup [message #459354 is a reply to message #459353] Fri, 04 June 2010 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ony the data, not the table itself?

Regards
Michel
Re: recover table without backup [message #459357 is a reply to message #459354] Fri, 04 June 2010 08:53 Go to previous messageGo to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
yes right..
Re: recover table without backup [message #459358 is a reply to message #459357] Fri, 04 June 2010 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't recover, data have gone.

Regards
Michel
Re: recover table without backup [message #459378 is a reply to message #459358] Fri, 04 June 2010 09:41 Go to previous messageGo to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
can we apply archive log for recover the data....
Re: recover table without backup [message #459379 is a reply to message #459378] Fri, 04 June 2010 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 22489
Registered: January 2009
Senior Member
>can we apply archive log for recover the data....
Apply archive logs to what EXACTLY?
To apply archive logs, you need a consistent copy of the DB to start with.
Re: recover table without backup [message #459380 is a reply to message #459379] Fri, 04 June 2010 09:49 Go to previous messageGo to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
i dont have backup....but i have database in archive log mode
using that can i recover my data....which is gone before 7 days
Re: recover table without backup [message #459381 is a reply to message #459380] Fri, 04 June 2010 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 22489
Registered: January 2009
Senior Member
>i dont have backup....but i have database in archive log mode
>using that can i recover my data....which is gone before 7 days
Then proceed to do so.
Nobody here is stopping from doing what you deem appropriate on your system.
Re: recover table without backup [message #459384 is a reply to message #459380] Fri, 04 June 2010 10:00 Go to previous messageGo to next message
John Watson
Messages: 4376
Registered: January 2010
Location: Global Village
Senior Member
Your archive logs are useless, if you don't have a backup.
You haven't said, but it sounds as though what you did was DELETE and COMMIT, a week ago. Why not try a flashback query? I bet nothing much has happened on your database since then, so it might work:
INSERT INTO table SELECT * FROM table AS OF TIMESTAMP (SYSTIMESTAMP - 8);

to put back all the rows that existed eight days ago.
Re: recover table without backup [message #459385 is a reply to message #459384] Fri, 04 June 2010 10:08 Go to previous message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet no one has an undo tablespace (if OP has one) large enough to keep the last 8 days data.

Depending on the statement that deleted the rows, Log Miner can do the trick (of course database should be in ARCHIVELOG mode or doing nothing during the last week).

Regards
Michel
Previous Topic: rman vs user management
Next Topic: Loss of all redo logs
Goto Forum:
  


Current Time: Thu Jul 24 04:02:30 CDT 2014

Total time taken to generate the page: 0.16457 seconds