RMAN

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 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 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 Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode

by Ed Chen
April 18, 2018November 6, 2019

RMAN-06149 Trying to backup a database in the development environment. But failed with "RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode". RMAN> backup database tag 'BEFORE-IMPORT-PRODUCTION-2018Q1';… Read More »

Online Archived Logs vs Backup Archived Logs

by Ed Chen
April 14, 2018June 17, 2019

Let me make it short first. If you can tell the difference between the following two RMAN statements, then you have already know the difference.… Read More »

How to Compress RMAN Backupset

by Ed Chen
March 17, 2018November 26, 2018

You can enable the compression feature of RMAN by the following 2 ways: One time setting RMAN> show all; RMAN configuration parameters for database with… Read More »

How to Resolve ORA-19505 and ORA-27037 in Error Stack

by Ed Chen
March 11, 2017May 9, 2019
2 Comments

ORA-19505 with ORA-27037 When I tried to duplicate a target database to an auxiliary one by this run block. RUN { ALLOCATE AUXILIARY CHANNEL… Read More »