Skip to main content

Daily Oracle DBA Checklist


ü Ensure that previous night's backup is complete and there are no RMAN errors in the backup logs.

ü Ensure that any exports which are part of the backup are complete and the dump files    compressed.

ü Check the alert log for any ORA- errors - also for messages like 'Checkpoint not complete etc'.

ü Ensure that the cron job for truncating, saving and renaming alert logs is working - verify the   same.

ü Ensure that the archive redo log files are compressed and have been deleted. Only files for  current and previous day should be present.

ü All tablespaces should be less than 95% full - run the coalesce command on all tablespaces to   reduce fragmentation. Ensure that space in the TEMP tablespace is released and is 100% free   at the beginning of the day.

ü Enough contiguous free space is available in all tablespaces for objects to extend if required.

ü Backup the control file to trace so that every day we have a outline of the files and their   locations for each database.

ü No objects are within 5 extents of the MAXEXTENTS storage parameter.

ü All core dumps are deleted from the $CDUMP area.

ü All *.trc files are deleted from the $UDUMP area.

ü Check the machine for any disks 100% full or nearing that value. If a disk has filled up use   The 'find' command to determine files which have been recently created/modified. Ensure that all   
ü *.dmp files are in their proper locations and large *.dmp files have been compressed.

ü Truncate the listener.log file in the $ORACLE_HOME/network/log location if the listener log has   Increased to a size > than 500 MB. Ensure the space is released, otherwise 'reload' listener.

ü Run the 'recently created/modified objects' report to ensure that no unauthorised object   creation/modification is taking place.

ü Ensure that there are no DBMS_JOBS with the status of failed or broken. Also last refresh times   of all running jobs should be current.

ü Check to ensure that no objects exist in the database with the status 'INVALID'

Source : http://oracle-core-help.blogspot.com/2012/08/oracle-rac-interview-questions-and_9.html

Other Post: Backup options in Oracle Database.




Labels:

Comments

Post a Comment

Popular posts from this blog

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN    command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.
Post a Comment
Read more

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why  it's not working ???
Post a Comment
Read more

Error Initializing Opera: module 15

Solutions: You should manually remove directories name as "Opera" from  %PROGRAMFILES% ,%APPDATA% and %USERPROFILE% . RUN(Windows Logo Key + R)-> Enter '%PROGRAMFILES%' -> Then press OK Button. Open a new window, There find Opera folder and delete it. Same as %APPDATA%  and %USERPROFILE%. What programming languages should I learn to make a website How do i transfer music from my mac to my iPhone using the iTunes HOW TO FIX ICE CREAM SANDWICH UPDATE ERRORS !!! Fix an app that isn't working properly in Nexus how to reset Google nexus 7 Screen flicker problem in iPhone 5 DATE AND TIME PROBLEM IN IPHONE5 Another way: IF it's install in C drive you can delete opera folder from below location : c: \ Program Files \ Opera \ c: \ Documents and Settings \ Username \ Application Data \ Opera \ c: \ Documents and Settings \ Username \ Local Settings \ Application Data \ Opera \ Any you getting any problem give a comments. You can also see...
Post a Comment
Read more