Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

clonning oracle 9.2 database on HP-UX

GNOM
Frequent Advisor

clonning oracle 9.2 database on HP-UX

hi all,
Could someone give the full procedure to clone an oracle 9.2.0.5 database an other HP-UX server from a cold backup ?

Thanks
4 REPLIES
Steven E. Protter
Exalted Contributor

Re: clonning oracle 9.2 database on HP-UX

http://www.dba-oracle.com/oracle_tips_db_copy.htm

HP-UX to HP-UX is pretty simple.

You copy the files, change the init.ora, add an entry in /etc/orabab and do a few conversion steps.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Volker Borowski
Honored Contributor

Re: clonning oracle 9.2 database on HP-UX

Hi,

@SEP: this is a nice and very complete description (Link bookmarked:-) !

The procedure is very good, but is not a valid one, if cou want to use RMAN backup of both (source and target DB) with the same Catalog-DB. Both DBs will have the same DB-ID. If you like to use RMAN in this context, you need to re-incarnate the DB with RMAN and the target will get a new DB-ID then.

Do not know if this is important for you.
Volker
Bart Paulusse
Respected Contributor

Re: clonning oracle 9.2 database on HP-UX

If you're going to rename your database it's smart to perform a few times:
"alter system switch logfile"
before copying the datafiles.

This will save you a lot of recovery trouble.

Only thing I miss in the link SEP gave.

Jean-Luc Oudart
Honored Contributor

Re: clonning oracle 9.2 database on HP-UX

Hi

Please check Metalink note id 18070.1
How to Make a Copy of a Database on the Same Unix Machine

and also have a look at this thread :
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=747819

The advantage of cloning onto a different server is that you do not have to shut down the source instance during the cloning operation.

also check link below :
http://www.orafaq.org/howto/clone-db.txt

Regards
Jean-Luc
fiat lux