ARCHIVE AREA FULL – CONNECT INTERNAL UNTIL FREED

Posted by Arjun Raja
On June 29, 2009
0 Comments

When a database is running in ARCHIVELOG mode, if the area which stores the archivelogs on disk gets full, the database comes to a halt and can be accessed only as a sysdba. The error message when you try to connect as a normal user is ‘ CONNECT INTERNAL UNTIL FREED’ If the following parameter […]

Posted by Gavin Soorma
On June 20, 2009
2 Comments

select trunc(completion_time) rundate ,count(*) logswitch ,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)" from v$archived_log group by trunc(completion_time) order by 1;

News

ARCHIVE AREA FULL – CONNECT INTERNAL UNTIL FREED

Script- Track redo generation by day