Re: Backup of database using rawdevices

Hello,

I have configured raw devices for an Oracle database on HP/UX. Created symbolic links in the oradata directory to make the use a bit more transparent. From Oracle referred to the symbolic links. There is indeed some blocks lost for the header in the raw device and the datafile must be 10K smaller than the raw device. From the backup procedure, I use "cp oradata/* backup/.". The symbolic links then become true files (in the backup directory). Finally use HP/UX fbackup. I tested recovery by copying the backup directory back to the oradata directory with "cp backup/* oradata/.". This reestablishes the contents of the raw devices, provided that the symbolic links are still in place in the oradata directory.

I am quite happy with using raw devices but have heard and also read in this forum that there may be a anlternative that has the same performance advantage but is easier to manage. That is the convosync=direct,mincache=direct option from advance VXFS (als called online JFS). Does anyone have any experience with that? I only found that you need an additional license from HP to enable it. The option is however described in the man pages and pre-installed with HP/UX 11i.

Edzard Pasma Received on Wed Aug 21 2002 - 06:25:44 CDT