RMAN

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

by Ed Chen
March 3, 2021January 22, 2021

I used to use multiple channels to backup the database like the following, 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, 2021March 4, 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 4, 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 to Resolve RMAN-06059: expected archived log not found

by Ed Chen
July 11, 2019July 12, 2019

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 12c RAC Database from a Backup Set

by Ed Chen
July 4, 2019October 19, 2020

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 22, 2020

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 »

How to Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019January 20, 2021

SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN… Read More »

How to Resolve ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

by Ed Chen
April 17, 2019October 20, 2019
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 RMAN Restore Database by a Backup Set

by Ed Chen
October 31, 2018January 17, 2021

In this post, I will show you how to restore a single-instance database from a backup set by RMAN. For RAC restoration, you may check… Read More »