Restore raw devices OK but fail to startup Oracle Instance...
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