Re: create controlfile command generation

From: Bob-W1TI <>
Date: Fri, 16 Feb 2018 16:01:32 -0500
Message-ID: <>

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

Received on Fri Feb 16 2018 - 22:01:32 CET

Original text of this message