topic Re: How to restore RAW database in file system in Operating System - HP-UX

How to restore RAW database in file system

Robin_45 — Tue, 16 Jan 2007 08:04:39 GMT

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

Re: How to restore RAW database in file system

Bill Hassell — Tue, 16 Jan 2007 08:28:30 GMT

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.

Re: How to restore RAW database in file system

Yogeeraj_1 — Tue, 16 Jan 2007 08:42:30 GMT

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

Re: How to restore RAW database in file system

Robin_45 — Tue, 16 Jan 2007 09:19:54 GMT

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

Re: How to restore RAW database in file system

A. Clay Stephenson — Tue, 16 Jan 2007 09:40:37 GMT

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.

Re: How to restore RAW database in file system

JJ_4 — Wed, 17 Jan 2007 06:07:34 GMT

What about using symbolic links to start with?

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