using logminer....! [message #133307] |
Thu, 18 August 2005 08:03 |
balavignesh
Messages: 180 Registered: March 2005
|
Senior Member |
|
|
hai all,
here in our firm , dev has dropped a table unfortunately and that needs to be recovered.we know that logminer to be used.can u plz provide the step by step instructions to be followed being very urgent issue,plz help out.
regards
bala
|
|
|
|
Re: using logminer....! [message #138415 is a reply to message #133320] |
Wed, 21 September 2005 16:47 |
oskarthik
Messages: 26 Registered: March 2005
|
Junior Member |
|
|
Try this 1. Its very easy to understand
http://www.oracle.com/technology/oramag/oracle/05-jul/o45dba.html
In the tutorial One thing that doesn't work on 9i is the table_name. it works only with 10g
9i users use seg_name
Code Listing 1: Retrieving information from V$LOGMNR_CONTENTS
SQL> select username, to_char(timestamp,'mm/dd/yy hh24:mi:ss') timestamp,
2 seg_type_name, seg_name, table_space, session# SID, serial#
3 from v$logmnr_contents
4 where table_name = 'ACCOUNTS'
5 and seg_owner = 'ARUP'
6 and operation = 'UPDATE';
|
|
|
Re: using logminer....! [message #138439 is a reply to message #138415] |
Thu, 22 September 2005 00:58 |
sunil_v_mishra
Messages: 506 Registered: March 2005
|
Senior Member |
|
|
hi,
Its better to read some documentation related to logminer to get your concept clear. Below are steps to use logminer to analyze redolog...
LOGMINER
Log miner is a utility use to read redo log file and archive log file
[1] Set PARAMETER :
UTL_FILE_DIR = the place you want the log minor data file to store.
e.g. UTL_FILE_DIR = D:\Oracle\Oradata\Oracle
[2] connect as sys :
execute dbms_logmnr_d.build('logmnr.dbf','d:\oracle\oradata\oracle');
creates the “LOGMNR.DBF’ in the specified path.
This takes some time to create.
dbms_logmnr_d is package
build is method
[3] Specify Log files to be analyzed:
execute dbms_logmnr.add_logfile('E:\ORACLE\ORADATA\ORA9I\redo01.log',
dbms_logmnr.new);
View log information
[4] START LOG MINOR
execute dbms_logmnr.start_logmnr (dictfilename=>'E:\ORACLE\ORADATA\ORA9I\logmnr.dbf');
TABLE : v$logmnr_contents
Desc V$LOGMNR_CONTENTS
SELECT SESSION#, USERNAME, SEG_NAME, OPERATION, SQL_REDO,
SQL_UNDO, TO_CHAR (timestamp, ‘dd_mon_yyyy : hh:mi:ss’) from V$LOGMNR_CONTENTS
[5] Stop Log minor :
execute dbms_logmnr.end_logmnr;
Thats it ....
Regard
Always Friend Sunilkumar
|
|
|