Re: cp command to backup database

From: Steve <ThisOne_at_Aint.valid>
Date: Thu, 24 Jun 2004 22:49:03 +1200
Message-ID: <cbebj0$ahk$1@lust.ihug.co.nz>

joe haydn wrote:
> hi all. We're working on an oracle server, linux (suse 7.3) based, in
> migrating to a faster machine with bigger harddrive. First we plugged in the
> correctly partitioned harddrive from the new machine, then booted off the
> Oracle server via a knoppix cdrom, and mounted both hda and hdb, and did:
>
>

>>cp -a /mnt/orig/* /mnt/dest/

>
>
> to copy everything from the original to the new harddrive (I know this
> command is sufficient in cloning the system).
>
> The cp command gave an error to the following files pertaining to the oracle
> (9) database:
>
> exampl01.dbf
> control01.ctl
> control02.ctl
>
> It said "cp: Input/output error".
>
> Could this imply the harddrive corrupt (like bad sectors), or is there
> something that I don't know about Oracle database files, which possibly be
> preventing from using te"cp" command? It shouldn't matter if it's Oracle
> database or any file, that cp command can manipulate, correct? We're using
> Reiser filesystem btw.
>
> I could do "dd" to clone the server harddisk, but if it's bad sector
> problem, then that wouldn't be a solution anyway.
>
> any input I appreciate,
>
>
>
>

Silly question, but Oracle was shut down, wasn't it? I assume so, as you booted from cd.

It looks like the disk's not well at all. cp will copy files of any kind without any problems.

As a last ditch attempt, download the latest reiser toolkit, reiserfsprogs, umount the partition and try and recover it. reiserfsck has lots of exciting options iirc!

I'd also see if I could perform a full export of the database... you never know, it may be unused parts of the tablespaces that are corrupt.

using dd will just transfer a real problem onto an 'imagined' one.

hth,

Steve Received on Thu Jun 24 2004 - 05:49:03 CDT