Restore Db on a diff box
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Restore Db on a diff box

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello DBAs:

    We have taken a cold backup of a instance to a tape.
    Now we want to restore the same system to a different unix machine altogether which has different
    filesystems, unlike the 1st one. My Qn is .. How do I restore successfully? or what problems will
    I face? Should I rebuild the controlfiles? Please give me feedback urgently..

    Thanks ST2000

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The easiest way, IMHO, is to create soft links on the new box that mimic your old box. Then, you just take your db off tape, and start it up (assuming oracle has aleady been installed...).
    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."

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    Jeff: What is IMHO and soft links..

    Secondly the boxes don't mimic each other at all..

    They both are from IBM and both have Oracle Instances and thats about it.. I am comfortable with rebuilding a control file. If that is also a good alternative, please give me steps..

    As I said, the filesystems are totally different and the for eg., if i have a "users" tablespace's dfiles in /u10, /u12 and /u13 in old system where it was shut down and backed up, the new system (to be restored) has totally diff.. Filesystems.. Sizes and naming of Filesystems could vary..

    Thanks, ST2000

  4. #4
    Join Date
    Oct 2000
    Posts
    449
    Also Please advise on init.ora file, how I should change the controlfile line in it..

    Secondly OS is AIX 4.3.3
    and Oracle version is 8.1.7.1

    oracle@cg_jda3:/home/oracle_> df -k
    Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
    /dev/hd4 131072 61312 54% 1460 3% /
    /dev/hd2 1015808 337824 67% 26145 11% /usr
    /dev/hd9var 32768 27308 17% 501 7% /var
    /dev/hd3 131072 103576 21% 127 1% /tmp
    /dev/hd1 65536 47704 28% 166 2% /home
    /dev/lvoracle 3276800 1167040 65% 41276 6% /home/oracle
    /dev/lvuniface 1048576 843512 20% 1340 1% /home/uniface
    /dev/lvu03dbs 6291456 1459264 77% 42 1% /u03/dbs
    /dev/lvu02dbs 4194304 2051968 52% 60 1% /u02/dbs
    /dev/lvu04dbs 8388608 1449716 83% 50 1% /u04/dbs
    /dev/lvu05dbs 15466496 4056912 74% 53 1% /u05/dbs
    /dev/lvideas 327680 268360 19% 231 1% /home/ideas
    /dev/lvodbms 360448 264204 27% 3010 4% /home/odbms
    /dev/lvu06dbs 8388608 2911576 66% 42 1% /u06/dbs
    /dev/lvwcc 327680 209172 37% 1653 3% /home/wcc
    /dev/lvwccdev1 163840 127436 23% 1041 3% /home/wccdev1
    /dev/arthurlv 1048576 302796 72% 825 1% /home/arthur
    /dev/lvu07dbs 4194304 1308436 69% 31 1% /u07/dbs
    /dev/lvu08dbs 8388608 3925848 54% 21 1% /u08/dbs
    /dev/lvu09dbs 16777216 1106100 94% 26 1% /u09/dbs


    oracle@cg_jda2:/home/oracle_> df -k
    Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
    /dev/hd4 32768 13048 61% 1553 10% /
    /dev/hd2 2097152 682688 68% 44045 9% /usr
    /dev/hd9var 131072 45856 66% 845 3% /var
    /dev/hd3 131072 112832 14% 1715 6% /tmp
    /dev/hd1 622592 58128 91% 7820 6% /home
    /dev/lvoracle 3276800 672296 80% 45521 6% /home/oracle
    /dev/lvuniface 1048576 843044 20% 1343 1% /home/uniface
    /dev/lvu02dbs 1966080 382220 81% 64 1% /u02/dbs
    /dev/lvu03dbs 6291456 257896 96% 47 1% /u03/dbs
    /dev/lvu04dbs 13500416 38460 100% 56 1% /u04/dbs
    /dev/lvu05dbs 21757952 2065744 91% 61 1% /u05/dbs
    /dev/lvu06dbs 12451840 4327316 66% 49 1% /u06/dbs
    /dev/arthurlv 6291456 5592784 12% 654 1% /arthur
    /dev/dataloadlv 5111808 258560 95% 3545 1% /dataload
    /dev/ridevlv 4063232 3886552 5% 223 1% /RIDEV
    /dev/lvideas 4194304 1655200 61% 324 1% /home/ideas


    Any more info needed.. I shall send them rightaway..

    Thanks, ST2000




  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by st2000
    Jeff: What is IMHO and soft links..
    IMHO = In My Humble Opinion.

    man ln for details on soft links
    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."

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by st2000

    As I said, the filesystems are totally different and the for eg., if i have a "users" tablespace's dfiles in /u10, /u12 and /u13 in old system where it was shut down and backed up, the new system (to be restored) has totally diff.. Filesystems.. Sizes and naming of Filesystems could vary..
    Create a link named /u13 that points to some other filesystem, say /u06:
    ln -s /u06 /u13

    Then, you will have /u13/dbs/...

    This way, you won't have to futz around with the control file to get your database up. Once it's up, you can move your files and rename them with or without messing with the control file.
    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."

  7. #7
    Join Date
    Oct 2000
    Posts
    449
    Thanks Jeff.. Great idea.. Creating softlinks to bring up the system.. I think till mount stage right..

    Can u please explain in steps.. (just taking 1 df as example).

    Thanks ST 2000

  8. #8
    Join Date
    Jan 2001
    Posts
    191
    STARTUP NOMOUNT
    CREATE CONTROLFILE ..... RESETLOGS
    .......
    .......
    ;

    RECOVER DATABASE using backup controlfile until cancel;
    ALTER DATABASE OPEN resetlogs;

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by st2000
    Thanks Jeff.. Great idea.. Creating softlinks to bring up the system.. I think till mount stage right..

    Can u please explain in steps.. (just taking 1 df as example).

    Thanks ST 2000
    No, it was shutdown cleanly.

    svrmgrl
    connect internal
    startup
    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."

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