Home » RDBMS Server » Backup & Recovery » Copy Oracle DB from one server to another (Oracle 10.2.0.4, HP-UX)
Copy Oracle DB from one server to another [message #441539] Mon, 01 February 2010 17:01 Go to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
I need to copy a database from one server (Prod) to another (Test).

Both the servers have same directory structure, same operating system and both same Oracle versions 10.2.0.4.

And ofcourse, the Prod is on Archive Log mode, but i don't want the Test instance on Archive Log Mode.


Whats the best method to do it?

Export and Import?

Hot backup and restore?

Cold Backup and restore?

Please suggest me, and if possible and if you have time, please reply back the steps to copy.


Thanks,
Munna
Re: Copy Oracle DB from one server to another [message #441540 is a reply to message #441539] Mon, 01 February 2010 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>Whats the best method to do it?
Best based upon which metric?

>Export and Import?
Above will work.

>Hot backup and restore?
Above will work.

>Cold Backup and restore?
Above will work.

Do the one you are most capable to achieve success.
Re: Copy Oracle DB from one server to another [message #441541 is a reply to message #441539] Mon, 01 February 2010 17:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
To add,
it depends on volume of data.
Re: Copy Oracle DB from one server to another [message #441542 is a reply to message #441539] Mon, 01 February 2010 17:58 Go to previous messageGo to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
>Best based upon which metric?
Best method based upon NOT affecting any users or any transactions by the users.

The database size is 20GB.
Re: Copy Oracle DB from one server to another [message #441544 is a reply to message #441542] Mon, 01 February 2010 18:08 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>Best method based upon NOT affecting any users or any transactions by the users.
Above eliminates cold backup.

>The database size is 20GB
I'd say the size rules out export/import

Therefore you are left with hot backup & restore.
Re: Copy Oracle DB from one server to another [message #441675 is a reply to message #441539] Tue, 02 February 2010 10:30 Go to previous message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
Thank you guys.

I did a hot backup and restore.

-Munna
Previous Topic: how to take backup and restore database
Next Topic: Simple RMAN question
Goto Forum:
  


Current Time: Tue Dec 06 00:22:15 CST 2016

Total time taken to generate the page: 0.15097 seconds