Shulou(Shulou.com)06/01 Report--

Catalogue

Document Control 2

one。 Database basic status and information 5

two。 Database parameter information 5

2.1 Common parameters 5

2.2 Common implied parameters 6

three。 Database objects and backup Info 6

3.1 Database object Information 6

3.2 invalid object 6

3.3 large table TOP10 6

3.4 Database backup information 6

four。 Database file information 7

4.1 Tablespace information 7

4.2 data file information 7

4.3 temporary file information 7

4.4 Control file information 7

4.5 Control File limits 7

4.6 Log file information 8

4.7 Roll back Segment 8

4.8 Archive Frequency 8

4.9 Parameter file directory 8

4. 1 0 listening files 8

4.11 ASM Information 9

4.12 OCR 10

4.13 OLR 11

4.14 VOTEDISK 11

4.15 Network Card 11

V. Database cluster information 11

5.1 View cluster name 11

5.2 View cluster status 12

5.3 Cluster resources 12

5.4 View CRS status 14

5.5 View OHASD status 14

5.6 View node information 14

5.7 View database name 15

5.8View SCAN 15

5.9 View LISTENER 16

5.10 View node information 16

Six. Database connection information 17

Seven. Database resource limit 17

Eight. Database permissions 18

Nine. Database high water level 18

Ten. Performance 18

10. 1 TOP SQL information 18

10. 2 waiting for event 19

10.3 Database load for each time period 19

10.4 View system statistics 19

Ten one. Database log information 20

Ten, two. Database Patch Info 20

Ten, three. Operating system Information 21

Ten, four. Inspection script 21

one。 Basic status and information of database

two。 Database parameter information

2.1 Common parameters

2.2 Common implied parameters

three。 Database objects and backup information

3.1 Database object information

3.2failed objects 3.3Big TOP10

3.4 Database backup information

four。 Database file information 4.1 tablespace information

4.2 data file information

4.3 temporary file information

4.4 Control file information

4.5 Control File limits

4.6 log file information

4.7 rollback segment

4.8 filing frequency

4.9 Parameter file directory

4. 1 0 listening for files

-listener.ora

-tnsname.ora

-sqlnet.ora

4.11 ASM Information

4.12 OCR

[root@rac01 bin] #. / ocrconfig-showbackup rac01 18:25:57 on 2020-06-20 / 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.ocrPROT-25: Manual backups for the Oracle Cluster Registry are not available4.13 OLR

4.14 VOTEDISK

4.15 network card

5. Database cluster information 5.1 View cluster name

[root@rac01 bin] #. / cemutlo-n

Rac-cluster

Or

[root@rac01 bin] #. / olsnodes-c

Rac-cluster

5.2 View cluster status

5.3 Cluster resources

[root@rac01 bin] #. / crsctl stat res-t

Or

5.4 View CRS status [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 View OHASD status

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

5.6 View node information

[root @ rac01 bin] #. / olsnodes

Rac01

Rac02

5.7 View the database name [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.8View SCAN

Configuration

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

DNS

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

Status

[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 statu

[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 View LISTENER

Configuration

[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

Status

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

5.10 View node information

[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

Six. Database connection information

Seven. Database resource limit

Eight. Database permissions

Role

System permissions

Table permissions

Column permissions

Nine. Database high water level

Ten. Performance 10. 1 TOP SQL message 10. 2 wait event

……

10.3 Database load 10.4 for each period to view system statistics

Ten one. Database log information

[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

Ten, two. Database patch information

Ten, three. Operating system information

Ten, four. Inspection script

For the contents of the inspection, see my blog column "Oracle daily operation and maintenance-summary of common scripts"

Http://blog.itpub.net/29785807/viewspace-2699676/

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.