1500字范文 > rac 火星舱如何备份oracle_Oracle数据库(RAC)巡检报告

rac 火星舱如何备份oracle_Oracle数据库(RAC)巡检报告

时间：2024-04-11 04:50:32

文档控制2一.数据库基本状态和信息5二.数据库参数信息52.1常见参数52.2 常见隐含参数6三.数据库对象和备份信息63.1数据库对象信息63.2 失效的对象63.3 大表TOP1063.4数据库备份信息6四.数据库文件信息74.1 表空间信息74.2数据文件信息74.3临时文件信息74.4控制文件信息74.5 控制文件限制74.6日志文件信息84.7回滚段84.8归档频率84.9 参数文件目录84.10 监听文件84.11 ASM信息94.12 OCR104.13 OLR114.14 VOTEDISK114.15 网卡11五．数据库集群信息115.1查看集群名称115.2 查看集群状态125.3 集群资源125.4查看CRS状态145.5查看OHASD状态145.6 查看节点信息145.7 查看数据库名称155.8 查看SCAN155.9 查看LISTENER165.10 查看节点信息16六.数据库连接信息17七.数据库资源限制17八.数据库权限18九.数据库高水位18十.性能1810.1 TOP SQL信息1810.2 等待事件1910.3 数据库各个时间段负载1910.4 查看系统统计信息19十一.数据库日志信息20十二.数据库补丁信息20十三.操作系统信息21十四.巡检脚本21

一.数据库基本状态和信息

二.数据库参数信息

2.1常见参数

2.2 常见隐含参数

三.数据库对象和备份信息

3.1数据库对象信息

3.2 失效的对象

3.3 大表TOP10

3.4数据库备份信息

四.数据库文件信息

4.1 表空间信息

4.2数据文件信息

4.3临时文件信息

4.4控制文件信息

4.5 控制文件限制

4.6日志文件信息

4.7回滚段

4.8归档频率

4.9 参数文件目录

4.10 监听文件

---listener.ora

---tnsname.ora

---sqlnet.ora

4.11 ASM信息

4.12 OCR

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

4.13 OLR

4.14 VOTEDISK

4.15 网卡

五．数据库集群信息

5.1查看集群名称

[root@rac01 bin]# ./cemutlo -nrac-cluster或[root@rac01 bin]# ./olsnodes -crac-cluster

5.2 查看集群状态

5.3 集群资源

或

5.4查看CRS状态

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

5.5查看OHASD状态

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

5.6 查看节点信息

[root@rac01 bin]# ./olsnodesrac01rac02

5.7 查看数据库名称

[root@rac01 bin]# ./srvctl config databasecjcdb[root@rac01 bin]# ./srvctl config database -d cjcdbDatabase unique name: cjcdbDatabase name: cjcdbOracle home: /u01/app/oracle/product/11.2.0/db_1Oracle user: oracleSpfile: +DATA/cjcdb/spfilecjcdb.oraDomain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: cjcdbDatabase instances: cjcdb1,cjcdb2Disk Groups: DATAMount point paths:Services:Type: RACDatabase is administrator managed

[root@rac01 bin]# ./srvctl status database -d cjcdb -vInstance cjcdb1 is running on node rac01. Instance status: Open.Instance cjcdb2 is running on node rac02. Instance status: Open.

5.8 查看SCAN

配置

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

DNS

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

状态

[root@rac01 bin]# ./srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac02SCAN VIP scan2 is enabledSCAN VIP scan2 is running on node rac01SCAN VIP scan3 is enabledSCAN VIP scan3 is running on node rac01

SCAN_LISTENER状态

[root@rac01 bin]# ./srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is running on node rac02SCAN Listener LISTENER_SCAN2 is enabledSCAN listener LISTENER_SCAN2 is running on node rac01SCAN Listener LISTENER_SCAN3 is enabledSCAN listener LISTENER_SCAN3 is running on node rac01

5.9 查看LISTENER

配置

[root@rac01 bin]# ./srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome: /u01/app/11.2.0/grid on node(s) rac01,rac02End points: TCP:1521

状态

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

5.10 查看节点信息

[root@rac01 bin]# ./olsnodesrac01rac02

[root@rac01 bin]# ./srvctl status nodeapps -n rac01VIP rac01-vip is enabledVIP rac01-vip is running on node: rac01Network is enabledNetwork is running on node: rac01GSD is disabledGSD is not running on node: rac01ONS is enabledONS daemon is running on node: rac01[root@rac01 bin]# ./srvctl status nodeapps -n rac02VIP rac02-vip is enabledVIP rac02-vip is running on node: rac02Network is enabledNetwork is running on node: rac02GSD is disabledGSD is not running on node: rac02ONS is enabledONS daemon is running on node: rac02

六.数据库连接信息

七.数据库资源限制

八.数据库权限

角色

系统权限

表权限

列权限

九.数据库高水位

十.性能

10.1 TOP SQL信息

10.2 等待事件

……

10.3 数据库各个时间段负载

10.4 查看系统统计信息

十一.数据库日志信息

[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