Restore Db on a diff box

[st2000]

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

[marist89]

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...).

[st2000]

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

[st2000]

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

[marist89]

Originally posted by st2000
Jeff: What is IMHO and soft links..

IMHO = In My Humble Opinion.

man ln for details on soft links

[marist89]

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.

[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

[xyz2000]

STARTUP NOMOUNT
CREATE CONTROLFILE ..... RESETLOGS
.......
.......
;

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

[marist89]

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