Re: OH YEAH - switching raw device to fs

On Wed, 15 Sep 2004 14:01:34 +0200, Igor wrote:

> Hello,
> anyone has an idea, whether I can switch datafiles of Oracle (8.0.6)
> from file system to raw device (raw logical volume in AIX, e.g.)?
> Any documentation?
>
> Thanks a lot and best regards,
> Igor

DEAR SIRS,
oh, yes, BUT ...

:-))

[FIRST STEP]
All right. I have no database on file system. But I have a db on raw device, about 30G (that makes about an hour to restore).
So, FIRST STEP is to switch raw device to file system, do you agree?

I have restored the database, originally on raw device, onto file system files. I have created the control file from the SQL script. I have completed RECOVER database. I have opened resetlogs the db.

NOTE: Logical volume has a Logical volume control block. In AIX this is 4K. So, when dd-ing the backup source to the file system file you have to skip first 4096 bytes.

Everything is fine and running.

[SECOND STEP]
Now I have an database on file system, right? So, what I will do, tomorrow (I hear your yawns, sorry, but my kids are waiting), is, to back up the open fs database to raw device via dd. Just a few lines of commands, isn't it ...

Of course, now I have to understand how to let dd skip first 4096 in output, so that dd does not overwrite the LVCB. But this is for tomorrow.

Thank you ever so much for your contributes, directly to the issue and for all your other comments. It was very nice and refreshing talking to you.

Have a very nice evening and check for further development tomorrow (latest monday).

Best regards, Igor Received on Thu Sep 16 2004 - 10:20:38 CDT