Re: Online backup and raw device

Arne Sodal wrote:
>
> I try to do an online backup of a Oracle 7.3.4.X on RS/6000, F50, AIX
> 4.3.3.
> I do the command "alter database backup controlfile to
> '/u08/dbfiler/backup_controlfile.ctl' which is a small part of a bigger
> script.
>
> My two controlfiles are on raw devices.
>
> The question is: What options of the "dd"-command shall I use to
> complete the restore of the backup controlfiles to the raw device?
> (eg. from filesystem to raw device)
>
> I have tried several of dd options:
> /bin/dd of=/dev/rlvctrl1fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=32
> /bin/dd of=/dev/rlvctrl2fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=32
>
> /bin/dd of=/dev/rlvctrl1fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=512
> /bin/dd of=/dev/rlvctrl2fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=512
>
> /bin/dd of=/dev/rlvctrl1fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=8
> /bin/dd of=/dev/rlvctrl2fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=8
>
> /bin/dd of=/dev/rlvctrl1fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=128
> /bin/dd of=/dev/rlvctrl2fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=128
> and these:
> /bin/dd of=/dev/rlvctrl1fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=1
> /bin/dd of=/dev/rlvctrl2fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=32k seek=1
>
> /bin/dd of=/dev/rlvctrl1fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=4096 seek=1
> /bin/dd of=/dev/rlvctrl2fm.ctl if=/u08/dbfiler/backup_control01.ctl
> bs=4096 seek=1
>
> When I try to start the database, I get these errors:
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 128048524 bytes
> Fixed Size 38992 bytes
> Variable Size 46056764 bytes
> Database Buffers 81920000 bytes
> Redo Buffers 32768 bytes
> ORA-00205: error in identifying control file '/dev/rlvctrl1fm.ctl'
> ORA-07366: sfifi: invalid file, file does not have valid header block.
>
> Someone??
>
> TIA!
>
> Arne S

An alternative would be to backup your controlfile to trace and recreate it in nomount mode..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"