Home » RDBMS Server » Server Administration » Best way to duplicate a database / schema ? NOT urgent, never was, never will be.
Best way to duplicate a database / schema ? NOT urgent, never was, never will be. [message #248747] Sun, 01 July 2007 09:54 Go to next message
orafaqforum
Messages: 4
Registered: July 2007
Junior Member
Hi,

I'm new to Oracle. What's the best way to duplicate a database to another machine ? Isn't it better to just backup and restore rather than use import/export ? Is RMan usefull in this case.

Is duplicating a schema the same than duplicating a database ?

Thanks.

[mod-edit] removed arrogant selfish "urgent" directive from message title.

[Updated on: Mon, 02 July 2007 08:20] by Moderator

Report message to a moderator

Re: [Urgent please] Best way to duplicate a database / schema ? [message #248752 is a reply to message #248747] Sun, 01 July 2007 11:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What's the best way to duplicate a database to another machine ?

Same OS or not? Same version or not? Which version(s)?

Quote:
Is duplicating a schema the same than duplicating a database ?

A database contains multiple schemas.

Regards
Michel

Report message to a moderator

Re: [Urgent please] Best way to duplicate a database / schema ? [message #248772 is a reply to message #248752] Sun, 01 July 2007 19:19 Go to previous messageGo to next message
orafaqforum
Messages: 4
Registered: July 2007
Junior Member
yes same os, same oracle version. In fact everything must be the same because that's the purpose.

[Updated on: Sun, 01 July 2007 19:20]

Report message to a moderator

Re: [Urgent please] Best way to duplicate a database / schema ? [message #248773 is a reply to message #248772] Sun, 01 July 2007 19:46 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
GO with RMAN duplicat database command..

Report message to a moderator

Re: [Urgent please] Best way to duplicate a database / schema ? [message #248775 is a reply to message #248772] Sun, 01 July 2007 21:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you have the luxury of doing a cold backup of your primary database, then a straight forward method would be to do a cold backup, copy the files to your new server and start the database up on the new server.

Report message to a moderator

Re: Best way to duplicate a database / schema ? NOT urgent, never was, never will be. [message #248980 is a reply to message #248747] Tue, 03 July 2007 00:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Through RMAN Duplicate Database
http://dbataj.blogspot.com/2006/12/duplicating-database-with-recovery.html

Through Cold Backup
http://dbataj.blogspot.com/2007/03/shiftoracleserverfromonemachinetoanothe.html


Regards
Taj

Report message to a moderator

Re: Best way to duplicate a database / schema ? NOT urgent, never was, never will be. [message #250085 is a reply to message #248747] Sat, 07 July 2007 15:29 Go to previous messageGo to next message
orafaqforum
Messages: 4
Registered: July 2007
Junior Member
Thanks everybody, that's very helpfull for me. I'm going to read about RMAN.

Report message to a moderator

Re: Best way to duplicate a database / schema ? NOT urgent, never was, never will be. [message #250090 is a reply to message #250085] Sat, 07 July 2007 16:51 Go to previous messageGo to next message
orafaqforum
Messages: 4
Registered: July 2007
Junior Member
Is it the same answer (Duplicate with RMAN) if I want to clone a schema (and not the whole database) to another machine ?

Thanks.

[Updated on: Sat, 07 July 2007 16:52]

Report message to a moderator

Re: Best way to duplicate a database / schema ? NOT urgent, never was, never will be. [message #250091 is a reply to message #248747] Sat, 07 July 2007 16:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
For just 1 schema I always use export/import, but that is just my preference.

Report message to a moderator

Re: Best way to duplicate a database / schema ? NOT urgent, never was, never will be. [message #250097 is a reply to message #250090] Sat, 07 July 2007 18:58 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
orafaqforum wrote on Sat, 07 July 2007 15:51
Is it the same answer (Duplicate with RMAN) if I want to clone a schema (and not the whole database) to another machine ?

Thanks.




with RMAN you can't clone schema for that you must use IMP/EXP

Report message to a moderator

Previous Topic: Replication 10g release problem [Multi-Master Replication, Advance Replication]
Next Topic: Creating physical Standby database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 23:08:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.