seeing alert log from sql prompt


the following command can be used to see the alert log from sql prompt.

SQL> select message_text from X$DBGALERTEXT where rownum <= 50;

MESSAGE_TEXT
——————————————————————————–
Recovery of Online Redo Log: Thread 1 Group 6 Seq 53021 Reading mem 0
Mem# 0: /n01/oradata1/prp15/prp15z1_sb_redo6_01.log
Standby controlfile consistent with primary
RFS[16]: Selected log 15 for thread 2 sequence 53013 dbid -1291669901 branch 803
846963

Archived Log entry 106105 added for thread 2 sequence 53012 ID 0xb30fface dest 3
:

Media Recovery Waiting for thread 2 sequence 53013 (in transit)
Recovery of Online Redo Log: Thread 2 Group 15 Seq 53013 Reading mem 0

MESSAGE_TEXT
——————————————————————————–
Mem# 0: /n01/oradata1/prp15/prp15z2_sb_redo15_01.log
Media Recovery Waiting for thread 1 sequence 53022 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 53022 Reading mem 0
Mem# 0: /n01/oradata1/prp15/prp15z1_sb_redo5_01.log
Standby controlfile consistent with primary
RFS[16]: Selected log 16 for thread 2 sequence 53014 dbid -1291669901 branch 803
846963

Archived Log entry 106107 added for thread 2 sequence 53013 ID 0xb30fface dest 3
:
MESSAGE_TEXT
——————————————————————————–
Media Recovery Waiting for thread 2 sequence 53014 (in transit)
Recovery of Online Redo Log: Thread 2 Group 16 Seq 53014 Reading mem 0
Mem# 0: /n01/oradata1/prp15/prp15z2_sb_redo16_01.log
Media Recovery Waiting for thread 1 sequence 53023 (in transit)
Recovery of Online Redo Log: Thread 1 Group 6 Seq 53023 Reading mem 0
Mem# 0: /n01/oradata1/prp15/prp15z1_sb_redo6_01.log

reference: http://www.dbagalaxy.com/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s