Backup and Recovery

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 by a Backup Set

by Ed Chen
July 4, 2019February 13, 2020

For 10g RAC database restoration, you may check: How to Restore 10g RAC Database by 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, 2019August 7, 2019

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 »

How to Restore 10g RAC Database by a Backup Set

by Ed Chen
June 26, 2019February 13, 2020

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

How to Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019July 17, 2019

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 Restore 10g Clusterware OCR Voting Disk

by Ed Chen
June 20, 2019January 21, 2020

For 12c clusterware, you may check: How to Restore 12c Clusterware Suppose we have lost the shared storage as well as OCR data, voting disk… Read More »

How to Backup Clusterware OCR and Voting Disk

by Ed Chen
June 16, 2019February 11, 2020

In this post, I will introduce some ways to backup Oracle Cluster Registry (OCR) data and voting disk in case of losing all configuration. Backup… Read More »

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

by Ed Chen
April 17, 2019October 20, 2019

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, 2018February 13, 2020

Suppose we have restored the whole OS to the new server including Oracle software and directory structure. Our goal is to restore the database to… Read More »

How to Restore Dropped Tables from Recycle Bin

by Ed Chen
August 10, 2018May 7, 2019

Restoring Dropped Table There're several ways that can recover your table: Export/Import: You can use impdp (or imp) utility to import your dropped table from… Read More »