巡检案例（1）

最新推荐文章于 2024-04-30 19:59:27 发布

cperrkg97932

最新推荐文章于 2024-04-30 19:59:27 发布

阅读量223

点赞数

文章标签：操作系统数据库

[root@ENMOEDU ~]# hostname （检查主机名）

ENMOEDU

[root@ENMOEDU ~]# cat /proc/cpuinfo （cpu的情况）

processor : 0

vendor_id : GenuineIntel

cpu family : 6

model : 42

model name : Intel(R) Core(TM) i3-2328M CPU @ 2.20GHz

stepping : 7

cpu MHz : 2195.049

cache size : 3072 KB

fdiv_bug : no

hlt_bug : no

f00f_bug : no

coma_bug : no

fpu : yes

fpu_exception : yes

cpuid level : 13

wp : yes

flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss nx rdtscp lm constant_tsc nonstop_tsc arat pni ssse3 cx16 sse4_1 sse4_2 popcnt lahf_lm [8]

bogomips : 4390.09

processor : 1

vendor_id : GenuineIntel

cpu family : 6

model : 42

model name : Intel(R) Core(TM) i3-2328M CPU @ 2.20GHz

stepping : 7

cpu MHz : 2195.049

cache size : 3072 KB

fdiv_bug : no

hlt_bug : no

f00f_bug : no

coma_bug : no

fpu : yes

fpu_exception : yes

cpuid level : 13

wp : yes

flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss nx rdtscp lm constant_tsc nonstop_tsc arat pni ssse3 cx16 sse4_1 sse4_2 popcnt lahf_lm [8]

bogomips : 4392.07

[root@ENMOEDU ~]# grep MemTotal /proc/meminfo （物理内存）

MemTotal: 1035064 kB

[root@ENMOEDU ~]# head -n 1 /etc/issue （系统版本）

Red Hat Enterprise Linux Server release 5.5 (Tikanga)

（接着检查数据库版本，控制文件，日志等的信息）

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

SQL> show parameter db_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_name string ENMOEDU

SQL> archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 92

Current log sequence 94

SQL> show parameter db_block_size

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_block_size integer 8192

SQL> show parameter vls_language

SQL> show parameter nls_language

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

nls_language string AMERICAN

SQL> select * from v$controlfile

2 ;

STATUS

-------

NAME

--------------------------------------------------------------------------------

IS_ BLOCK_SIZE FILE_SIZE_BLKS

--- ---------- --------------

/u01/app/oracle/oradata/ENMOEDU/control03.ctl

NO 16384 594

/u01/app/oracle/oradata/ENMOEDU/control01.ctl

NO 16384 594

STATUS

-------

NAME

--------------------------------------------------------------------------------

IS_ BLOCK_SIZE FILE_SIZE_BLKS

--- ---------- --------------

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC

---------- ---------- ---------- ---------- ---------- ---------- ---

STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME

---------------- ------------- --------- ------------ ---------

1 1 94 52428800 512 1 NO

CURRENT 1391127 23-MAY-14 2.8147E+14

2 1 92 52428800 512 1 NO

INACTIVE 1338533 13-APR-14 1368796 28-APR-14

3 1 93 52428800 512 1 NO

INACTIVE 1368796 28-APR-14 1391127 23-MAY-14

SQL> select * from v$logfile;

GROUP# STATUS TYPE

---------- ------- -------

MEMBER

--------------------------------------------------------------------------------

IS_

---

1 ONLINE

/u01/app/oracle/oradata/ENMOEDU/redo01.log

2 ONLINE

/u01/app/oracle/oradata/ENMOEDU/redo02.log

GROUP# STATUS TYPE

---------- ------- -------

MEMBER

--------------------------------------------------------------------------------

IS_

---

3 ONLINE

/u01/app/oracle/oradata/ENMOEDU/redo03.log

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC

---------- ---------- ---------- ---------- ---------- ---------- ---

STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME

---------------- ------------- --------- ------------ ---------

1 1 94 52428800 512 1 NO

CURRENT 1391127 23-MAY-14 2.8147E+14

2 1 92 52428800 512 1 NO

INACTIVE 1338533 13-APR-14 1368796 28-APR-14

3 1 93 52428800 512 1 NO

INACTIVE 1368796 28-APR-14 1391127 23-MAY-14

#此库没有开启归档，建议在安装部署后就开启归档防止数据丢失

（创建基线取出awr报告）

SQL> exec dbms_workload_repository.create_baseline(start_snap_id=>19,end_snap_id=>22,baseline_name=>'EOM Baseline');

[oracle@ENMOEDU admin]$ pwd

/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin

SQL> @awrrpt.sql

Current Instance

~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance

----------- ------------ -------- ------------

87396644 ENMOEDU 1 ENMOEDU

Specify the Report Type

~~~~~~~~~~~~~~~~~~~~~~~

Would you like an HTML report, or a plain text report?

Enter 'html' for an HTML report, or 'text' for plain text

Defaults to 'html'

Enter value for report_type: html

Type Specified: html

Instances in this Workload Repository schema

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id Inst Num DB Name Instance Host

------------ -------- ------------ ------------ ------------

* 87396644 1 ENMOEDU ENMOEDU ENMOEDU

Using 87396644 for database Id

Using 1 for instance number

(接着是

[root@ENMOEDU ~]# df -k

Filesystem 1K-blocks Used Available Use% Mounted on

/dev/mapper/VolGroup00-LogVol00

5078656 383112 4433400 8% /

/dev/mapper/VolGroup00-LogVol04

5078656 254428 4562084 6% /var

/dev/mapper/VolGroup00-LogVol03

5078656 3646952 1169560 76% /usr

/dev/mapper/VolGroup00-LogVol02

5078656 204460 4612052 5% /tmp

/dev/mapper/VolGroup00-LogVol01

5078656 1089992 3726520 23% /home

/dev/mapper/VolGroup00-LogVol06

50786940 12881100 35284400 27% /u01

/dev/sda1 101086 12293 83574 13% /boot

tmpfs 517532 298976 218556 58% /dev/shm

/dev/scd0 3038672 3038672 0 100% /media/RHEL_5.5 i386 DVD

[root@ENMOEDU ~]# iostat -c 5 22 （cpu闲置率）

Linux 2.6.18-194.el5 (ENMOEDU) 05/23/2014