topic Re: RAID error causing Archive problem in Operating System - Linux

RAID error causing Archive problem

kenny chia — Tue, 05 Aug 2003 01:35:12 GMT

Hi
I'm running an Oracle 8i database on RedHat 6.2 .A recent single drive problem on my RAID system caused an archival error. Error message is

Error 27052 closing archivelog file '/users1/arch/arch_1_1521.arc'

Could the file '/users1/arch/arch_1_1521.arc' be corrupted? Should I use this archive for future restoration?

Thanks

Re: RAID error causing Archive problem

Steven E. Protter — Tue, 05 Aug 2003 01:36:39 GMT

You should not rely on this file.

You should shut down the database, take a good cold backup and then deal with your disk problem prior to bringing the database online.

This is Oracle and its your data, the most important thing you have. Protect it. Take no chances with it.

SEP

Re: RAID error causing Archive problem

twang — Tue, 05 Aug 2003 01:46:25 GMT

Agree with SEP, in your current situation, the most important thing to do is taking a cold backup for your database.

Re: RAID error causing Archive problem

Brian Crabtree — Tue, 05 Aug 2003 19:58:14 GMT

I dont think that you need a cold backup, however I would recommend getting a hot backup done. You should have these running on a nightly basis though, so you shouldn't have anything to worry about, unless you absolutely have to recover the database from that day. I would just recommend that you treat the time between the suspected logfile and the backup as being unrecoverable.

Thanks,

Brian