create controlfile command generation
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 16 Feb 2018 14:53:45 -0600
Message-ID: <CAJvnOJbJpxyZU+w2CfMTTM03_d3gDh_qfHidahwC=Hd_CDMLbw_at_mail.gmail.com>
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.
Date: Fri, 16 Feb 2018 14:53:45 -0600
Message-ID: <CAJvnOJbJpxyZU+w2CfMTTM03_d3gDh_qfHidahwC=Hd_CDMLbw_at_mail.gmail.com>
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 Received on Fri Feb 16 2018 - 21:53:45 CET