文档控制2
一.数据库基本状态和信息5
二.数据库参数信息5
2.1常见参数5
2.2 常见隐含参数6
三.数据库对象和备份信息6
3.1数据库对象信息6
3.2 失效的对象6
3.3 大表TOP106
3.4数据库备份信息6
四.数据库文件信息7
4.1 表空间信息7
4.2数据文件信息7
4.3临时文件信息7
4.4控制文件信息7
4.5 控制文件限制7
4.6日志文件信息8
4.7回滚段8
4.8归档频率8
4.9 参数文件目录8
4.10 监听文件8
4.11 ASM信息9
4.12 OCR10
4.13 OLR11
4.14 VOTEDISK11
4.15 网卡11
五．数据库集群信息11
5.1查看集群名称11
5.2 查看集群状态12
5.3 集群资源12
5.4查看CRS状态14
5.5查看OHASD状态14
5.6 查看节点信息14
5.7 查看数据库名称15
5.8 查看SCAN15
5.9 查看LISTENER16
5.10 查看节点信息16
六.数据库连接信息17
七.数据库资源限制17
八.数据库权限18
九.数据库高水位18
十.性能18
10.1 TOP SQL信息18
10.2 等待事件19
10.3 数据库各个时间段负载19
10.4 查看系统统计信息19
十一.数据库日志信息20
十二.数据库补丁信息20
十三.操作系统信息21
十四.巡检脚本21

[root@rac01 bin]# ./ocrconfig -showbackup
 
rac01     2020/06/20 18:25:57     u01/app/11.2.0/grid/cdata/rac-cluster/backup00.ocr
 
rac01     2020/06/20 14:25:53     u01/app/11.2.0/grid/cdata/rac-cluster/backup01.ocr
 
rac01     2020/05/02 12:37:15     u01/app/11.2.0/grid/cdata/rac-cluster/backup02.ocr
 
rac01     2020/06/20 14:25:53     u01/app/11.2.0/grid/cdata/rac-cluster/day.ocr
 
rac01     2020/06/20 14:25:53     u01/app/11.2.0/grid/cdata/rac-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available

[root@rac01 bin]# ./cemutlo -n
rac-cluster
或
[root@rac01 bin]# ./olsnodes -c
rac-cluster

[root@rac01 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online

[root@rac01 bin]# ./crsctl check has
CRS-4638: Oracle High Availability Services is online

[root@rac01 bin]# ./olsnodes
rac01
rac02

[root@rac01 bin]# ./srvctl config database
cjcdb
[root@rac01 bin]# ./srvctl config database -d cjcdb
Database unique name: cjcdb
Database name: cjcdb
Oracle home: u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/cjcdb/spfilecjcdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: cjcdb
Database instances: cjcdb1,cjcdb2
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Database is administrator managed

[root@rac01 bin]# ./srvctl status database -d cjcdb -v


Instance cjcdb1 is running on node rac01. Instance status: Open.
Instance cjcdb2 is running on node rac02. Instance status: Open.

[root@rac01 bin]# ./srvctl config scan
SCAN name: rac-scan.cjc.com, Network: 1/192.168.31.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-scan.cjc.com/192.168.31.60
SCAN VIP name: scan2, IP: /rac-scan.cjc.com/192.168.31.70
SCAN VIP name: scan3, IP: /rac-scan.cjc.com/192.168.31.50

[root@rac01 bin]# nslookup rac-scan.cjc.com
Server:192.168.31.90
Address:192.168.31.90#53
 
Name:rac-scan.cjc.com
Address: 192.168.31.60
Name:rac-scan.cjc.com
Address: 192.168.31.70
Name:rac-scan.cjc.com
Address: 192.168.31.50

[root@rac01 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac02
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac01
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac01

[root@rac01 bin]# ./srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac02
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac01
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac01

[root@rac01 bin]# ./srvctl config listener -a
Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
  /u01/app/11.2.0/grid on node(s) rac01,rac02
End points: TCP:1521

[root@rac01 bin]# ./srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac02,rac01

[root@rac01 bin]# ./olsnodes
rac01
rac02

[root@rac01 bin]# ./srvctl status nodeapps -n rac01
VIP rac01-vip is enabled
VIP rac01-vip is running on node: rac01
Network is enabled
Network is running on node: rac01
GSD is disabled
GSD is not running on node: rac01
ONS is enabled
ONS daemon is running on node: rac01
[root@rac01 bin]# ./srvctl status nodeapps -n rac02
VIP rac02-vip is enabled
VIP rac02-vip is running on node: rac02
Network is enabled
Network is running on node: rac02
GSD is disabled
GSD is not running on node: rac02
ONS is enabled
ONS daemon is running on node: rac02

[grid@rac01 ~]$ ls /u01/app/11.2.0/grid/log/rac01/crsd/crsd.log
/u01/app/11.2.0/grid/log/rac01/crsd/crsd.log
[grid@rac01 ~]$ ls /u01/app/11.2.0/grid/log/rac01/cssd/ocssd.log
/u01/app/11.2.0/grid/log/rac01/cssd/ocssd.log
[grid@rac01 ~]$ ls /u01/app/11.2.0/grid/log/rac01/evmd/evmd.log
/u01/app/11.2.0/grid/log/rac01/evmd/evmd.log
[grid@rac01 ~]$ ls /u01/app/11.2.0/grid/log/rac01/alertrac01.log
/u01/app/11.2.0/grid/log/rac01/alertrac01.log