OraFAQ Forum: Backup & Recovery » using logminer....!

Home » RDBMS Server » Backup & Recovery » using logminer....!

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

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

Report message to a moderator

Re: using logminer....! [message #133320 is a reply to message #133307]

Thu, 18 August 2005 08:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer.htm#17869

Report message to a moderator

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';

Report message to a moderator

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... Cool

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 .... Smile

Regard
Always Friend Sunilkumar

Report message to a moderator

Previous Topic:	I want script backupdatabase of tapeback For Sun Solaris
Next Topic:	How to move redo log files and undo tablespace file?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:17:52 CDT 2024