Shulou(Shulou.com)06/01 Report--

LogMiner component check:

First, we need to make sure that the database already has the necessary packages, and if not, we need to run two packages: the @? / rdbms/admin/dbmslm.sql script is used to install the DBMS_LOGMNR package, which is used by the package user to analyze the log files; and the @? / rdbms/admin/dbmslmd.sql script is used to install the DBMS_LOGMNR_D package, which is mainly used to create the necessary data dictionary for LogMiner.

Query the following statement, and execute the above two scripts if there is no query for the corresponding data dictionary table

SELECT DISTINCT name

FROM DBA_SOURCE

WHERE type = 'PACKAGE'

AND upper (text) LIKE upper ('% logmnr%')

Order by name

Analyze online logs:

SQL > exec dbms_logmnr.add_logfile (logfilename= >'/ opt/oracle/oradata/lych/redo01.log', options= > dbms_logmnr.new)

Perform the analysis:

SQL > execute dbms_logmnr.start_logmnr (options= > dbms_logmnr.dict_from_online_catalog)

View the corresponding log through v$LOGMNR_CONTENTS (only suitable for current session query)

Stop the analysis:

SQL > execute dbms_logmnr.end_logmnr

Analyze the archive logs:

SQL > execute dbms_logmnr.add_logfile (logfilename= >'/ opt/oracle/oradata/lych/archivelog/2019_12_03/abc.arc,options= > dbms_logmnr.NEW)

Perform the analysis:

SQL > execute dbms_logmnr.start_logmnr (options= > dbms_logmnr.dict_from_online_catalog)

View the corresponding log through v$LOGMNR_CONTENTS (only suitable for the current session query, the relevant data exists in the private session PGA)

Stop the analysis:

SQL > execute dbms_logmnr.end_logmnr

How does the extension analyze the archived log files in RMAN backups?

1 query select * from v$archived_log, and filter out the corresponding archive log file information through the demand scenario

(2) find the corresponding backup files in RMAN for the log information queried, and select catalog.

CATALOG backuppiece'/ u01qrmanbakUniq191203 arcarctic lychhammer 1.rbf'

3 restore archivelog from logseq number1 until logseq number2 thread n

4 CATALOG ARCHIVELOG'+ FRA/archivelog/'; (but no operation)

At this time, the required archive logs have been restored, so you can use the above methods for log mining.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.