OraFAQ Forum: Backup & Recovery » New Database Creation in another Host

Home » RDBMS Server » Backup & Recovery » New Database Creation in another Host

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

New Database Creation in another Host [message #249544]

Thu, 05 July 2007 00:00

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?

Report message to a moderator

Re: New Database Creation in another Host [message #249545 is a reply to message #249544]

Thu, 05 July 2007 00:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

execute your backup & recovery procedure.

Report message to a moderator

Re: New Database Creation in another Host [message #249569 is a reply to message #249544]

Thu, 05 July 2007 01:21

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

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

IP address of the machine.

Report message to a moderator

Re: New Database Creation in another Host [message #249750 is a reply to message #249575]

Thu, 05 July 2007 14:40

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

Report message to a moderator

Re: New Database Creation in another Host [message #250107 is a reply to message #249544]

Sat, 07 July 2007 23:15

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..

Report message to a moderator

Re: New Database Creation in another Host [message #250160 is a reply to message #250107]

Sun, 08 July 2007 20:37

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.

Report message to a moderator

Previous Topic:	recover my datafile
Next Topic:	Table Recovery with RMAN.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 17:49:16 CDT 2024