linux中oracle的日常维护命令

ORA-06512: at "PS_SYSTEM.ROW_VALIDATOR_T", line 924

ORA-06512: at "WORKORDER.INVENTORY_UTL", line 1260

ORA-12012: error on auto execute of job 78677

4.1 查alert_SID.log中的err的信息：

$ more /u01/app/oracle/admin/pinnsoft/bdump/alert_pinnsoft.log | grep -i err

Errors in file /u01/app/oracle/admin/pinnsoft/bdump/pinnsoft_j000_2666.trc:

ORA-12012: error on auto execute of job 78677

: 6000101: Error occurred when rolling Inventory date

Errors in file /u01/app/oracle/admin/pinnsoft/bdump/pinnsoft_j000_11886.trc:

ORA-12012: error on auto execute of job 78677

: 6000101: Error occurred when rolling Inventory date

Errors in file /u01/app/oracle/admin/pinnsoft/bdump/pinnsoft_j000_21375.trc:

ORA-12012: error on auto execute of job 78677

: 6000101: Error occurred when rolling Inventory date

4.2 查alert_SID.log的fail的信息：

$ more /u01/app/oracle/admin/pinnsoft/bdump/alert_pinnsoft.log | grep -i fail

PMON failed to acquire latch, see PMON dump

PMON failed to acquire latch, see PMON dump

PMON failed to acquire latch, see PMON dump

5. 检查控制文件状态

SQL> select status,name from v$controlfile;

STATUS  NAME

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

/data/app/oracle/oradata/PPRD10/control01.ctl

/data/app/oracle/oradata/PPRD10/control02.ctl

/data/app/oracle/oradata/PPRD10/control03.ctl

输出结果应该有3条以上（包含3条）的记录，“STATUS”应该为空。状态为空表示控制文件状态正常。

6.  查询日志状态

SQL> select group#,status,member from v$logfile;

GROUP#  STATUS  MEMBER

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

1         /data/app/oracle/oradata/PPRD10/redo01.log

2         /data/app/oracle/oradata/PPRD10/redo02.log

3         /data/app/oracle/oradata/PPRD10/redo03.log

输出结果应该有3条以上（包含 3 条）记录，”STATUS”应该为非”INVALID”，非“DELETED”。

7 .  查询数据状态：

SQL> select file#,status,name from v$datafile;

FILE#  STATUS   NAME

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

1  SYSTEM  /u01/app/oracle/oradata/orcl/system01.dbf

2  ONLINE  /u01/app/oracle/oradata/orcl/undotbs01.dbf

3  ONLINE  /u01/app/oracle/oradata/orcl/sysaux01.dbf

4  ONLINE  /u01/app/oracle/oradata/orcl/users01.dbf

5  ONLINE  /u01/app/oracle/oradata/orcl/example01.dbf

6  ONLINE  /u01/app/oracle/oradata/orcl/perfstat.dbf

7  ONLINE  /u01/app/oracle/oradata/orcl/risenet.dbf

“ONLINE"表示正常在线状态

8 . 查询表空间状态

SQL> select tablespace_name,status from dba_tablespaces;

TABLESPACE_NAME           STATUS

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

SYSTEM                           ONLINE

UNDOTBS1                       ONLINE

SYSAUX                           ONLINE

本文URL地址：http://www.bianceng.cn/OS/Linux/201410/45428.htm

（编辑：温州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!