RMAN

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 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 »

How to Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019September 29, 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 10, 2021
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 from BackupSet

by Ed Chen
October 31, 2018October 2, 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 »