Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN/Alert_log questions

RMAN/Alert_log questions

From: jw <jw_at_hotmail.com>
Date: Thu, 23 Dec 2004 05:27:16 GMT
Message-ID: <Xns95C7E51D1A807jwhotmailcom@198.80.55.250>


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:27:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US