I have a 12c RAC ASM AIX database that i use RMAN to backup to TSM (IBM Tivoli Storage Manager). I am trying to restore this ASM database to a file system (non-ASM) host without having to use set newname to list all the individual files using . I thought that by setting the following init.ora parameters along with the RMAN restore run block shown below would do the trick but keep failing :-
init.ora:-
======
*.db_file_name_convert='+DATA01/ONLINEDB/DATAFILE/','/onldata/onlinedb/'
*.db_create_online_log_dest_1='/onldata/onlinedb/'
RMAN restore block:-
=============
RMAN> RUN
2> {
3>
4> allocate channel 'tdpo_dev0' type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_online_rp.opt)';
5> allocate channel 'tdpo_dev1' type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_online_rp.opt)';
6> allocate channel 'tdpo_dev2' type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_online_rp.opt)';
7>
8> set until time "to_date('04-05-2016 01:35:26','DD-MM-YYYY HH24:MI:SS')";
9> RESTORE CONTROLFILE;
10> alter database mount;
11>
12> RESTORE DATABASE;
13> RECOVER DATABASE;
14> ALTER DATABASE OPEN RESETLOGS;
15> release channel tdpo_dev0;
16> release channel tdpo_dev1;
17> release channel tdpo_dev2;
18> }
19>
Please assist is indicating how to achieve this restore without having to use set newname ... reference in the run block as every time the list of data files increase i would also have the update the restore script:-