oracle中001文件怎么打开,请问redolog文件要怎么打开，怎么我打开的全是乱码，这让我怎么看啊？？...

Using LogMiner

What Can LogMiner Be Used For?

LogMiner provides a procedure to process the redo log files and translate their

contents into SQL statements that represent the logical operations performed to the

database.

Technical Note

LogMiner runs in Oracle release 8.1 or later.

Redo log files from any release 8.0 or later of the database can be analyzed.

Copyright Ó Oracle Corporation, 1999. All rights reserved.

®

Analyzing the Redo Log Files

• Track changes:

– To the database

– To a specific table

– To a specific user

• Map data access patterns

• Undo changes to the database

• Use archived data to perform tuning and capacity

planning

What You Should Do Before Using LogMiner

LogMiner runs in an Oracle instance with the database either mounted or unmounted.

LogMiner uses a dictionary file, which is a special file that indicates the database that

created it as well as the time the file was created. The dictionary file is not required,

but recommended.

Without a dictionary file, the equivalent SQL statements will use an Oracle internal

object ID for the object name and present column values as hex data.

Creating a Dictionary File

• Specify the initialization parameter UTL_FILE_DIR to specify a directory that is

permitted for PL/SQL file I/O.

• Execute the DBMS_LOGMNR_D.BUILD procedure to create the dictionary file.

Copyright Ó Oracle Corporation, 1999. All rights reserved.

®

How to Use LogMiner

• Specify UTL_FILE_DIR

• Create a dictionary file

EXECUTE DBMS_LOGMNR_D.BUILD(‘ v815dict.ora’,

‘ C:\ora815\admin\v815\log’);