Archivelog Mode

How to Resolve ORA-02231: missing or invalid option to ALTER DATABASE

by Ed Chen
December 22, 2022December 28, 2022

ORA-02231 ORA-02231 means that a keyword is missing from the position where it should be in ALTER DATABASE statement. Most likely, it's a syntax error.… Read More »

How to Resolve ORA-38707: Media recovery is not enabled

by Ed Chen
September 29, 2021October 17, 2021

ORA-38707 Tried to enable flashback of whole database, but it failed with ORA-38706 and ORA-38707. SQL> alter database flashback on; alter database flashback on *… Read More »

How to Resolve ORA-02065: illegal option for ALTER SYSTEM

by Ed Chen
September 27, 2021February 5, 2023

ORA-02065 There're 2 error patterns of ORA-02065 in this post. Enabling Archivelog Mode Set DB_RECOVERY_FILE_DEST_SIZE Enabling Archivelog Mode Some may try to enable archivelog mode… Read More »

How Oracle Check Archivelog Mode

by Ed Chen
August 17, 2021February 3, 2022

Check Archivelog Mode There're two ways that can check whether archivelog mode is enabled or not. By SQL*Plus command To use SQL*Plus specific command, you… Read More »

How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode

by Ed Chen
April 18, 2018December 11, 2022
2 Comments

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 "Can not allocate log, archival required"

by Ed Chen
March 23, 2018December 11, 2022

Can not allocate log, archival required Saw an error-like message in alert log: ORACLE Instance ORCL - Can not allocate log, archival required Actually, this… Read More »

How to Resolve ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

by Ed Chen
December 22, 2016December 30, 2021
2 Comments

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 Check Archive Log Size

by Ed Chen
June 30, 2016January 24, 2023

In this post, I will talked about the following 3 topics. How to Define Archive Log Size? Are all Archive Logs the Same Size? How… Read More »

How Oracle Enable ARCHIVELOG Mode

by Ed Chen
September 25, 2010December 11, 2022

What is Archivinglog Mode? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which… Read More »