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-38707: Media recovery is not enabled
ORA-02065 There're 2 error patterns of ORA-02065 in this post. Enabling Archivelog Mode Set DB_RECOVERY_FILE_DEST_SIZE A. Enabling Archivelog Mode Some may try to enable archivelog… Read More »How to Resolve ORA-02065: illegal option for ALTER SYSTEM
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
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 "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