Backup and Recovery

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, 2021October 18, 2021

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, 2021August 22, 2021

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

How to Resolve ORA-00283 and ORA-00264

by Ed Chen
August 7, 2021July 6, 2021

ORA-00283 and ORA-00264 When you saw both ORA-00283 and ORA-00264 at the same time like the following: SQL> recover database; ORA-00283: recovery session canceled due… Read More »

How to Resolve RMAN-03009: failure of allocate command on channel

by Ed Chen
March 3, 2021March 14, 2021

RMAN-03009 I used to allocate multiple RMAN channels to backup the database parallelly, but I failed with RMAN-03009 about channel allocation problem. RMAN> run {… Read More »

How RMAN Duplex Backup Copies

by Ed Chen
February 20, 2021January 7, 2021

After knowing how to change the backup location in different scenarios, let's see a more advance topic about making backup copies in RMAN. By default,… Read More »

How RMAN Set Backup Location

by Ed Chen
February 17, 2021August 29, 2021

By default, all backup pieces of RMAN go to Fast Recovery Area (FRA), but we can change it. In RMAN, we can set different backup… Read More »

How RMAN Backup Parallelly

by Ed Chen
February 15, 2021March 10, 2021

To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle high volume… Read More »

How Oracle Purge RecycleBin

by Ed Chen
November 21, 2020October 10, 2021

Since 10g, we have recycle bin that can store dropped tables and indexes. Whenever we need them, we can flashback the dropped tables or indexes… Read More »

How to Backup Oracle Home before Patching

by Ed Chen
September 9, 2020September 25, 2021

I know there're OS backups on database servers already, so we usually don't have to backup Oracle software by ourselves. In case that you don't… Read More »