OraFAQ Forum: Unix » Duplicate or move an instance Oracle with new name from a host HP-UX to another host HP-UX

Home » Infrastructure » Unix » Duplicate or move an instance Oracle with new name from a host HP-UX to another host HP-UX

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

Duplicate or move an instance Oracle with new name from a host HP-UX to another host HP-UX [message #194428]

Fri, 22 September 2006 03:16

sterictra
Messages: 2
Registered: September 2006

Junior Member

Hi,

Today I have an instance Oracle 9i on HP-UX 11i.
I want to move my instance Oracle 9i to another host without use DBCA.
I copy files .dbf and I run command "alter database backup controlfile to trace;" on the 1st host.
With DBCA, I extract too a template with structure only.

I modify the template file (file .dbt) for use on the 2nd host with another name of the instance Oracle.
I succeed to make structure but I want to copy databases.
I try to copy files .dbf from host1 to host2.
I execute on host2 :
"CREATE CONTROLFILE REUSE DATABASE "<new_name>" NORESETLOGS NOARCHIVELOG ...."
but I have these errors : ORA-01503, ORA-01159, ORA-01110.

(Before I try to use DBCA but an error raise at step JARring datafiles, perhaps the datafile'size is more than 2GB ?)

I read some answers on some forums but, I don't succeed.
Best regards,

Report message to a moderator

Re: Duplicate or move an instance Oracle with new name from a host HP-UX to another host HP-UX [message #194483 is a reply to message #194428]

Fri, 22 September 2006 06:25

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

Senior Member
Account Moderator

You no need DBCA for this.
Search the forum for Cold Copy CLone.
There are many many examples.
One such is here
http://www.orafaq.com/howto/clone-db.txt

Report message to a moderator

Re: Duplicate or move an instance Oracle with new name from a host HP-UX to another host HP-UX [message #195141 is a reply to message #194483]

Wed, 27 September 2006 03:06

sterictra
Messages: 2
Registered: September 2006

Junior Member

Thanks to Mahesh Rajendran for this procedure.

Just correct at step 11 :
SQL> ALTER DATABASE RENAME GLOBAL_NAME = new_db_name;
by
SQL> ALTER DATABASE RENAME GLOBAL_NAME TO new_db_name.new_host_name;

Report message to a moderator

Previous Topic:	for loop to cp file
Next Topic:	Oracle 10g in HP UX 11.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 06 14:37:21 CST 2025