If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to Clone a 9i Database

I have an Oracle 9.2.0.7 database (Enterprise Edition) I need to copy from one HP-UX server to another one. They have different filesystem names and different database names. I'm trying to find a fast method to do this for our production go live and it seems like if I knew how to clone, that would be my best bet. We do not use RMAN in our company. I would have do perform a cold backup first. Can someone give me the steps please. Thanks in advance.
AMH

The idea is to create a new database in target box as a clone of what you have in source box.

1- Put source database in backup mode
2- DD all source datafiles to target box.
3- Create control file on source database.
4- Take source database out of backup mode
5- Copy created control file and archive logs generated since step #1 from source to target box.
6- Edit control file on target box to match filesystems, etc. Be sure you set the new database name correctly, it should look like...

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

ok. I missed out that.
What is the database size ?
I prefer putting tablespace in backup mode one by one and scp/rcp to target instead of putting whole database in backup mode in one shot even if the feature is available.