oracle 巡检 健康检查模版 - 图文

Oracle healthcheck report ?# TNSNAMES.ORA Network Configuration File: /home/oracle9i/ora9i/product/920/network/admin/tnsnames.ora # Generated by Oracle configuration tools. XXXX01 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XSDUD111)(PORT =9622)) ) (CONNECT_DATA = (SERVICE_NAME = XXXX01) ) ) XXXX011521 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XSDUD11F)(PORT =1521)) ) (CONNECT_DATA = (SERVICE_NAME = XXXX01) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )

Chapter 4 System availability

4.1. BACKUP

Info name Policy of current backup Object of backup How long backup? Check backup or not ? content Hot backup online Application data and oracle data Everyday Y

4.2. RESTORE

Info name Policy of restore content BC Service doc

)

Page 49 of 57

Oracle healthcheck report N N ?Make a restore test or not? How long restore

4.3. DB monitor

4.3.1. Alert log

Alert log no error 4.3.2. other log

4.3.2.1 Listner log

listner log no error

4.3.2.2 Sqlnet log

Sqlnet log No error

4.3.3. Tablespace Using info.

TOTAL—TABLESPACE FILES NAME SIZE（M） DATA 10 20000 INDX 7 14000 SYSTEM 1 511 TOOLS 1 1023 UNDO 2 2046 4.3.4. Tabels and indexes info

Tablespace name DATA DATA Service doc

)

FREE—SIZE( M ) 7396 9313 225 924 2008 USE—SIZE(M） 12604 4687 286 99 38 % USED 63.02 33.48 55.90 9.66 1.88 Owner XSDOWN1 XSDOWN1 Segment Type LOBINDEX LOBSEGMENT

count 7 7 Page 50 of 57