How to make an exact same UNIX with oracle server as an eixisting one?

[irsh]

I have an Unix (Dynix/ptx) server with Oracle sever (4 databses), now I have one more Server with same OS only, I need to make it same as existing Unix server with Oracle and all Database (4 database).

What are the different Strategies to do it?

I'll appreciate a reply.

[stecal]

By same do you mean standby database, or do you just want to have copies of the four databases on the new server?

[irsh]

Yes, you are right, I don't want a standby databse, I just want to have copies of the four databases on the new server.

There is no Oracle installed on new server.

Thanks for reply.

[marist89]

1. shutdown immediate all the dbs on the source.
2. rcp the files from hosta to host b


man rcp

[alapps]

If you can afford the downtime, Jeff's way is best...
If you want to minimize downtime (Only steps 3 & 4)...

1. Create the databases on the new machine as a standby from the last hot backup...

2. Apply all archived redo logs

3. Shutdown immediate on all databases on the "Old" box

4. Transfer the remaining archived redo logs to the "New" box
and apply them...
(Recover standby database until cancel)

5. Activate the standby databases on the "New" box.

This should help minimize downtime...

Jeff... Did I miss anything or can you add something?


[Edited by alapps on 07-22-2002 at 12:22 AM]

[irsh]

Jeff,
By following above two steps (rcp), don't I need to
install oracle on host "b"?

Thanks.

[marist89]

Depends on your intrepretation of "files". As long as you have all the dbs down anyway, you can copy the $ORACLE_HOME as well.

[irsh]

Jeff, after copying $ORACLE_HOME, which system files (on host B) need to modify, in order to start Oracle?

All your help is appreciated.

[marist89]

most likely, only your listener.ora. I would also check your init.ora file, but there shouldn't be anything there that needs changing.

[Orca777]

Hi;
check the ownership of the files copied;
create unux-account oracle with primary group dba
check if there is something else installed for example async io

chown oracle.dba to the files
check if ulimit's are big enough to start oracle (FileSize/ProcessSize )
check if the oracle-shellvars are correctly set.


Orca