image

where is oracle’s Alert Log located?

The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions. Oracle will automatically create … continue reading

image

Deleting the Archive Log in Using RMAN in oracle

run { allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel; } OR BACKUP ARCHIVELOG UNTIL TIME ‘SYSDATE-7′; DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-14′; OR allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel;      

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube