RE: copying datafile nt4-w2k

2003-03-31 Thread GKor
fullpath>\'; > 7. Now open the database: ALTER DATBASE OPEN; > > > <> Content-Type: message/rfc822; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: Re: copying datafile nt4-w2k --- End Message ---

Re: copying datafile nt4-w2k

2003-03-31 Thread Jared Still
ase: ALTER DATBASE OPEN; > > > <> Content-Type: message/rfc822; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: Re: copying datafile nt4-w2k -- Please s

RE: copying datafile nt4-w2k

2003-03-30 Thread GKor
i saw this document on Metalink, it is possible to copy everything even without creating the controlfiles!! * goal: How to copy an Oracle database to another machine * fact: Oracle Server - Enterprise Edition fix: Pre-requisites: The copy is between 2 machines, both have to be on the

Re: copying datafile nt4-w2k

2003-03-28 Thread Jared Still
Yes, the database is down while doing this. Opening the database and creating a controlfile works, but I really didn't expect recovery on an 8.0 database to work with 8i executables. Jared On Friday 28 March 2003 11:38, Jeffrey Beckstrom wrote: > Presuming this is a cold backup. I recall tryin

Re: copying datafile nt4-w2k

2003-03-28 Thread Jeffrey Beckstrom
Presuming this is a cold backup. I recall trying it about a year or so ago with a hot backup and had a problem with recovery not knowing when to stop - it kept wanting more log files.>>> [EMAIL PROTECTED] 3/28/03 1:43:41 PM >>>Certainly possible.I'm currently copying 8.0 files on NT to Win2k

Re: copying datafile nt4-w2k

2003-03-28 Thread Jared Still
Certainly possible. I'm currently copying 8.0 files on NT to Win2k servers with 8.1.7 installed. Rebuild the controlfile, open the database and upgrade. Works great. Jared On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote: > hi all > > We are planning an upgrade from NT4 to W2K. > I am c

copying datafile nt4-w2k

2003-03-28 Thread GKor
hi all We are planning an upgrade from NT4 to W2K. I am considering to create a new instance on another server with W2K installed and copying the datafiles from the server with NT4 on it. Is this possible ? Or do i have to use the exp/imp strategy ? thanks vr.gr. Geo Kor Sr. System Engineer I&D