RE: How can I automate creating a controlfile?
- From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
- To: "pbrunoster@xxxxxxxxx" <pbrunoster@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Nov 2012 12:21:02 -0500
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.
Thanks,
Finn
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of pier paolo Bruno
Sent: Thursday, November 29, 2012 8:27 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Fwd: How can I automate creating a controlfile?
---------- Forwarded message ----------
From: pier paolo Bruno <pbrunoster@xxxxxxxxx>
Date: 2012/11/29
Subject: Re: How can I automate creating a controlfile?
To: sbecker6925@xxxxxxxxx
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 <sbecker6925@xxxxxxxxx>
> SLES11
> Oracle 11.2.0.2.0
> 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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
>>> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
