Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RMAN/Alert_log questions
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.
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