Re: DB shift

You can copy 8170 files to a new server via hot backup, create a new control file, open resetlogs and then upgrade to 8174.

Try it first on a test server.

I've done this from 8.0.4 -> 8.1.7.4 with no problems.

Jared

On Monday 21 July 2003 07:44, Goulet, Dick wrote:
> No, See the 8.1.7.4 patch set documentation and do it with a COLD database
> on the source side.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Sunday, July 20, 2003 12:50 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All
>
> We are planning to Shift our Db to a new hardware(having RAIDs).
> The OS is exactly same on both the servers.
> Presently Oracle Version is 8.1.7.0.0
> In the new server Oracle 8.1.7.4 is installed.
>
> What I am planning is to Shift the DB by copying the data files
> from old to new server.
> Renaming them in mount stage if required.
>
> For the Oracle version change (upgrade) will there be any
> problem?
> So that export/import will be the only option.
>
> Thanks for your valuable input.
>
> Regards
>
>
> ___________________________________________________
> Download the hottest & happening ringtones here!
> OR SMS: Top tone to 7333
> Click here now:
> http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
Received on Mon Jul 21 2003 - 10:20:08 CDT