Oracle 11g RAC查看ASM日志、grid日志和DB日志
来源:互联网 发布:免费企业域名邮箱 编辑:程序博客网 时间:2024/06/17 07:53
查看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:
[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:
阅读全文
0 0
- Oracle 11g RAC查看ASM日志、grid日志和DB日志
- ORACLE 11G RAC--日志路径
- Oracle 11G RAC开启和关闭归档日志
- oracle 11g rac开启归档日志和闪回
- oracle 11g rac+ASM,alert日志报错oraORA-15025,ORA-27041Permission denied
- Oracle DB 查看预警日志
- Oracle DB查看预警日志
- 05. Oracle 11g 查看和修改日志模式
- Oracle 11g 中日志的查看
- Oracle 10g rac将归档日志从文件系统拷贝至ASM磁盘组
- Oracle 11g grid 日志的目录结构
- Oracle 11g RAC 在 CentOS 5.5 的安装日志
- oracle 11g RAC + DG 在线日志损坏处理
- oracle 10g RAC 添加日志组和成员以及删除日志成员
- 删除oracle 11g的警告日志和监听日志
- 删除oracle 11g的警告日志和监听日志
- 删除oracle 11g的警告日志和监听日志
- oracle 11g的监听日志和警告日志
- stm32_002_stm32命名含义
- 2016版GB28181协议中语音广播功能的设备与服务器的网络拓扑结构
- Lambda expressions are not supported at language level '1.6
- js基本概念(上)之数据类型
- 微信小程序做商城是否有前景?
- Oracle 11g RAC查看ASM日志、grid日志和DB日志
- Vue 路由 vue-router
- java基础之向上造型与多态
- 仿探探:网络请求数据将卡片进行左滑右滑
- 快速排序,找中位
- Spring framework(6):SpEL 表达式
- MYSQL5.7 开启远程访问
- 是AI就躲个飞机-纯Python实现人工智能
- 阿里巴巴与星巴克合作 AR场景识别首次大规模商用