Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to Oracle 12.2.0.1 Direct upgrade is supported by Oracle. If you have Database lower than those version than you have to upgrade to 11.2.0.4 first and you can upgrade to 12cR2 In our Scenario We will … Continue reading Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

Advertisements

Restore RMAN to new server and refresh with Archivelog apply

Source Database --------------- ::: Directory Structure ::: ORACLE_HOME : E:\oracle\product\10.2.0\db_1 RMAN Backup : E:\rman_backup_full Control Files : E:\oradata\ecc DataFiles: E:\oradata\ECC Archivelog Destination: E:\archivelogs adump : e:\oracle\product\10.2.0\admin\ecc\adump bdump : e:\oracle\product\10.2.0\admin\ecc\bdump cdump : e:\oracle\product\10.2.0\admin\ecc\cdump udump : e:\oracle\product\10.2.0\admin\ecc\udump 1. create pfile='E:\eccprod.ora' from spfile;   2. rman target / backup incremental level 0 TAG 'ECC_DAILY_FULL' database filesperset 4; backup … Continue reading Restore RMAN to new server and refresh with Archivelog apply

Restore Table from RMAN Backup Oracle 12c

  One of the amazing features of Oracle Database 12c is that now you can do a logical restore from a physical backup. Before 12c it was not possible to restore a table from a RMAN backup. This feature is amazing speciall when you have a large database and needs to restore a small table. … Continue reading Restore Table from RMAN Backup Oracle 12c

RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.

We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went missing and there was a gap. After doing the restore we got the below error in the RMAN recovery rman nocatalog target sys/******@mw auxiliary / connected to target database: MW (DBID=000000000) using target database control … Continue reading RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.