Re: RMAN/Alert_log questions

My answers:
1. You have 2 archiver processes - ARC0 and ARC1, right?

   Than it is not an issue
2. use dbv to check file. To be safe, move it (on both OS and DB levels) somewhere and
check disk for physical damage (chkdisk?)

On 2004-12-23, jw <jw_at_hotmail.com> wrote:
> Hi there,
>
> I run the daily RMAN at 3:00 in the morning. I captured the following in
> the alert log. I have two questions here.
>
> 1. at 3:00:03, it quoted ARC1: Unable to archive log 1. Is this normal
> when starting RMAN to backup database ?
>
> 2. It found corrupted block, and 'found valid data' after reread. But
> there is no error at window 2000 OS level. That file is for indexing
> purpose. What should I do ? Re-create the index or repair the data
> block ? What options should I use if using DBMS.Repair.
>
> Thanks.
>
> JW
> ***************************************
>
> Wed Dec 22 03:00:02 2004
> Thread 1 advanced to log sequence 3452
> Current log# 2 seq# 3452 mem# 0: C:\ORACLE\ORA92\DATA\REDO02A.LOG
> Current log# 2 seq# 3452 mem# 1: D:\ORACLE\ORA92\DATA\REDO02B.LOG
> Wed Dec 22 03:00:02 2004
> ARCH: Evaluating archive log 1 thread 1 sequence 3451
> ARCH: Beginning to archive log 1 thread 1 sequence 3451
> Creating archive destination LOG_ARCHIVE_DEST_1: 'F:\ARCH_LOG\DATA_03451_
> 001.ARC'
> Wed Dec 22 03:00:03 2004
> ARC1: Evaluating archive log 1 thread 1 sequence 3451
> ARC1: Unable to archive log 1 thread 1 sequence 3451
> Log actively being archived by another process
> Wed Dec 22 03:00:03 2004
> ARCH: Completed archiving log 1 thread 1 sequence 3451
> ***
> Corrupt block relative dba: 0x020bbeea (file 8, block 769770)
> Fractured block found during backing up datafile
> Data in bad block -
> type: 6 format: 2 rdba: 0x020bbeea
> last change scn: 0x0000.3256c9e4 seq: 0x2 flg: 0x06
> consistency value in tail: 0x4c8a0601
> check value in block header: 0x6a95, computed block checksum: 0x803f
> spare1: 0x0, spare2: 0x0, spare3: 0x0
> ***
> Reread of blocknum=769770, file=E:\ORACLE\ORA92\DATA\DATA_INDEX.DBF.
> found valid data
> Wed Dec 22 03:26:23 2004
> Thread 1 advanced to log sequence 3453
> Current log# 3 seq# 3453 mem# 0: C:\ORACLE\ORA92\DATA\REDO03A.LOG
> Current log# 3 seq# 3453 mem# 1: D:\ORACLE\ORA92\DATA\REDO03B.LOG
Received on Wed Dec 22 2004 - 23:39:31 CST