ASM DB instance Restoration to Non-ASM DB instance

REM: Prepared by Hayat Mohammad Khan
REM: hayathk@hotmail.com
REM: Dated: 02-July-2013
REM: For Non-RAC Database
REM: Assume ORCL is DB name
REM: Run with your own risk


Step#1

Restore SPFILE
Create Password File or Just copy from Source system if there....

In SPFILE modify the path of Control File
control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl'

Step#2

SQL> startup nomount;

Step#3

In RMAN Session:

rman>set dbid=numericnumberofyourdb
rman>restore controlfile from '/u01/app/oracle/backup/mycontrolfilebackupname_xxxxxxx';

Step#4
alter database mount;


Step#5
Catalog to new backup path where backup files restored from tape/disk

RMAN> catalog start with '/u01/app/oracle/backup/';


Step#6
Restore Backup

RMAN> run {
SET NEWNAME FOR DATABASE   TO  '/u01/app/oracle/oradata/orcl/%b';
SET NEWNAME FOR tempfile  1 TO  '/u01/app/oracle/oradata/orcl/%b';
restore database;
switch datafile all;
switch tempfile all;
}


Step#7
Complete the recovery

run {
--set until sequence 145 thread 1;   //depdends on your archive files
recover database;
}


Step#8

RMAN> sql 'alter database open resetlogs';


Step#9

Verify your data and logfiles

SQL> select member from v$logfile;



CREDIT TO: http://gavinsoorma.com/2013/02/restoring-a-asm-backup-to-non-asm-and-restoring-from-rac-to-single-instance/
Dated: 31st March 2015

Copy ASM Backup to FILE system directory

ASMCMD> cp nnndf0_tag20130218t093350_0.345.807701631 /u02/app/backup

Check if naming conversion requires
*.db_file_name_convert='+DATA/orcl/onlinelog/','/u01/app/oracle/oradata/orcl/'