Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA 1578 error, any suggestions?
ORACLEites:
We had an ORA 1578 error which is a bad block error. We run SAP on top of our 7.3.2.x Oracle instance. We were running a client copy and forgot to turn archivemode to off. We believe that what happend is that a write error occurred at some point in the client copy process and that when Oracle's PMON process tried to fix it by copying the block from the redo logs, that the redo log necessary was already written to the archive filesystem or even moved to tape (which was done by us during the client copy process).
We are attempting to fix this by rolling back to before the client copy process and then trying it again with archivemode turned off.
Has anyone had any experience with this sort of problem before? If so, any information would be extremely appreciated.
Thanks in advance.
P.S. While we have a strategy in place, any 'sanity check' you might want to provide for us would also be helpful
Jason Berryhill