DBA > Job Interview Questions > Oracle DBA Checklist

Oracle DBA Checklist - Look for any new alert lo

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Oracle DBA Checklist - Look for any new alert log entries - Daily Procedures

. Connect to each managed system.
. Use 'telnet' or comparable program.
. For each managed instance, go to the background dump destination, usually $ORACLE_BASE/ <SID>/bdump. Make sure to look under each managed database's SID.
. At the prompt, use the Unix 'tail' command to see the alert_ <SID>.log, or otherwise examine the most recent entries in the file.
. If any ORA-errors have appeared since the previous time you looked, note them in the Database Recovery Log and investigate each one. The recovery log is in <file>.

(Continued on next question...)

Other Job Interview Questions