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
