OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Logminer

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

Logminer [message #264277]

Sun, 02 September 2007 14:10

dbasudar
Messages: 8
Registered: August 2007
Location: chennai

Junior Member

hi,
i accidentally dropped a table from my database.when i tried it to restore it,i had an idea of using logminer.bcoz i doesnot know the exact time,when i drooped it.i used the normal procedures...but when i tried to do

SELECT scn,timestamp,sql_redo FROM v$logmnr_contents where sql_redo='%DROP%';

no rows have been selected....
but that table doesnot exixts....
can anyone help me regarding this...
thanks in advance...

Report message to a moderator

Re: Logminer [message #264278 is a reply to message #264277]

Sun, 02 September 2007 14:54

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Oracle version?
2/ How do you set up your log miner session?

Regards
Michel

Report message to a moderator

Re: Logminer [message #264293 is a reply to message #264277]

Sun, 02 September 2007 21:59

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can also check your recycle bin to see whether table is there or not?

Report message to a moderator

Re: Logminer [message #264311 is a reply to message #264277]

Mon, 03 September 2007 00:11

gagan_7_7
Messages: 1
Registered: September 2006

Junior Member

Hi,

Please syntax of the query is not correct:

SELECT scn,timestamp,sql_redo FROM v$logmnr_contents where sql_redo like '%DROP%';

Then Try, it would really works

Report message to a moderator

Re: Logminer [message #264314 is a reply to message #264277]

Mon, 03 September 2007 00:22

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Report message to a moderator

Re: Logminer [message #264471 is a reply to message #264277]

Mon, 03 September 2007 08:20

dbasudar
Messages: 8
Registered: August 2007
Location: chennai

Junior Member

i used oracle 9i...
i dont that table in recycle bin...
i checked it out...my syntax is correct...
Hi arju,i cant understand wht do u say...
Thank u once again

Report message to a moderator

Re: Logminer [message #264483 is a reply to message #264471]

Mon, 03 September 2007 09:00

lecorr
Messages: 17
Registered: October 2006
Location: Courbevoie, France

Junior Member

Hi,

you mean you're looking for a sql_redo which has for value '%DROP%'?

Not for something LIKE '%DROP%' (for example 'DROP TABLE...')?
And maybe you should also look for a '%drop%'?

I'm not a logminer specialist, so maybe your syntax is OK, but I doubt it is.

Regards,

Christian

Report message to a moderator

Previous Topic:	Database abnormally shutdown
Next Topic:	DATA PUMP IMP & EXP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 18:05:32 CDT 2025