r off doing that or doing a "backup controlfile to
> trace"
> from server A, moving the datfiles & logfiles to server B, and then
> editing
> the newly created trace file into a script that creates a new
> controlfile
> with the new datafile/logfile locations?
>
LE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Backup/Recovery questions ...
Fred,
Either method works fine. You have the same amount of data editing in
both
methods (Either issue "alter database rename" commands, or edit the
"create
controlfile" file.
The o
iles to server B, and then editing
the newly created trace file into a script that creates a new controlfile
with the new datafile/logfile locations?
>From: Rachel Carmichael <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL P
Rachel Carmichael <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Backup/Recovery questions ...
>Date: Wed, 23 Jan 2002 11:00:36 -0800
>
>First load all the datafiles and logfiles to ser
First load all the datafiles and logfiles to server B in the locations
you want them. Load the controlfiles as well, they aren't useless.
Now.
edit the init.ora file on server B to point to where the control files
are.
create a sql script file that contains (for every datafile and logfile)
Fred,
one of the easier ways is this:
1. on ur prod take a control file backup to trace
2. copy the trace to server b and edit the path/drives
3. copy init file from prod to server b
4. set the env vars in server b and startup nomount
5. create the control file using edited trace on B
6. restor
