Hi,

Chitra,

What platform is your old server and the new server?

A. If they are on the same platform/OS (Unix to Unix and same version)
or (NT to NT) you will not have a problem doing a cold backup.

B. If they are of different platforms/OS, then you'll need to do an
export/import.

C. If you can not afford your DB to be down, then you'll have to make
your DB in archive log so that you can take a hot backup and restore on
the new server.

Regards,


Adediji Solomon
MTNN Communications Limited,
Technical System Support Engineer,
2nd Floor, YelloDrome
Plot 1062 Adeola Hopewell Str.,
Victoria Island,
Lagos.,
[Email address protected]
0803-200-3904
"...God so loved the world that through His son, you may live after
death."


-----Original Message-----
From: Chitra
[mailto:oracledba-ezmlmshield-x97548952.[Email address protected]
Sent: Wednesday, August 30, 2006 12:32 PM
To: LazyDBA Discussion
Subject: Oracle full database dump




Have a doubt, I have a situation where want change my database server
to
new one, I.e. from server A to Server B, I will doing fresh (oracle
server)
installation on server B and then I will import my old database to
Server
B, What precaution should I take while doing so???


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


http://www.mtnonline.com/contact/disclaimer.asp

Oracle LazyDBA home page