OraFAQ Forum: Backup & Recovery » Copy Oracle DB from one server to another

Home » RDBMS Server » Backup & Recovery » Copy Oracle DB from one server to another (Oracle 10.2.0.4, HP-UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copy Oracle DB from one server to another [message #441539]

Mon, 01 February 2010 17:01

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

Report message to a moderator

Re: Copy Oracle DB from one server to another [message #441540 is a reply to message #441539]

Mon, 01 February 2010 17:04

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Copy Oracle DB from one server to another [message #441541 is a reply to message #441539]

Mon, 01 February 2010 17:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

To add,
it depends on volume of data.

Report message to a moderator

Re: Copy Oracle DB from one server to another [message #441542 is a reply to message #441539]

Mon, 01 February 2010 17:58

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.

Report message to a moderator

Re: Copy Oracle DB from one server to another [message #441544 is a reply to message #441542]

Mon, 01 February 2010 18:08

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Copy Oracle DB from one server to another [message #441675 is a reply to message #441539]

Tue, 02 February 2010 10:30

Ricky_1362002
Messages: 111
Registered: February 2009

Senior Member

Thank you guys.

I did a hot backup and restore.

-Munna

Report message to a moderator

Previous Topic:	how to take backup and restore database
Next Topic:	Simple RMAN question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:38:42 CDT 2024