nologging对备库的影响

unsupported record found in the archived redo log

可以通过从主库手工同步

UNRECOVERABLE_CHANGE#

Oracle: RAC 10.2.0.5， 生产库

OS: AIX
症状：alertlog显示如下

Mon Mar 05 22:02:32 GMT+08:00 2012GATHER_STATS_JOB encountered errors. Check the trace file.

Mon Mar 05 22:02:32 GMT+08:00 2012Errors in file /u001/app/oracle/admin/justin/bdump/justin1_j000_27525252.trc:

ORA-01578: ORACLE data block corrupted (file # 1024, block # 497129)

ORA-01110: data file 8: '/s102/justin/CMX_INDX1.dbf'

ORA-26040: Data block was loaded using the NOLOGGING option
其中trace文件大致为

WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1 

*** 2012-03-05 22:00:16.032

WARNING:Could not lower the asynch I/O limit to 256 for SQL direct I/O. It is set to -1 

WARNING:Could not lower the asynch I/O limit to 224 for SQL direct I/O. It is set to -1 

WARNING:Could not lower the asynch I/O limit to 192 for SQL direct I/O. It is set to -1 

WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1 

WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1 

WARNING:Could not lower the asynch I/O limit to 192 for SQL direct I/O. It is set to -1 

WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1 

*** 2012-03-05 22:02:32.085

ORA-01578: ORACLE data block corrupted (file # 1024, block # 497129)

ORA-01110: data file 8: '/s102/justin/C_INDX1.dbf'

ORA-26040: Data block was loaded using the NOLOGGING option

*** 2012-03-05 22:02:32.103

GATHER_STATS_JOB: GATHER_TABLE_STATS('"JUSTIN"','"C_SEJ"','""', ...)

ORA-01578: ORACLE data block corrupted (file # 1024, block # 497129)

ORA-01110: data file 8: '/s102/justin/CMX_INDX1.dbf'

ORA-26040: Data block was loaded using the NOLOGGING option

查看v$database_block_corruption，返回3000多行且corruption_type为unknown


MOS上有相关文档ID 794505.1

运行

select distinct e.owner,e.segment_type,e.segment_name from dba_extents e, v$database_block_corruption c

where c.file# = e.file_id

and c.block# between e.block_id and e.block_id + e.blocks;
返回2000多行，且全为index

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15480802/viewspace-718438/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15480802/viewspace-718438/