This Utility used to convert redo file or archive file into readable format


Step 1

First we assign a directory for utl_file_dir parameter



SQL> show parameter utl_file;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string D:\learn


Step 2

We need to run this two scripts

dbmslmd and dbmslm

SQL> @?/rdbms/admin/dbmslmd.sql;

Package created.



SQL> @?/rdbms/admin/dbmslm.sql;

Package created.


Grant succeeded.

Step 3

execute package dbms_logmnr_d.build(with dictionary name and location)

example

SQL> exec dbms_logmnr_d.build(dictionary_filename => 'dict.ora' , dictionary_location => 'D:\learn');

PL/SQL procedure successfully completed.

Step 4

execute package dbms_logmnr.add_logfile(log file path)


SQL> exec dbms_logmnr.add_logfile(logfilename => 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\LEARN\REDO03.LOG ' , options => dbms_logmnr.new);

PL/SQL procedure successfully completed.


Step 5

execute package dbms_logmnr.start_logmnr(dictionary file name)




SQL> exec dbms_logmnr.start_logmnr(dictfilename => 'D:\learn\dict.ora' );

PL/SQL procedure successfully completed.







SQL> desc v$logmnr_contents;
Name Null? Type
----------------------------------------- -------- ----------------------------
SCN NUMBER
CSCN NUMBER
TIMESTAMP DATE
COMMIT_TIMESTAMP DATE
THREAD# NUMBER
LOG_ID NUMBER
XIDUSN NUMBER
XIDSLT NUMBER
XIDSQN NUMBER
PXIDUSN NUMBER
PXIDSLT NUMBER
PXIDSQN NUMBER
RBASQN NUMBER
RBABLK NUMBER
RBABYTE NUMBER
UBAFIL NUMBER
UBABLK NUMBER
UBAREC NUMBER
UBASQN NUMBER
ABS_FILE# NUMBER
REL_FILE# NUMBER
DATA_BLK# NUMBER
DATA_OBJ# NUMBER
DATA_OBJD# NUMBER
SEG_OWNER VARCHAR2(32)
SEG_NAME VARCHAR2(256)
TABLE_NAME VARCHAR2(32)
SEG_TYPE NUMBER
SEG_TYPE_NAME VARCHAR2(32)
TABLE_SPACE VARCHAR2(32)
ROW_ID VARCHAR2(18)
SESSION# NUMBER
SERIAL# NUMBER
USERNAME VARCHAR2(30)
SESSION_INFO VARCHAR2(4000)
TX_NAME VARCHAR2(256)
ROLLBACK NUMBER
OPERATION VARCHAR2(32)
OPERATION_CODE NUMBER
SQL_REDO VARCHAR2(4000)
SQL_UNDO VARCHAR2(4000)
RS_ID VARCHAR2(32)
SEQUENCE# NUMBER
SSN NUMBER
CSF NUMBER
INFO VARCHAR2(32)
STATUS NUMBER
REDO_VALUE NUMBER
UNDO_VALUE NUMBER
SQL_COLUMN_TYPE VARCHAR2(30)
SQL_COLUMN_NAME VARCHAR2(30)
REDO_LENGTH NUMBER
REDO_OFFSET NUMBER
UNDO_LENGTH NUMBER
UNDO_OFFSET NUMBER
DATA_OBJV# NUMBER
SAFE_RESUME_SCN NUMBER
XID RAW(8)
PXID RAW(8)
AUDIT_SESSIONID NUMBER







This is for example output;




SQL> select username,sql_redo,timestamp from v$logmnr_contents;





USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

set transaction read write;
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU1$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '9', "SCNBAS" = '601268', "SCNWRP" = '0', "XACTSQN" = '292', "UNDOSQN" =

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
'161', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME"
= '_SYSSMU1$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '9' and "SCNBA
S" = '580836' and "SCNWRP" = '0' and "XACTSQN" = '292' and "UNDOSQN" = '161' and
"INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and ROWID
= 'AAAAAPAABAAAABqAAB';
24-FEB-09


USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

commit;
24-FEB-09


set transaction read write;
24-FEB-09

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


update "SYS"."UNDO$" set "NAME" = '_SYSSMU2$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '25', "SCNBAS" = '601331', "SCNWRP" = '0', "XACTSQN" = '299', "UNDOSQN"
= '179', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME
" = '_SYSSMU2$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '25' and "SCN
BAS" = '580832' and "SCNWRP" = '0' and "XACTSQN" = '299' and "UNDOSQN" = '179' a

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
nd "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and ROWI
D = 'AAAAAPAABAAAABqAAC';
24-FEB-09


commit;
24-FEB-09

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


set transaction read write;
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU3$', "USER#" = '1', "FILE#" = '2', "BL

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
OCK#" = '41', "SCNBAS" = '601298', "SCNWRP" = '0', "XACTSQN" = '296', "UNDOSQN"
= '254', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME
" = '_SYSSMU3$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '41' and "SCN
BAS" = '580863' and "SCNWRP" = '0' and "XACTSQN" = '296' and "UNDOSQN" = '254' a
nd "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and ROWI
D = 'AAAAAPAABAAAABqAAD';
24-FEB-09

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


commit;
24-FEB-09


set transaction read write;

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU4$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '57', "SCNBAS" = '601272', "SCNWRP" = '0', "XACTSQN" = '294', "UNDOSQN"
= '248', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME
" = '_SYSSMU4$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '57' and "SCN

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
BAS" = '580861' and "SCNWRP" = '0' and "XACTSQN" = '294' and "UNDOSQN" = '248' a
nd "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and ROWI
D = 'AAAAAPAABAAAABqAAE';
24-FEB-09


commit;

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
24-FEB-09


set transaction read write;
24-FEB-09



USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
update "SYS"."UNDO$" set "NAME" = '_SYSSMU5$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '73', "SCNBAS" = '601358', "SCNWRP" = '0', "XACTSQN" = '299', "UNDOSQN"
= '246', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME
" = '_SYSSMU5$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '73' and "SCN
BAS" = '580834' and "SCNWRP" = '0' and "XACTSQN" = '299' and "UNDOSQN" = '246' a
nd "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and ROWI
D = 'AAAAAPAABAAAABqAAF';

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
24-FEB-09


commit;
24-FEB-09



USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
set transaction read write;
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU6$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '89', "SCNBAS" = '601243', "SCNWRP" = '0', "XACTSQN" = '301', "UNDOSQN"
= '255', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
" = '_SYSSMU6$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '89' and "SCN
BAS" = '580886' and "SCNWRP" = '0' and "XACTSQN" = '301' and "UNDOSQN" = '254' a
nd "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and ROWI
D = 'AAAAAPAABAAAABqAAG';
24-FEB-09



USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
commit;
24-FEB-09


set transaction read write;
24-FEB-09


USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

update "SYS"."UNDO$" set "NAME" = '_SYSSMU7$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '105', "SCNBAS" = '601329', "SCNWRP" = '0', "XACTSQN" = '300', "UNDOSQN"
= '245', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAM
E" = '_SYSSMU7$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '105' and "S
CNBAS" = '580890' and "SCNWRP" = '0' and "XACTSQN" = '300' and "UNDOSQN" = '245'
and "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and RO

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
WID = 'AAAAAPAABAAAABqAAH';
24-FEB-09


commit;
24-FEB-09


USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

set transaction read write;
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU8$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '121', "SCNBAS" = '601327', "SCNWRP" = '0', "XACTSQN" = '300', "UNDOSQN"

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
= '195', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAM
E" = '_SYSSMU8$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '121' and "S
CNBAS" = '580828' and "SCNWRP" = '0' and "XACTSQN" = '299' and "UNDOSQN" = '195'
and "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and RO
WID = 'AAAAAPAABAAAABqAAI';
24-FEB-09


USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

commit;
24-FEB-09


set transaction read write;
24-FEB-09

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


update "SYS"."UNDO$" set "NAME" = '_SYSSMU9$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '137', "SCNBAS" = '601356', "SCNWRP" = '0', "XACTSQN" = '322', "UNDOSQN"
= '167', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAM
E" = '_SYSSMU9$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '137' and "S
CNBAS" = '580859' and "SCNWRP" = '0' and "XACTSQN" = '322' and "UNDOSQN" = '167'

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
and "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and RO
WID = 'AAAAAPAABAAAABqAAJ';
24-FEB-09


commit;
24-FEB-09

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


set transaction read write;
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU10$', "USER#" = '1', "FILE#" = '2', "B

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
LOCK#" = '153', "SCNBAS" = '601354', "SCNWRP" = '0', "XACTSQN" = '295', "UNDOSQN
" = '172', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NA
ME" = '_SYSSMU10$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '153' and
"SCNBAS" = '580888' and "SCNWRP" = '0' and "XACTSQN" = '295' and "UNDOSQN" = '17
2' and "INST#" = '0' and "STATUS$" = '3' and "TS#" = '1' and "SPARE1" = '1' and
ROWID = 'AAAAAPAABAAAABqAAK';
24-FEB-09

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


commit;
24-FEB-09


set transaction read write;

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU1$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '9', "SCNBAS" = '601268', "SCNWRP" = '0', "XACTSQN" = '292', "UNDOSQN" =
'161', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME"
= '_SYSSMU1$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '9' and "SCNBA

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
S" = '601268' and "SCNWRP" = '0' and "XACTSQN" = '292' and "UNDOSQN" = '161' and
"INST#" = '0' and "STATUS$" = '2' and "TS#" = '1' and "SPARE1" = '1' and ROWID
= 'AAAAAPAABAAAABqAAB';
24-FEB-09


commit;

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
24-FEB-09


set transaction read write;
24-FEB-09



USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
update "SYS"."UNDO$" set "NAME" = '_SYSSMU1$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '9', "SCNBAS" = '601268', "SCNWRP" = '0', "XACTSQN" = '292', "UNDOSQN" =
'161', "INST#" = '0', "STATUS$" = '3', "TS#" = '1', "SPARE1" = '1' where "NAME"
= '_SYSSMU1$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '9' and "SCNBA
S" = '601268' and "SCNWRP" = '0' and "XACTSQN" = '292' and "UNDOSQN" = '161' and
"INST#" = '0' and "STATUS$" = '2' and "TS#" = '1' and "SPARE1" = '1' and ROWID
= 'AAAAAPAABAAAABqAAB';

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
24-FEB-09


commit;
24-FEB-09



USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
set transaction read write;
24-FEB-09


update "SYS"."UNDO$" set "NAME" = '_SYSSMU2$', "USER#" = '1', "FILE#" = '2', "BL
OCK#" = '25', "SCNBAS" = '601331', "SCNWRP" = '0', "XACTSQN" = '299', "UNDOSQN"
= '179', "INST#" = '0', "STATUS$" = '2', "TS#" = '1', "SPARE1" = '1' where "NAME

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
" = '_SYSSMU2$' and "USER#" = '1' and "FILE#" = '2' and "BLOCK#" = '25' and "SCN
BAS" = '601331' and "SCNWRP" = '0' and "XACTSQN" = '299' and "UNDOSQN" = '179' a
nd "INST#" = '0' and "STATUS$" = '2' and "TS#" = '1' and "SPARE1" = '1' and ROWI
D = 'AAAAAPAABAAAABqAAC';
24-FEB-09



USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
commit;
24-FEB-09


set transaction read write;
24-FEB-09


USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- dictionary_location - path to file directory
-- options - To explicitly indicate flat file or log stream destination.
--
-- BUILD EXAMPLE1
-- Creating a dictionary file as:
-- /usr/ora/dict.ora
-- Complete syntax, typed all on one line:

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
--
-- SQL> execute dbms_logmnr_d.build('dict.ora',
-- '/usr/ora',
-- DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);
--
-- BUILD EXAMPLE2
-- Creating a dictionary file as:

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- /usr/ora/dict.ora
-- Logminer V1 syntax.
--
-- SQL> execute dbms_logmnr_d.build('dict.ora', '/usr/ora');
--
-- BUILD EXAMPLE3
-- Gathering a dictionary into the log stream

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- Complete syntax, typed all on one line:
--
-- SQL> execute dbms_logmnr_d.build('', '',
-- DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);
--
-- BUILD NOTES
-- The dictionary gather should be done after all dictionary

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- changes to a database and prior to the creation of any log
-- files that are to be analyzed.
--
--
-- SET_TABLESPACE
-- By default all Logminer tables are created to use the SYSAUX
-- tablespace. All users will find it desirable to alter Logminer

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- tables to employ an alternate tablespace. Use this routine to
-- recreate all Logminer tables in an alternate tablespace.
--
-- SET_TABLESPACE INPUTS
-- new_tablespace - a string naming a preexistant tablespace.
--


USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
STORE_IN_FLAT_FILE CONSTANT INTEGER := 1;
STORE_IN_REDO_LOGS CONSTANT INTEGER := 2;

PROCEDURE build
(dictionary_filename IN VARCHAR2 DEFAULT '',
dictionary_location IN VARCHAR2 DEFAULT '',
options IN NUMBER DEFAULT 0);

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

--
--
PROCEDURE set_tablespace( new_tablespace IN VARCHAR2 );
--
--
END dbms_logmnr_d; -- End Definition of package;

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
24-FEB-09

SYS
commit;
24-FEB-09



USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

24-FEB-09



24-FEB-09


USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------


24-FEB-09

SYS
set transaction read write;
24-FEB-09

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------

SYS
create or replace PACKAGE dbms_logmnr IS

--------------------
-- OVERVIEW
--

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- This package contains the procedures used by LogMiner ad-hoc query
-- interface that allows for redo log stream analysis.
-- There are three procedures and two functions available to the user:
-- dbms_logmnr.add_logfile() : to register logfiles to be analyzed
-- dbms_logmnr.remove_logfile() : to remove logfiles from being analyzed
-- dbms_logmnr.start_logmnr() : to provide window of analysis and
-- meta-data information

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- dbms_logmnr.end_logmnr() : to end the analysis session
-- dbms_logmnr.column_present() : whether a particular column value
-- is presnet in a redo record
-- dbms_logmnr.mine_value() : extract data value from a redo record
--

---------------------------

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- PROCEDURE INFORMATION:
-- #1 dbms_logmnr.add_logfile():
-- DESCRIPTION:
-- Registers a redo log file with LogMiner. Multiple redo logs can be
-- registered by calling the procedure repeatedly. The redo logs
-- do not need to be registered in any particular order.
-- Both archived and online redo logs can be mined. If a successful

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- call to the procedure is made a call to start_logmnr() must be
-- made before selecting from v$logmnr_contents.
--
-- CONSTANTS:
-- dbms_logmnr.NEW: Starts a new list. Any file registered prior to
-- this call is discarded.
-- dbms_logmnr.ADDFILE: Adds the redo log to the existing

USERNAME
------------------------------
SQL_REDO
--------------------------------------------------------------------------------
TIMESTAMP
---------
-- list. LogMiner checks to make sure that the redo log is from
-- the same database (DB_ID and RESETLOGS_SCN) incarnation as the
-- ones previously added.
--
-- EXCEPTIONS:
-- ORA: 1284 Redo log file specified can not be opened.
-- ORA: 1285 Error reading the header of the redo log file



Step 6

Sql>exec dbms_logmnr.end_logmnr;