Oracle 11g RAC查看ASM日志、grid日志和DB日志

迷南。 2024-04-18 01:57 2阅读 0赞

**查看ASM日志**  
\[root@ATFDB1 ~\]\# su - grid  
 \[grid@ATFDB1 ~\]$  **sqlplus / as sysasm**  
  
 SQL\*Plus: Release 11.2.0.3.0 Production on Wed Jul 6 13:41:48 2016  
  
 Copyright (c) 1982, 2011, Oracle.  All rights reserved.  
  
 Connected to:  
 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production  
 With the Real Application Clusters and Automatic Storage Management options  
SQL>  **show parameter dump**  
  
 NAME     TYPE VALUE  
 \------------------------------------ ----------- ------------------------------  
 background\_core\_dump     string partial  
 background\_dump\_dest     string /u01/app/grid/diag/asm/+asm/+A  
 SM1/trace  
 core\_dump\_dest     string /u01/app/grid/diag/asm/+asm/+A  
 SM1/cdump  
 max\_dump\_file\_size     string unlimited  
 shadow\_core\_dump     string partial  
 user\_dump\_dest     string /u01/app/grid/diag/asm/+asm/+A SM1/trace  
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@ATFDB1 ~\]$ cd /u01/app/grid/diag/asm/+asm/+ASM1/trace  
 \[grid@ATFDB1 trace\]$ tail -15 alert\_+ASM1.log  
  
**查看grid日志**  
\[grid@ATFDB1 +ASM1\]$  **cd $ORACLE\_HOME**  
 \[grid@ATFDB1 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@ATFDB1 grid\]$  **cd log/**  
 \[grid@ATFDB1 log\]$ ls  
 atfdb1  ATFDB1  crs  diag  
 \[grid@ATFDB1 log\]$ cd atfdb1/  
 \[grid@ATFDB1 atfdb1\]$ ls  
 acfslog  acfsrepl  acfsreplroot  acfssec  admin  agent  alertatfdb1.log  client  crflogd  crfmond  crsd  cssd  ctssd  cvu  diskmon  evmd  gipcd  gnsd  gpnpd  mdnsd  ohasd  racg  srvm  
 \[grid@ATFDB1 atfdb1\]$ tail -15 alertatfdb1.log   
  
**查看DB日志**  
\[grid@ATFDB1 atfdb1\]$ exit  
 logout  
 \[root@ATFDB1 ~\]\# su - oracle  
 \[oracle@ATFDB1 ~\]$ sqlplus / as sysdba  
  
 SQL\*Plus: Release 11.2.0.3.0 Production on Wed Jul 6 13:59:27 2016  
  
 Copyright (c) 1982, 2011, Oracle.  All rights reserved.  
  
 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@ATFDB1 ~\]$ cd /u01/app/oracle/diag/rdbms/aftdb/aftdb1/trace  
 \[oracle@ATFDB1 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:

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2121607/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2121607/