Sunday, November 2, 2008

Logminer in Oracle 10g

Requirements:
The following are requirements for the source and mining database, the data dictionary, and the redo log files that LogMiner will mine:
Source and mining database
Both the source database and the mining database must be running on the same hardware platform.
1.The mining database can be the same as, or completely separate from, the source database.
2.The mining database must run the same version or a later version of the Oracle Database software as the source database.
3.The mining database must use the same character set (or a superset of the character set) used by the source database.
LogMiner dictionary
1.The dictionary must be produced by the same source database that generates the redo log files that LogMiner will analyze.
All redo log files:
1.Must be produced by the same source database.
2.Must be associated with the same database RESETLOGS SCN.
3.Must be from a release 8.0 or later Oracle Database.

Others:
You must enable supplemental logging prior to generating log files that will be analyzed by LogMiner.
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

No comments:

search engine

Custom Search