How to start a LogMiner?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How to start a LogMiner?
Rating:
LogMiner can be started using the overloaded START_LOGMNR procedure.
-- Start using all logs
DBMS_LOGMNR.start_logmnr (
dictfilename => 'C:\Oracle\Oradata\TSH1\Archive\TSH1dict.ora');
END;
/
The analysis range can be narrowed using time or SCN.
-- Specify time range
DBMS_LOGMNR.start_logmnr (
dictfilename => 'C:\Oracle\Oradata\TSH1\Archive\TSH1\dict.ora',
starttime => TO_DATE('01-JAN-2001 00:00:00', 'DD-MON-YYYY HH:MI:SS'),
endtime => TO_DATE('01-JAN-2001 10:00:00', 'DD-MON-YYYY HH:MI:SS'));
END;
/
-- Specify SCN range
DBMS_LOGMNR.start_logmnr (
dictfilename => 'C:\Oracle\Oradata\TSH1\Archive\TSH1\dict.ora',
startscn => 100,
endscn => 150);
END;
/
Rating:
Was this information helpful?
Other articles
- What is Database Upgrade Assistant (DBUA)?
- What is ARBn?
- Tip on using the SORT_AREA_SIZE parameter.
- What is the job coordinator?
- What is the AUDIT_FILE_DEST parameter?