Skip to Main Content
Forums

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2010
Added on Oct 5 2010
#general-database-discussions
6 comments
9,332 views