Restore raw devices OK but fail to startup Oracle Instance...

From: KENNY L. CHEN <kenny_60559_at_yahoo.com>
Date: 29 Aug 2002 00:55:05 -0700
Message-ID: <83f59352.0208282355.65dd7b55_at_posting.google.com>


Dear Oracle experts,

I created a Oracle Instance (orcl) in our HP-UX. The datafiles and logfiles of Oracle instance are all raw. I shutdown Oracle and made cold backup by issuing dd command. The following is the script I wrote to backup. It ran without error
message.

# === Backup raw devices script

#! /bin/ksh
# Rewind the tape /dev/rmt/6mn is the mounted tape device

mt -f /dev/rmt/6mn rew
dd if=/dev/vg01/rorcl_system of=/dev/rmt/6mn bs=32k skip=32
dd if=/dev/vg01/rorcl_data01 of=/dev/rmt/6mn bs=32k skip=32
dd if=/dev/vg01/rorcl_idx01 of=/dev/rmt/6mn bs=32k skip=32
dd if=/dev/vg01/rorcl_rbs1 of=/dev/rmt/6mn bs=32k skip=32
dd if=/dev/vg01/rorcl_redo1 of=/dev/rmt/6mn bs=32k skip=32
dd if=/dev/vg01/rorcl_redo2 of=/dev/rmt/6mn bs=32k skip=32
dd if=/dev/vg01/rorcl_redo3 of=/dev/rmt/6mn bs=32k skip=32

# ===

I tried to restore the Oracle Instance by running the following script after
backup. The script also ran without error. But I got error message:

ORA-01251: Unknown File Header Version read for file number 1

when I startup this Oracle instance. It seems the datafile I restored was corrupted.

# === Restore raw devices script

#! /bin/ksh
# Rewind the tape

mt -f /dev/rmt/6mn rew
dd of=/dev/vg01/rorcl_system if=/dev/rmt/6mn bs=32k skip=32
dd of=/dev/vg01/rorcl_data01 if=/dev/rmt/6mn bs=32k skip=32
dd of=/dev/vg01/rorcl_idx01 if=/dev/rmt/6mn bs=32k skip=32
dd of=/dev/vg01/rorcl_rbs1 if=/dev/rmt/6mn bs=32k skip=32
dd of=/dev/vg01/rorcl_redo1 if=/dev/rmt/6mn bs=32k skip=32
dd of=/dev/vg01/rorcl_redo2 if=/dev/rmt/6mn bs=32k skip=32
dd of=/dev/vg01/rorcl_redo3 if=/dev/rmt/6mn bs=32k skip=32

# ===

Is there anyone successfully backup and restore Oracle raw devices before
can advise what's wrong with my command or procedure ??

THANK YOU KENNY Received on Thu Aug 29 2002 - 09:55:05 CEST

Original text of this message