Home » RDBMS Server » Backup & Recovery » New Database Creation in another Host
New Database Creation in another Host [message #249544] Thu, 05 July 2007 00:00 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I have a database in host 'Arju'. I want to take this database to another machine and after replacing database new machine will hold the same IP and name as of 'Arju'. How I will do this??
1. Data import/Export?

2. RMAN Duplicate?
3. Any new feature?

After copying databse to new machine changing IP address/name create problem or not?
Re: New Database Creation in another Host [message #249545 is a reply to message #249544] Thu, 05 July 2007 00:03 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
execute your backup & recovery procedure.
Re: New Database Creation in another Host [message #249569 is a reply to message #249544] Thu, 05 July 2007 01:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

you can maintain same DBID, DBNAME there is no problem
but can you please tell us what is IP which IP you talking here ?


regards
Taj

[Updated on: Thu, 05 July 2007 01:21]

Report message to a moderator

Re: New Database Creation in another Host [message #249575 is a reply to message #249544] Thu, 05 July 2007 01:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

IP address of the machine.
Re: New Database Creation in another Host [message #249750 is a reply to message #249575] Thu, 05 July 2007 14:40 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
IP address of the machine.


Whats this for Db?
you cant use same ip for different machine on same network...I GUESS

Quote:
I have a database in host 'Arju'. I want to take this database to another machine and after replacing database new machine


1:>>DBCA template
2:>>RMAN backup
3:>>RMAN DUPLICATE COMMAND
4>>COLD BACKUP
5:>>IMPORT EXPORT
6:>>IDK

Re: New Database Creation in another Host [message #250107 is a reply to message #249544] Sat, 07 July 2007 23:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Dream, Do u want to mention that 1 is preferable than 2, 2 is better than 3 and so on..
Re: New Database Creation in another Host [message #250160 is a reply to message #250107] Sun, 08 July 2007 20:37 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Every case depends on the situation for example if you are moving from single node to RAC enviroment DBCA template is the best option.
Previous Topic: recover my datafile
Next Topic: Table Recovery with RMAN.
Goto Forum:
  


Current Time: Wed Dec 07 10:28:31 CST 2016

Total time taken to generate the page: 0.15604 seconds