檢視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/+ASM1/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:

Oracle 11g RAC檢視ASM日誌、grid日誌和DB日誌

相關文章