Routine oracle operations

1. Check the oracle instance status: selectinstance_name, version, status, database_statusfromv $ instance;

2. Check the oracle listening process: $ lsnrctlstatus

3. $ ps-ef | grep "ora _" | grep-vgrep

Oracle Data File writing process, the output is: ora_dbw0_ORCL

Oracle Log File writing process, the output is: ora_lgwr_ORCL

Oracle listens to the instance status process. The output is ora_smon_ORCL.

Oracle listens to the process in which the client connects to the process. The output is ora_pmon_ORCL.

Oracle archiving process. The output is ora_arc0_ORCL.

Oracle Checkpoint Process, the output is: ora_ckpt_ORCL

Oracle recovery process. The output is ora_reco_ORCL.

4. Check the log file of the operating system:

# Cat/var/adm/messages/grep-ioracle

5. Check oracle log files

$ Cat $ ORACLE_BASE/admin/ORCL/bump/alert_ORCL.log/grep-iora-
$ Cat $ ORACLE_BASE/admin/ORCL/bump/alert_ORCL.log/grep-ierr
$ Cat $ ORACLE_BASE/admin/ORCL/bump/alert_ORCL.log/grep-ifail

6. Check the oracle Core dump directory:

Ls $ export el_base/admin/ORCL/cdump/*. trc/wc-l
Ls $ ORACLE_BASE/admin/ORCL/udump/*. trc/wc-l

7. Check the control file select * fromv $ controlfile;

STATUS should be empty. STATUS indicates normal.

8. Check the table space status: selecttablespace_name, statusfromdba_tablespaces;
STATUS should be ONLINE

9. Check the status of all oracle Data Files: selectname, statusfromv $ datafile;

10. Check the statuses of all oracle tables, indexes, stored procedures, triggers, and package objects.

Selectowner, object_name, object_typefromdba_objectswherestatus! = 'Valid' andowner! = 'Sys' andowner! = 'System ';

This article is from the "welove" blog, please be sure to keep this source http://welove.blog.51cto.com/2879417/1296629