Oracle: Enable Archive Log and prepare for mining

Oracle: Enable Archive Log and prepare for mining

Database Parameters to be changed:
----------------------------------
log_archive_start = TRUE
log_archive_dest_1 = 'LOCATION=/v1x11510/oracle/archive'
log_archive_dest_state_1 = ENABLE
log_archive_format = %d_%t_%s.arc

Login as SYS (As sysdba) and do the following:
------------------------------------------------
CONNECT sys AS SYSDBA
STARTUP PFILE=/v1x11510/v1x11510db/9.2.0/dbs/initv1x11510.ora MOUNT EXCLUSIVE;
ALTER DATABASE ARCHIVELOG;
ARCHIVE LOG START;
ALTER DATABASE OPEN;
ALTER SYSTEM SWITCH LOGFILE;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
-------------------------------------------
-- The following stmt collects supplementa ldata for primary keys and unique keys.
ALTER DATABASE ADD SUPPLEMENTAL DATA (PRIMARY KEY, UNIQUE KEY) COLUMNS;

SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;


To store dictionary in the REDO logs, do
-----------------------------------------
EXECUTE dbms_logmnr_d.build(options => dbms_logmnr_d.store_in_redo_logs);

To store dictionary in file system, do
--------------------------------------
begin
dbms_logmnr_d.build (
dictionary_filename => 'vxgwy1_ora_dict.txt',
dictionary_location => '/tmp'
);
end;