RAC

How to Restore 12c RAC Database by a Backup Set

Posted on
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. Now we can start to restore 12c cluster database. Our goal in this post is to use a backup set on one of RAC nodes to restore the database. First […]
RAC

How to Restore 10g RAC Database by a Backup Set

Posted on
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 ASM from a fatal crash, but the database is still waiting for our saving. Luckily, we have a backup set of the database, which is a full and consistent database […]
ASM

How to Resolve SPFILE in DB_UNKNOWN

Posted on
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 in ASM. Is it a bug dedicated to Oracle 10g RAC (Bug 5370663)? No, I saw it too in 12c R1 RAC restoration. Let’s reproduce the problem. First, check what […]
Clusterware

How to Backup Clusterware OCR and Voting Disk

Posted on
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 OCR Data 1. OCR Dumps Oracle provides an utility ocrconfig to export OCR data to a dump file like this: [root@primary01 ~]# . /home/oracle/.bash_profile [root@primary01 ~]# cd /backup/ [root@primary01 backup]# […]
RMAN

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

Posted on
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> backup database tag ‘20190416-before-yearly-import’; Starting backup at 16-APR-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=393 device type=DISK channel ORA_DISK_1: starting full datafile […]
RMAN

How RMAN Restore Database by a Backup Set

Posted on
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 the target server solely by a backup set for testing purpose. The content of the backup set that we copied from the source server to the target server is listed […]
Recycle Bin

How to Restore Dropped Tables from Recycle Bin

Posted on
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 dump files that were exported by expdp (or exp) against your database before. RMAN: You can perform a tablespace point-in-time recovery (TSPITR) in another database and move it back to […]