Oracle 12c RAC查看ASM日志、grid日志和DB日志

最新推荐文章于 2025-02-11 16:59:27 发布

原创最新推荐文章于 2025-02-11 16:59:27 发布 · 3.2k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

oracle 专栏收录该内容

11 篇文章

订阅专栏

本文档详细介绍了如何在Oracle 12c RAC环境中查看ASM、Grid和数据库日志。通过SQL*Plus以sysasm和sysdba身份登录，展示了查询诊断参数、ASM日志、Grid组件日志以及DB日志的位置和内容，为故障排查和维护提供参考。

展开

查看ASM日志
[root@cn-db-01 ~]# su - grid
[grid@cn-db-01 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 8 17:12:31 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show parameter dump

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
background_core_dump string
partial
background_dump_dest string
/u01/app/12.2.0/grid/rdbms/log
core_dump_dest string
/u01/app/grid/diag/asm/+asm/+A
SM1/cdump
max_dump_file_size string
unlimited

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
shadow_core_dump string
partial
user_dump_dest string
/u01/app/12.2.0/grid/rdbms/log

SQL> select * from v$diag_info;

   INST_ID NAME    VALUE
---------- ---------------------------------------------------------------- -------------------------------------------------------------------------------------
1 Diag Enabled    TRUE
1 ADR Base    /u01/app/grid
1 ADR Home    /u01/app/grid/diag/asm/+asm/+ASM1
1 Diag Trace    /u01/app/grid/diag/asm/+asm/+ASM1/trace
1 Diag Alert    /u01/app/grid/diag/asm/+asm/+ASM1/alert
1 Diag Incident    /u01/app/grid/diag/asm/+asm/+ASM1/incident
1 Diag Cdump    /u01/app/grid/diag/asm/+asm/+ASM1/cdump
1 Health Monitor    /u01/app/grid/diag/asm/+asm/+ASM1/hm
1 Default Trace File    /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_11192.trc
1 Active Problem Count    0
1 Active Incident Count    0

11 rows selected.

[grid@cn-db-01 ~]$ cd /u01/app/grid/diag/asm/+asm/+ASM1/trace
[grid@cn-db-01 trace]$ tail -15 alert_+ASM1.log

查看grid日志
[grid@cn-db-01 +ASM1]$ cd $ORACLE_HOME
[grid@cn-db-01 grid]$ ls
assistants ccr          clone csmig cv      deinstall    eons gns   hs             inventory jdk   ldap md    network ohasd     opmn         ord       owm    plsql    psu    relnotes        scheduler srvm    utl
auth        cdata        crf    css    dbs     demo         evm   gpnp install        javavm     jlib lib   mdns nls      ologgerd oracore      osysmond patch precomp racg   root.sh         slax       sysman wwg
bin         cfgtoollogs crs    ctss   dc_ocm diagnostics gipc has   instantclient jdbc       JRE   log   mesg oc4j     OPatch    oraInst.loc oui       perl   product rdbms rootupgrade.sh sqlplus    usm     xdk
[grid@cn-db-01 grid]$ cd log/
[grid@cn-db-01 log]$ ls
cn-db-01 cn-db-01 crs diag
[grid@cn-db-01 log]$ cd cn-db-01/
[grid@cn-db-01 cn-db-01]$ ls
acfslog acfsrepl acfsreplroot acfssec admin agent alertcn-db-01.log client crflogd crfmond crsd cssd ctssd cvu diskmon evmd gipcd gnsd gpnpd mdnsd ohasd racg srvm
[grid@cn-db-01 cn-db-01]$ tail -15 alertcn-db-01.log

查看DB日志
[grid@cn-db-01 cn-db-01]$ exit
logout
[root@cn-db-01 ~]# su - oracle
[oracle@cn-db-01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 6 13:59:27 2016

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

SQL> show parameter dump

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump     string partial
background_dump_dest     string /u01/app/oracle/diag/rdbms/aft
db/aftdb1/trace
core_dump_dest     string /u01/app/oracle/diag/rdbms/aft
db/aftdb1/cdump
max_dump_file_size     string unlimited
shadow_core_dump     string partial
user_dump_dest     string /u01/app/oracle/diag/rdbms/aft
db/aftdb1/trace
SQL> set line 200
SQL> col value for a85
SQL> select * from v$diag_info;

   INST_ID NAME    VALUE
---------- ---------------------------------------------------------------- -------------------------------------------------------------------------------------
1 Diag Enabled    TRUE
1 ADR Base    /u01/app/oracle
1 ADR Home    /u01/app/oracle/diag/rdbms/aftdb/aftdb1
1 Diag Trace    /u01/app/oracle/diag/rdbms/aftdb/aftdb1/trace
1 Diag Alert    /u01/app/oracle/diag/rdbms/aftdb/aftdb1/alert
1 Diag Incident    /u01/app/oracle/diag/rdbms/aftdb/aftdb1/incident
1 Diag Cdump    /u01/app/oracle/diag/rdbms/aftdb/aftdb1/cdump
1 Health Monitor    /u01/app/oracle/diag/rdbms/aftdb/aftdb1/hm
1 Default Trace File    /u01/app/oracle/diag/rdbms/aftdb/aftdb1/trace/aftdb1_ora_11231.trc
1 Active Problem Count    0
1 Active Incident Count    0

11 rows selected.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
[oracle@cn-db-01 ~]$ cd /u01/app/oracle/diag/rdbms/aftdb/aftdb1/trace
[oracle@cn-db-01 trace]$ tail -15 alert_aftdb1.log
Thread 1 advanced to log sequence 52012 (LGWR switch)
  Current log# 14 seq# 52012 mem# 0: +REDO1/aftdb/onlinelog/group_14.261.833907273
  Current log# 14 seq# 52012 mem# 1: +REDO2/aftdb/onlinelog/group_14.261.833907273
Wed Jul 06 13:36:45 2016
LNS: Standby redo logfile selected for thread 1 sequence 52012 for destination LOG_ARCHIVE_DEST_2
Wed Jul 06 13:36:46 2016
Archived Log entry 115031 added for thread 1 sequence 52011 ID 0x70e495b1 dest 1:
Wed Jul 06 13:48:55 2016
Thread 1 advanced to log sequence 52013 (LGWR switch)
  Current log# 9 seq# 52013 mem# 0: +REDO1/aftdb/onlinelog/group_9.264.833907267
  Current log# 9 seq# 52013 mem# 1: +REDO2/aftdb/onlinelog/group_9.264.833907267
Wed Jul 06 13:48:55 2016
LNS: Standby redo logfile selected for thread 1 sequence 52013 for destination LOG_ARCHIVE_DEST_2
Wed Jul 06 13:48:56 2016
Archived Log entry 115034 added for thread 1 sequence 52012 ID 0x70e495b1 dest 1: