Online backup and raw device

From: Arne Sodal <apsodal_at_online.no>
Date: Wed, 22 Nov 2000 22:19:52 +0100
Message-ID: <3A1C3878.29B6DFFA@online.no>

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 Received on Wed Nov 22 2000 - 15:19:52 CST