Urgent database transferring

[Beejay]

Hello guys
I need an urgent help if you guys can help me.

I am shifting my database to another system so what is the best way of shifting either export/import or backup and recovery of full database one more thing i have 2 database in old system

reagrds
BJ

[rohitsn]

Hi,
The best method is to shutdown the primary database and backup all the datafiles,controlfiles,logfiles and parameter file and shift it into another machine and then recover the database.In this method there is no need to recover the database as the consistent backup will be able to have a consistent database on the other machine.
Export /import utility also will work but the other database will not be consistent as the primary database as the changes made after export willhave to be manuaaly transferred to the other system.

In case of any help plase be free to ask me at rohitsn@altavista.com

REgards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[Beejay]

Thanks for the help . I will try to do the same and get back

regards
BJ

[marist89]

That method is fine, if in fact you are using the same platform. Otherwise, export/import is your only option.