Home » RDBMS Server » Backup & Recovery » database Move and rename (Linux, 11G)
database Move and rename [message #421810] Thu, 10 September 2009 14:04 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All,

We got a database of around 100GB size which we like to move to another server.Also we want to put the database in new server with a new name. My consideration is to create a template of the database using DBCA and then move the template to new server with oracle 11G installed and invoke dbca to select the template. Change the database name during installation.

what are the other ways to accomplish this fast? I can think of RMAN or running the datapump job for taking export of the full database. Any help would be highly appreciated.

Thanks.
Re: database Move and rename [message #421813 is a reply to message #421810] Thu, 10 September 2009 14:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58834
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for RMAN DUPLICATE in documentation.

Regards
Michel
Re: database Move and rename [message #421830 is a reply to message #421810] Thu, 10 September 2009 23:06 Go to previous message
Michel Cadot
Messages: 58834
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.dba-village.com/dba/village/dvp_forum.OpenThread?ThreadIdA=37741&SkipA=0

Please feedback to the answerr we give you.

Regards
Michel
Previous Topic: RMAN recovery to a different node using Networker
Next Topic: Partial schema replication without DBA privs
Goto Forum:
  


Current Time: Wed Aug 20 04:42:41 CDT 2014

Total time taken to generate the page: 0.23003 seconds