NOARCHIVELOG

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 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 ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

by Ed Chen
April 17, 2019December 10, 2022
2 Comments

Found ORA-19602 When I tried to backup a NOARCHIVELOG database in MOUNT state, I got ORA-19602 like the following case: RMAN> startup mount; ... RMAN>… 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 ORA-19573: cannot obtain exclusive enqueue for datafile 1

by Ed Chen
November 1, 2015December 23, 2022
6 Comments

ORA-19573 It's pretty easy to reproduce ORA-19573 because the solution is pretty easy, too. In this post, I will show you two run blocks on… 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 »

JavaScript is not enabled. Please enable it and reload the page.