backup database using cp command

From: joe haydn <nospam_at_nospam.com>
Date: Thu, 24 Jun 2004 07:21:27 GMT
Message-ID: <XhvCc.11956$bs4.2925@newsread3.news.atl.earthlink.net>

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, Received on Thu Jun 24 2004 - 02:21:27 CDT