From: Cohen, Andy (Andy.Cohen@cognex.com)
Date: Tue Jun 25 2002 - 16:28:26 EDT
Hi,
I'm trying to clone an oracle database but keep getting a message that a
particular datafile needs media recovery.
The brief scenario is this:
system01.dbf gets compressed at night (producing system01.dbf.Z) (for you
Oracle folks - this was first copied as part of a hot backup)
rcopy the file from Machine A (4.0D) to Machine B (4.0E)
uncompress the file
attempt to start database (I'll leave out all of the many Oracle particulars
here)
get message the file needs recovery.
I'm wondering if the file is 'messed up'. If I do a sum/cksum on the file
the outputs are different on the different machines.
Machine A (source machine):
# sum system01.dbf
57769 51208 system01.dbf
# cksum system01.dbf
808933033 52436992 system01.dbf
while on Machine B output is:
# sum system01.dbf
30665 51208 system01.dbf
# cksum system01.dbf
2317007751 52436992 system01.dbf
Do the differing numbers in the first column mean the file has gotten
changed or corrupted someway during either the rcp or the uncompress? i.e.,
should both columns of numbers be the same? Unfortunately I don't have the
exact copy of the file that was used to create the .Z file on Machine A
Thanks alot!
Andy
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:48:44 EDT