ALTER DATABASE ARCHIVELOG

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-01123: cannot start online backup; media recovery not enabled

by Ed Chen
September 24, 2021June 10, 2022

ORA-01123 Tried to make the whole database enter backup mode, but it failed with ORA-01123. SQL> alter database begin backup; alter database begin backup *… 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 »