not sure if this helps, but i place this in a script that runs daily.
As you can see its, instance specific.
alter database backup controlfile to trace as
'/apps/home/oracle/bobmc/db_build/$ORACLE_SID.ctl';
On 02/16/2018 03:53 PM, Andrew Kerber wrote:
I have a need to generate the create controlfile command used in the backup controlfile to trace commands. But I would like to generate a script I can use without further editing. I have access to the original database, and know exactly what changes I need to make to the new controlfile.
I can write something in 3 or 4 hours, but thought I would ask here first to see if anyone has a shell or sql script to generate the create controlfile commands. I have run into an occasional problem with rman cloning, and according to Oracle the fix is to re-create the controlfile. I would like to automate this process.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'