Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Alert Log files

Neo-bOct 5 2010 — edited Oct 5 2010

Hello All,

I am using Oracle 10g and i have 2 questions regarding the alert log files:

1. is there any view to check the location of the alert log file on the db server?

2. i have the below file that was communicated to me, but i am not feeling that it is the log file, i am feeling it is a log about the redo logs, is there anyway to know if the file that i have is an alert log file ? below is only a part of the file since i cannot add all of it here

Tue Sep 21 16:18:45 2010
Thread 1 advanced to log sequence 30143 (LGWR switch)
Current log# 4 seq# 30143 mem# 0: /dbase/oradata/imal/redo_1_4.log
Tue Sep 21 16:18:46 2010
LNS: Standby redo logfile selected for thread 1 sequence 30143 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 16:18:46 2010
LNS: Standby redo logfile selected for thread 1 sequence 30143 for destination LOG_ARCHIVE_DEST_1
Tue Sep 21 16:36:43 2010
Thread 1 advanced to log sequence 30144 (LGWR switch)
Current log# 5 seq# 30144 mem# 0: /dbase/oradata/imal/imal_redo1_5.log
Tue Sep 21 16:36:43 2010
LNS: Standby redo logfile selected for thread 1 sequence 30144 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 17:02:43 2010
Thread 1 advanced to log sequence 30145 (LGWR switch)
Current log# 1 seq# 30145 mem# 0: /dbase/oradata/imal/redo01.log
Tue Sep 21 17:02:44 2010
LNS: Standby redo logfile selected for thread 1 sequence 30145 for destination LOG_ARCHIVE_DEST_1
Tue Sep 21 17:02:45 2010
LNS: Standby redo logfile selected for thread 1 sequence 30145 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 17:02:55 2010
Thread 1 advanced to log sequence 30146 (LGWR switch)
Current log# 2 seq# 30146 mem# 0: /dbase/oradata/imal/redo02.log
Tue Sep 21 17:02:55 2010
LNS: Standby redo logfile selected for thread 1 sequence 30146 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 17:03:36 2010
Thread 1 advanced to log sequence 30147 (LGWR switch)
Current log# 3 seq# 30147 mem# 0: /dbase/oradata/imal/redo03.log
Tue Sep 21 17:03:37 2010
LNS: Standby redo logfile selected for thread 1 sequence 30147 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 17:03:59 2010
Thread 1 advanced to log sequence 30148 (LGWR switch)
Current log# 4 seq# 30148 mem# 0: /dbase/oradata/imal/redo_1_4.log
Tue Sep 21 17:04:00 2010
LNS: Standby redo logfile selected for thread 1 sequence 30148 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 17:07:14 2010
Thread 1 advanced to log sequence 30149 (LGWR switch)
Current log# 5 seq# 30149 mem# 0: /dbase/oradata/imal/imal_redo1_5.log
Tue Sep 21 17:07:15 2010
LNS: Standby redo logfile selected for thread 1 sequence 30149 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 17:12:21 2010
Thread 1 advanced to log sequence 30150 (LGWR switch)
Current log# 1 seq# 30150 mem# 0: /dbase/oradata/imal/redo01.log
Tue Sep 21 17:12:23 2010
LNS: Standby redo logfile selected for thread 1 sequence 30150 for destination LOG_ARCHIVE_DEST_2
Tue Sep 21 17:12:23 2010
LNS: Standby redo logfile selected for thread 1 sequence 30150 for destination LOG_ARCHIVE_DEST_1
Tue Sep 21 17:13:19 2010
Thread 1 advanced to log sequence 30151 (LGWR switch)
Current log# 2 seq# 30151 mem# 0: /dbase/oradata/imal/redo02.log

asifkabirdba

SQL> set line 900;
SQL> show parameters dump

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle/product/admin/syslog/bdump

Alter log file is located in BDUMP location.

You will find alert log has a name like alert_SID.log

So, here SID name is SYSLOG so alert log name will be alert_syslog.log

Regards
Asif Kabir

KanchDev

hi

Check your bdump parameter value. this is the location you find the alertLog file. also I feel that you are looking at your alert log . also you have a standby database as well.

SQL>
SQL>
SQL> sho parameter background_dump_dest

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
background_dump_dest                 string
/db/test/admin/bdump
SQL>

isn't it ?

Cheers
Kanchana.

Azar

In Oracle 10g , the alert log file should be located at BDUMP direcotry, you can find here

SQL> show parameter dump;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN\broker\bdump

Additional, In Oracle 11g, you can find out from V$diag_info view.

SQL> select * from v$diag_info;

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
1 Diag Enabled
TRUE

1 ADR Base
c:\app\mazar

1 ADR Home
c:\app\mazar\diag\rdbms\own\own

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
1 Diag Trace
c:\app\mazar\diag\rdbms\own\own\trace

1 Diag Alert
c:\app\mazar\diag\rdbms\own\own\alert

Second question, I couldnot understand what you're asking..

Edited by: Azar on Oct 5, 2010 12:20 AM

Edited by: Azar on Oct 5, 2010 12:24 AM

Neo-b

do you have any idea if the part that i mentioned in my previous message can be a part of the alert log file?

Regards,

779621

HI,

I have a 10g installed on my local system and i have a database name "TEST"

If i want to know the alter logfile location i would do :-

SQL> SHOW PARAMETER BACKGROUND_DUMP_DEST

NAME TYPE VALUE
------------------------------------ ----------- --------------------
background_dump_dest string C:\ADMIN\DB\BDUMP

If i go to " C:\ADMIN\DB\BDUMP" location ,Alter log file would be in the format " alert_test.log"

asifkabirdba

Yes, it was the alert log file.

Regards
Asif Kabir

NB
Newbie

Handle: NB
Status Level: Newbie
Registered: Apr 27, 2009
Total Posts: 119
Total Questions: *51 (46 unresolved)*

-- mark your helpful post as correct/helpful and close all the threads.

1 - 6

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2010

Added on Oct 5 2010

#general-database-discussions

6 comments

9,323 views

Oracle Database Discussions

Alert Log files

Comments

Post Details