Oracle Database 19c Restore From ASM to Disk (File System)

[@pablorubino3871]

Hi, good video but, what about CDB and PDB databases with set new name for datafiles?????

[@DB2_Oracle]

I will cover these soon

[@waheedurrehman8441]

Very good. Can we restore from ASM RAC database installed on Linux OS to a file system database installed on Windows OS?

[@DB2_Oracle]

Good Question. Never did that. Not sure if its possible. I can give a try and confirm. Is it urgent?

[@waheedurrehman8441]

@@DB2_Oracle Mission accomplished. I did it with the help of a friend.
Below Script that i have used and it worked for me.
Rman>shut immediate;
Rman>startup nomount;
Rman>Restore standby controlfile from 'E:
man\Cont_BMARAC.ctl';
Rman>alter database mount;
CATALOG START WITH 'E:
man\';
SQLPLUS>alter system set db_file_name_convert='+DATA/bmarac/datafile/','E:\app\Administrato\oradata\BMARAC','+DATA/bmarac/tempfile/','E:\app\Administrator\oradata\BMARAC' scope=spfile;
Rman>shutdown immediate;
Rman>startup nomount;
Rman>alter database mount;
run {
SET NEWNAME FOR DATABASE TO 'E:\app\Administrator\oradata\BMARAC\%U';
restore database;
switch datafile all;
switch tempfile all;
};
rman>restore archivelog all;
rman>recover database;
Cheers mate. 😃

[@waheedurrehman8441]

Now i have to make this as a physical data guard server of primary RAC database server.

[@DB2_Oracle]

@@waheedurrehman8441 thanks and very nice