RE: How can I automate creating a controlfile?

From: Jorgensen, Finn <>
Date: Thu, 29 Nov 2012 12:21:02 -0500
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF0359446C8FD7_at_EXM-OMF-04.Ceg.Corp.Net>

I don't see how that resolves the issue of renaming the database and turning off archive log mode that the OP asked for.

Sandy, I think you're going to need to write some kornshell or perl scripts for this. Start by using "alter database backup controlfile to trace". Then script finding the trace file and cutting and pasting the lines you need in this file. That will involve some grep, head, tail, awk and sed etc.


-----Original Message-----
From: [] On Behalf Of pier paolo Bruno Sent: Thursday, November 29, 2012 8:27 AM To:
Subject: Fwd: How can I automate creating a controlfile?

  • Forwarded message ---------- From: pier paolo Bruno <> Date: 2012/11/29 Subject: Re: How can I automate creating a controlfile? To:

alter database backup controlfile to '/u0xxxxx' reuse ; In your init parameter of the cloned database set control_file parameters to the backuped controlfile

2012/11/28 Sandra Becker <>

> SLES11
> Oracle
> We have a project to refresh snapshot databases on a varying schedule.
> These snapshots all will be development, test, QA, and UAT. The
> snapshots will be done at the hardware level (IBM XIV storage). The
> snapshots will be of a second standby database. When all is said and
> done, the new or refreshed databases will be using the datafiles from
> that secondary standby. For writes it will use a copy-on-write
> technology. The theory behind all this is that all these snapshot
> databases will have a full copy of production data to work with
> without having to actually restore/copy the data and buy more storage.
> The XIV snapshot process sets up symbolic links to the datafiles so that each database references "its own" files.
> My problem centers around the controlfiles for the snapshot databases.
> I have not been able to find a way to open the new database without
> creating a new controlfile manually. they want the entire refresh
> process automated so all they have to do is click a single button.
> Manually creating the controlfile in the middle of the entire process
> doesn't lend itself to complete automation.
> Has anyone ever set up auto create of a control complete with renaming
> the database, turning off archiving, etc.? I have tried everything I
> could think of, but keeping hitting one error or another.
> --
> Sandy
> Transzap, Inc.
> --


>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. -IP1
Received on Thu Nov 29 2012 - 18:21:02 CET

Original text of this message