How to exploit the parameters in the file sql with RMAN
on oracle 11g
To call rman with a file sql and variables in parameters
Example
RMAN TARGET / NOCATALOG cmdfile='File__for_Rman_.sql %DBID% %SID% %Name_InitOra%
Question
How to exploit the parameters in the file sql
ExAmple
SET DBID (DBID ?);
restore spfile to PFILE 'D:\ORACLE\admin\(SID ? )\pfile\( Name_InitOra ?)' from 'D:\oracle\flash_recovery_area\(SID ?)\AUTOBACKUP\ ';
shutdown immediate;
thank you