Home » RDBMS Server » Backup & Recovery » Logminer
icon14.gif  Logminer [message #264277] Sun, 02 September 2007 14:10 Go to next message
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...
Re: Logminer [message #264278 is a reply to message #264277] Sun, 02 September 2007 14:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Oracle version?
2/ How do you set up your log miner session?

Regards
Michel
Re: Logminer [message #264293 is a reply to message #264277] Sun, 02 September 2007 21:59 Go to previous messageGo to next message
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?
Re: Logminer [message #264311 is a reply to message #264277] Mon, 03 September 2007 00:11 Go to previous messageGo to next message
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
Re: Logminer [message #264314 is a reply to message #264277] Mon, 03 September 2007 00:22 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

?
Re: Logminer [message #264471 is a reply to message #264277] Mon, 03 September 2007 08:20 Go to previous messageGo to next message
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
Re: Logminer [message #264483 is a reply to message #264471] Mon, 03 September 2007 09:00 Go to previous message
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

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


Current Time: Thu Dec 08 16:36:25 CST 2016

Total time taken to generate the page: 0.08141 seconds