Backup and Recovery

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, 2021March 10, 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 Purge Recycle Bin in Oracle

by Ed Chen
November 21, 2020March 14, 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 Software including Oracle Home and Grid Infra

by Ed Chen
September 9, 2020September 4, 2020

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 »

How to Backup Oracle Inventory

by Ed Chen
September 5, 2020September 8, 2020

Using cp You don't have to tar or zip all of Oracle central inventory, because the inventory is pretty small, normally, it's in several megabytes.… Read More »

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

by Ed Chen
July 11, 2019March 17, 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 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 12c Clusterware OCR Voting Disk

by Ed Chen
June 30, 2019January 19, 2021

For 10g clusterware, you may check: How to Restore 10g Clusterware. Suppose we have lost all disk groups as well as OCR data, voting disk… Read More »