Re: create controlfile command generation

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.'

--
http://www.freelists.org/webpage/oracle-l