Saw an error-like message in alert log: ORACLE Instance ORCL - Can not allocate log, archival required This message implies LGWR is waiting for archival… Read More »How to Resolve "Can not allocate log, archival required"
ORA-00265 I bet your database is 8i or 9i and you were trying to startup the database along with a set of procedure in a… Read More »How to Resolve ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Do you know the space that the archived destination has in terms of days? Here is a sample shell script code to calculate the maximum… Read More »How to Calculate the Capacity of Archive Destination in Days
In this post, I will show you how to enable archivelog mode in 9i. For those who are using Oracle 10g onwards, you may take… Read More »How to Enable ARCHIVELOG Mode in Oracle 9i
For 9i database or below, please refer to: How to Enable ARCHIVELOG Mode in Oracle 9i What is Archiving? The process of copying inactive redo… Read More »How to Enable ARCHIVELOG Mode in Oracle