RMAN

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 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 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, 2021May 19, 2022

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, 2021April 27, 2022

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

How to Resolve RMAN-06059: expected archived log not found

by Ed Chen
July 11, 2019August 10, 2021

RMAN-06059 RMAN-06059 means that the archived logs you expect to use are missing from where they should be. In my case, when I tried to… Read More »

How to Restore RAC Database from RMAN Backup Set

by Ed Chen
July 4, 2019October 1, 2021

For 10g RAC database restoration, you may check: How to Restore 10g RAC Database from a Backup Set. Suppose we have restored 12c clusterware back.… Read More »

How to Restore 10g RAC Database from a Backup Set

by Ed Chen
June 26, 2019September 30, 2021
2 Comments

For 12c RAC database restoration, you may check: How to Restore 12c RAC Database from a Backup Set. Suppose we have recovered 10g CRS and… Read More »