Shulou(Shulou.com)06/01 Report--

View ASM Log

[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

View grid Log

[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

View DB Log

[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:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.