Problem Diagnosis - Expert Oracle RAC Performance Diagnostics and Tuning - page 617

DELETE
DESCRIBE
DROP VIEW
END BACKUP
INSERT
LIST DEFINE
MERGE ALERT
MERGE FILE
MIGRATE
QUERY
REPAIR
SELECT
SET COLUMN
SHOW CATALOG
SHOW DUMP
SHOW SECTION
SHOW TRACE
SHOW TRACEMAP
SWEEP
UNDEFINE
UPDATE
VIEW
Viewing Alert Logs
Beginning with Oracle Database 11 g , the alert log is written as both an XML-formatted file and as a text file. You can
view either format of the file with any text editor, or you can run an ADRCI command to view the XML-formatted alert
log with the XML tags stripped. By default, ADRCI displays the alert log in your default editor. You can use the
SET EDITOR command to change your default editor:
SHOW ALERT -TAIL
This displays the last portion of the alert log (the last 10 entries) in your terminal session.
SHOW ALERT -TAIL 50
This displays the last 50 entries in the alert log in your terminal session.
SHOW ALERT -TAIL -F
This displays the last 10 entries in the alert log and then waits for more messages to arrive in the alert log. As each
message arrives, it is appended to the display. This command enables you to perform “live monitoring” of the alert
log. Press CTRL-C to stop waiting and return to the ADRCI prompt:
adrci> SHOW ALERT -TAIL -F
2010-05-12 00:05:39.881000 -07:00
database, requires manual RMAN intervention to resolve OMF
datafile pathnames.
NOTE: Please refer to the RMAN documentation for procedures
describing how to manually resolve OMF datafile pathnames.
2010-05-12 00:06:09.996000 -07:00