Transfer a complete database (8i)

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 3 Dec 2002 13:09:49 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702FF2F8F@lnewton.leeds.lfs.co.uk>

Which will work only if the old and new servers are the same OS, os version (maybe), manufacturer, and hardware 'endian-ness' - otherwise Oracle won't let you start up the database. There is an FAQ answer over at the Co-operative Oracle FAQ on thisd subject - try http://www.jlcom.demon.co.uk, and follow the links from there to the FAQ. HTH Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: rnilanjan_at_hotmail.com (Nilanjan Ray) [mailto:rnilanjan_at_hotmail.com]
Posted At: Tuesday, December 03, 2002 10:07 AM Posted To: server
Conversation: Transfer a complete database (8i) Subject: Re: Transfer a complete database (8i)

Hi,

Try this simple method.
1. Create identical directory structure for Oracle database as in your source server.
2. Cleanly shutdown your source database. 3. Transfer all your datafiles,controlfiles,redo log files,initiallization parameter files to the identical new location. 4. startup your new database Received on Tue Dec 03 2002 - 07:09:49 CST