Home » RDBMS Server » Backup & Recovery » Incomplete Recovery
Incomplete Recovery [message #163301] Thu, 16 March 2006 00:52 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
Can anyone explain me,how to do incomplete recovery to recover a dropped table?

Please anyone answer for this question,based on this,i've to practice it.

Thanks,
Malru

Report message to a moderator

Re: Incomplete Recovery [message #163320 is a reply to message #163301] Thu, 16 March 2006 03:15 Go to previous messageGo to next message
singhmanish_888
Messages: 8
Registered: October 2005
Junior Member
No,You can not get back your dropped table.I think there is no way to get.


Thank You.

Report message to a moderator

Re: Incomplete Recovery [message #163325 is a reply to message #163320] Thu, 16 March 2006 04:18 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
singhmanish_888 wrote on Thu, 16 March 2006 10:15

No,You can not get back your dropped table.I think there is no way to get.


Thank You.

Yes you can:
- as of Oracle 9i if flashback is enabled.
- as of Oracle 10g if it is still in your recycle_bin

No thanks Wink

MHE

Report message to a moderator

Re: Incomplete Recovery [message #163378 is a reply to message #163301] Thu, 16 March 2006 08:44 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
You can do that if database is in archivelog mode.
I believe you only need to restore all your datafiles and recover database until time before table was dropped.

Report message to a moderator

Re: Incomplete Recovery [message #163465 is a reply to message #163301] Thu, 16 March 2006 16:11 Go to previous message
Amosnaks
Messages: 3
Registered: March 2006
Junior Member
Using rman.

RESTORE DATABASE UNTIL TIME "TO_DATE('16/03/2006 15:00:00','DD/MM/YYYY HH24:00:00')";

RECOVER DATABASE UNTIL TIME "TO_DATE('16/03/2006 15:00:00','DD/MM/YYYY HH24:00:00')";

OPEN RESETLOGS DATABASE;

Immediately take a fresh backup.

Report message to a moderator

Previous Topic: import with blob column
Next Topic: Time based Recovery to recover a dropped table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 23:56:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.