Re: Moving an Oracle database

Hi Darryl,
How Big is your Database ? If it is in the order of Few GB or lesser , Go for Export/Imports ( with or without Compression ..By the By what is the OS ? ) .

1.Create a New Database on the 2nd Test Server
2.Precreate the necessary Tablespaces,Users,Rollback Segments etc
3.Do the Export dump of the Schemas from U'r 1st Test Server.
4. Transfer the Export file to the 2nd Server in Binary mode via FTP.
5.Import using fromuser , touser options with destroy=y

That's it...

The 2nd option is to do a Cold Backup of the 1st DB(including the Control files,Redolog files,Parameter files etc) , Copy it over exactly to the Same Directory locations on the 2nd Server and Startup...(Ofcourse the Kernel & Memory has to be pretuned to host the Oracle Server)

-Thiru

Darryl Brown wrote:

> Hello All,
>
> I hope this is not the wrong group to ask this question of.
>
> I am looking for a way to move my Oracle 8 database from one test server to
> my other test server and I have been trying to use Enterprise Manager to
> move the data base without success.
>
> Does any one have an Idea on how to do this, I have also been looking
> through several books and I have no been able to find any information on
> this.
>
> I will try support but the wait time with them is usually unreasonable.
>
> Thanks for the help.
> Darryl
> brown_at_lunartech.com
Received on Wed Aug 04 1999 - 15:01:10 CDT