How to restore RAW database in file system

[Robin_45]

Hi All

My current scenario is two hp 9000 server(rp 7420) under RAC and 350 GB RAW disk is shared by this two sever, now we take backup this 350 GB with Legato. Now we like to restore the RAW space to another server in file system. Is it possible ? if it is possible can any one tell us what is the procedure.

Thanks and Regards
Robin

[Bill Hassell]

A raw volume is just that: no files, nothing but random data that only makes sense to Oracle. Legato has the ability to restore a raw volume on any machine but it would be meaningless in a 'filesystem'. If you want to convert from raw volumes in Oracle to filesystems, you'll have to perform a database export, then redo the Oracle config files for the new data layout and import the data on the new system.

[Yogeeraj_1]

hi robin,

i am not an expert in this field. One workaround would be to use RMAN for backup and
forget about raw or cooked file systems.

recovery is much easier in this case.

kind regards
yogeeraj

[Robin_45]

Hi Bill Hassell

Thanks for your replay if we have to export and redo the oracle file than what is the use of Legato however if we want to restore in another server in RAW space(same in 350 GB) can you tell me the procedure. I mean do we have to create ALL logical volume (same name) under the VG. Then restore through Legato.

Thanks and Regards
Robin

[A. Clay Stephenson]

You will first need to create new raw volumes on the target server and make sure that each raw volumes is at least as large as its original counterpart. It will make things significantly easier for you if you name the new LVOL's exactly as the originals.

You have now discovered the downside of raw volumes. The only UNIX tool to restore them is dd --- not an acceptable backup solution for a production environment. Data Protector, Netbackup, and Legato do support raw volume restores but probably the least evil approach for you is RMAN.

[JJ_4]

What about using symbolic links to start with?

Then on the target, you can just create the symbolic links to point to whereever.