DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

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

  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Question

    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.
    thanks,
    Irsh

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    By same do you mean standby database, or do you just want to have copies of the four databases on the new server?

  3. #3
    Join Date
    Jul 2002
    Posts
    8
    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.
    thanks,
    Irsh

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. shutdown immediate all the dbs on the source.
    2. rcp the files from hosta to host b


    man rcp
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    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]

  6. #6
    Join Date
    Jul 2002
    Posts
    8
    Jeff,
    By following above two steps (rcp), don't I need to
    install oracle on host "b"?

    Thanks.
    thanks,
    Irsh

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Depends on your intrepretation of "files". As long as you have all the dbs down anyway, you can copy the $ORACLE_HOME as well.

    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jul 2002
    Posts
    8
    Jeff, after copying $ORACLE_HOME, which system files (on host B) need to modify, in order to start Oracle?

    All your help is appreciated.

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    most likely, only your listener.ora. I would also check your init.ora file, but there shouldn't be anything there that needs changing.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  10. #10
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width