SQL> execute dbms_logmnr_d.build(dictionary_filename=>'v816dict.ora',dictionary_location=>'/u01/oracle/logs');
PL/SQL procedure successfully completed.
EXECUTE dbms_logmnr.add_logfile(LogFileName=>'/u01/oracle/oradata/pgy/redo01.log',Options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
EXECUTE dbms_logmnr.add_logfile(LogFileName=>'/u01/oracle/oradata/pgy/redo02.log',Options=>dbms_logmnr.addfile);
PL/SQL procedure successfully completed.
EXECUTE dbms_logmnr.add_logfile( LogFileName=>'/u01/oracle/oradata/pgy/archive/ARCARC09108.001', Options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
EXECUTE dbms_logmnr.add_logfile( LogFileName=>'/u01/oracle/archlog/pgy/arch1_98_670966644.arc', Options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
SQL> EXECUTE dbms_logmnr.add_logfile( LogFileName=>'/u01/oracle/oradata/pgy/redo02.log',Options=>dbms_logmnr. REMOVEFILE);
BEGIN dbms_logmnr.add_logfile( LogFileName=>'/u01/oracle/oradata/pgy/redo02.log',Options=>dbms_logmnr. REMOVEFILE); END;
*
ERROR at line 1:
ORA-01290: cannot remove unlisted logfile /u01/oracle/oradata/pgy/redo02.log
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 1
SQL> EXECUTE dbms_logmnr.start_logmnr( DictFileName=>' /u01/oracle/logs/ v816dict.ora ');
BEGIN dbms_logmnr.start_logmnr( DictFileName=>' /u01/oracle/logs/ v816dict.ora '); END;
*
ERROR at line 1:
ORA-01284: file/u01/oracle/logs/ v816dict.oracannot be openedORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 1
SQL>
|
