Backup and Recovery

RMAN Backup Records are Lost Regularly

by Ed Chen
May 9, 2022May 10, 2022

I found something unusual about RMAN backup records. 1. Obsolete Not Deleted Some backup files older than 3 months are definitely obsolete according to redundancy… Read More »

How to Resolve RMAN-01009: syntax error: found

by Ed Chen
April 25, 2022May 10, 2022

RMAN-01009 There're several error patterns that throw RMAN-01009 during RMAN statement execution. found "database" found "list" found "identifier" RMAN-01009 means that the word at the… Read More »

How to Resolve ORA-32005: error while parsing size specification

by Ed Chen
April 15, 2022April 20, 2022

ORA-32005 When I tried to increase the size of Fast Recovery Area (FRA) from 1TB to 1.5TB, it failed with ORA-32005. SQL> show parameter db_recovery_file_dest_size… Read More »

How to Resolve RMAN-06023: no backup or copy of datafile found to restore

by Ed Chen
February 25, 2022February 27, 2022
2 Comments

RMAN-06026 and RMAN-06023 Found errors RMAN-06026 and RMAN-06023 after several hours of database restore. RMAN> restore database; ... RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK… Read More »

How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

by Ed Chen
November 19, 2021April 5, 2022

ORA-01610 Tried to perform RECOVER DATABASE on a mounted database by SQL statement, but it failed with ORA-01610. SQL> recover database until cancel; ORA-00283: recovery… 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-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, 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-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 »