Home » Infrastructure » Unix » Duplicate or move an instance Oracle with new name from a host HP-UX to another host HP-UX
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 Go to next message
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,
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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
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 Go to previous message
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;
Previous Topic: for loop to cp file
Next Topic: Oracle 10g in HP UX 11.
Goto Forum:
  


Current Time: Fri Mar 29 07:12:59 CDT 2024