clonning oracle 9.2 database on HP-UX

[GNOM]

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

[Steven E. Protter]

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

[Volker Borowski]

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]

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]

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