RE: Creating a controlfile - language needed?
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <makbo@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Oct 2005 11:28:12 -0400
Your going to need the online redo logs one way or the other. But if
the database is cleanly shutdown then you don't need to recover that
database after building the new control file. The key is how the
database gets shutdown. A shutdown immediate or normal does not require
instance recovery. A shutdown abort does. And building a new control
file of a hot backup copy of the database will require recovery period.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark Bole
Sent: Tuesday, October 04, 2005 11:23 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Creating a controlfile - language needed?
Goulet, Dick wrote:
> Depends. Was the database shutdown cleanly before you rebuilt the
> control file? If not then you need it.
Not exactly. If instance recovery is required, it is the online redo
log files that you will need, not the original control file.
>
> I am copying a database to a new server and all of the 200+ files will
> have
> a new directory structure (but will keep the same SID) so that is why
I
> am
> creating a new controlfile.
>
Why create a new controlfile and open resetlogs when you don't need to?
Shutdown the database, copy all the files to the new locations,
startup nomount, then use a series of ALTER DATABASE RENAME FILE
commands to update the location of datafiles and online log files. Then
create/drop tempfiles as appropriate. You still have to do the same
amount of text file editing in either case.
In fact, you might even get away with simply using DB_FILE_NAME_CONVERT
and LOG_FILE_NAME_CONVERT parameters.
--
Mark Bole
http://www.bincomputing.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
