Hello,
I'm planning to use logminer in order to analyze several archived redo logs, which have 40GB in size.
SQL> connect / as sysdba
SQL>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL>SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
SQL>EXECUTE DBMS_LOGMNR.ADD_LOGFILE('C:\oracle\product\10.2.0\flash_recovery_area\SHAWON_D\ARCHIVELOG\2012_03_15\O1_MF_1_10_4VRZ1DT4_.ARC', DBMS_LOGMNR.ADDFILE);
SQL>EXECUTE DBMS_LOGMNR.ADD_LOGFILE('C:\oracle\product\10.2.0\flash_recovery_area\SHAWON_D\ARCHIVELOG\ARC44951_0720469437.001', DBMS_LOGMNR.ADDFILE);
SQL>EXECUTE DBMS_LOGMNR.ADD_LOGFILE('C:\oracle\product\10.2.0\flash_recovery_area\SHAWON_D\ARCHIVELOG\ARC44952_0720469437.001', DBMS_LOGMNR.ADDFILE);
SQL>EXECUTE DBMS_LOGMNR.ADD_LOGFILE('C:\oracle\product\10.2.0\flash_recovery_area\SHAWON_D\ARCHIVELOG\ARC44953_0720469437.001', DBMS_LOGMNR.ADDFILE);
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(DICTFILENAME =>'c:\oraclefiles\dictionary.ora');
SQL> select sql_redo, sql_undo from v$logmnr_contents where rownum<10;
My question is:
If I add 40Gb in archived red logs using DBMS_LOGMNR.ADD_LOGFILE, that it means that my tablespaces will increase in 40gb?