RMAN-06149 Trying to backup a database in the development environment. But failed with "RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode". RMAN> backup database tag 'BEFORE-IMPORT-PRODUCTION-2018Q1';… Read More »How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
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
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