Oracle 11g RAC查看ASM日志、grid日志和DB日志
发表于：2025-02-05 作者：千家信息网编辑
千家信息网最后更新 2025年02月05日，查看ASM日志[root@ATFDB1 ~]# su - grid[grid@ATFDB1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.3.0 Pr
千家信息网最后更新 2025年02月05日Oracle 11g RAC查看ASM日志、grid日志和DB日志查看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:
日志
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
打开旺旺吧数据库
软件开发与维护试题
oppo的网络安全钥匙
服务器打开远程
数据库软件分类砧板
苗大哥新引擎网络技术
一级高级软件开发工程师
擦边 服务器
h3c服务器即是惠普服务器吗
网络安全专题会议简报
服务器如何切换到笔记本上显示
失落的方舟服务器数据是通的吗
宠物软件开发费用明细
数据库表钱包加密
综合管理服务器是什么
db数据库 详细
网络技术挑战赛决赛
数据库y键怎么做
普陀区会计网络技术管理方法
数据库的知识点概括
一核2g服务器 2008系统
网络安全 木马 论文
网络安全密码怎么改
网络安全中网络自身问题
电脑服务器怎么查看主机名
java猜数字游戏数据库
芜湖餐饮软件开发哪家好
深圳小吧嗒互联网科技有限公司
综合管理服务器是什么
db数据库 详细
