Hi all,

At this post, I want to talk about how to restore/recover a RMAN backup that taken from an ASM (on ODA X7-2M) to FILE SYSTEM with different SID, different database files location and different backup location.

My Environments

I. SOURCE SIDE

A. Backup Database

For store backup database you can use default RMAN backup location (+RECO). But I optionally chose creating different ACFS disk volume for backup location.

A.1. Create ACFS Disk Volume

A.2. Create Backup Location

A.3. RMAN Backup

You can use the followig script for RMAN backup.

A.3.a. My RMAN Backup Files

B. Copy initASMDB.ora from asmdb-host to fsdb-host with New Name

C. Copy RMAN Backup Files to fsdb-host

D. Informations that We Need for Restore from Source Database:

D.1. DBID

Save this value. Because we use this value at restore ASM database to FILE SYSTEM database.

D.2. Lists of Data Files and Temporary Files

D.3. Redo Log Files

II. TARGET SIDE

A. Prepare FILE SYSTEM Server for Restore

A.1. Install Oracle Database 12.2.0.1.0 software only

A.2. Create Listener

A.3. Edit .bash_profile File

When you editing .bash_profile, you must set ORACLE_SID=FSDB.

A.4. Create tnsnames.ora File

When you create tnsnames.ora, you must use FSDB specifications.

A.5. Edit initFSDB.ora File

IMPORTANT!

When you editing initFSDB.ora file, you must set only “db_name=ASMDB” and you must set the other parameters with FSDB specifications.

A.5.1. My initFSDB.ora File:

B. Restore Database

B.1. Restore Control Files:

B.2. Create RMAN Catalog

B.3. Restore Database and Rename Files

B.4. Recover Database and Open Resetlogs:

C. Control the New Database

C.1. Log File Names

C.2. DB_NAME, DB_UNIQUE_NAME and DBID

D. Change New Database Specifications

D.1. Change DB_NAME, DB_UNIQUE_NAME and DBID

After this step database will shutdown.

D.2. Change db_name in initFSDB.ora

D.3. Recreate Password File

E. Startup Database

F. Last Control

F.1. DB_NAME, DB_UNIQUE_NAME and DBID

F.2. Control Files

F.3. Data Files

F.4. Log Files

F.5. Temp Files

Everything is perfect.

References:

https://gavinsoorma.com/2013/02/restoring-a-asm-backup-to-non-asm-and-restoring-from-rac-to-single-instance/

http://gablovesoracle.blogspot.com/2012/08/rman-restoration-to-new-server-with.html

http://www.br8dba.com/rman-database-restore-from-asm-to-file-system/

Oracle

ACFSASMFILE SYSTEMODARMAN

1 Comment

  • Thanks for this post. It was really informative , I have been looking for a manual RMAN Recovery from ASM to file system for a long time.
    It is life saver. 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *