查看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
查看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:
