The most important things for data guard configuration:
Listener control files are correctly set up;
Database parameter files are correctly set up;
All data files, control files and parameter files from Primary database are correctly transferred to Standby database.
Note:
It’s not necessary to create a database on Standby server.
On standby server, it only needs files in oradata and admin [...]
Filed under: Oracle Tools | Tagged: Data Guard, Workshop | Leave a Comment »
Step 0: LogMiner Tools Installation
Log in as sysdba,
1) create dbms_logmnr package to analyze log files;
SQL>@$ORACLE_HOME/rdbms/admin/dbmslm.sql
2) create dbms_logmnr_d package to create dictionary files.
SQL>@$ORACLE_HOME/rdbms/admin/dbmslmd.sql
Step 1: Edit Parameter File
If you startup database using pfile, edit pfile directly;
If you startup database using spfile,
SQL> create pfile from spfile;
Edit init<SID>.ora and put the following:
utl_file_dir=/u01/app/oracle/admin/<SID>/udump
Step 2: Verify utl parameter
SQL> connect / as [...]
Filed under: Oracle Tools | Tagged: Logminer, Redo Log, Workshop | Leave a Comment »
