Dynamic log display in Oracle

Dynamic log display in Oracle

1. view the location of the log file;

IND_USER @ PROD> select inst_id, name, value 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/prod/PROD
1 Diag Trace/u01/app/oracle/diag/rdbms/prod/PROD/trace
1 Diag Alert/u01/app/oracle/diag/rdbms/prod/PROD/alert
1 Diag Incident/u01/app/oracle/diag/rdbms/prod/PROD/incident
1 Diag Cdump/u01/app/oracle/diag/rdbms/prod/PROD/cdump
1 Health Monitor/u01/app/oracle/diag/rdbms/prod/PROD/hm
1 Default Trace File/u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_or
A_00003.trc

1 Active Problem Count 0
1 Active Incident Coun 0
T

-- The alert directory is an xml file;

-- The trace directory contains text files;

[Oracle @ jibo trace] $ pwd
/U01/app/oracle/diag/rdbms/prod/PROD/trace
[Oracle @ jibo trace] $ ll-atl | grep alert *
-Rw-r ----- 1 oracle oinstall 99797 Sep 29 alert_PROD.log
[Oracle @ jibo trace] $ tail-f alert_PROD.log
Mon Sep 29 14:43:34 2014
Starting background process SMCO
Mon Sep 29 14:43:34 2014
SMCO started with pid = 28, OS id = 4709
Mon Sep 29 14:54:57 2014
Thread 1 advanced to log sequence 12 (LGWR switch)
Current log #3 seq #12 mem #0:/u01/app/oracle/oradata/PROD/onlinelog/o1_mf_3_b22567o2 _. log
Current log #3 seq #12 mem #1:/u01/app/oracle/fast_recovery_area/PROD/onlinelog/o1_mf_3_b2256827 _. log
Mon Sep 29 14:54:58 2014
Archived Log entry 7 added for thread 1 sequence 11 ID 0x102473b1 dest 1:

-- View alert logs in the operating system and run the tail command;

If there are any changes to the database, log files will generate corresponding records.

It is best to view the Learning Test