Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Online backup and raw device

Re: Online backup and raw device

From: Robert Malikian <robertmalikian_at_hotmail.com>
Date: Fri, 24 Nov 2000 05:56:39 -0800
Message-ID: <KjnT5.602$EE.19377@news-1.opaltelecom.net>

Check to see that your control file has the same name as in initSID.ora and they all exist in correct dirs.
Robert
"Arne Sodal" <apsodal_at_online.no> wrote in message news:3A1C3878.29B6DFFA_at_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 Fri Nov 24 2000 - 07:56:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US