修复由于主库nolog操作引起的备库ora - 01578和ora - 26040错误



DG 

nologging nologging redo 

force_logging 

/* +append*/ 

Oracle 11g 

UNRECOVERABLE_CHANGE# UNRECOVERABLE_CHANGE 

RENAME 

rename manual

DEMO

12.1 RMAN restore database (or datafile ) from service 

Oracle RMAN RMAN nologging FORCE 

RESOTORE DATABASE FORCE FORCE RMAN 

mount 

RMAN, restore database (or datafile ) from service 

primary_db, tns 


12.2 Oracle v$nonlogged_block RMAN

RMAN 

log_archive_config 

12.2 force logging redo dml 12.2 nonlogging 



 Recovery Steps for Physical Standby Databases

When the archived redo log file is copied to the standby site and applied to the physical standby database, a portion of the datafile is unusable and is marked as being unrecoverable. 当你失败到物理备用数据库,或打开备用数据库的只读访问,并尝试读as 标示有块的范围,,<代码> UNRECOVERABLE > 

 ora - 01578:, ORACLE  data  block  corrupted  (file  #, 1, block  #, 2521), ora - 01110:, data  file  1:, & # 39;/oracle/dbs/stdby tbs_1.dbf& # 39;, ora - 26040:, data  block  was  loaded  using 从而NOLOGGING 选择

后的恢复,,<代码> NOLOGGING  ,指定条款,您需要复制数据文件包含丢失的重做数据从主站点物理备用站点。执行以下步骤:


步骤1,,决定哪些实际上应该被复制。

Follow these steps:

  1. Query the primary database:

    SQL> SELECT NAME, UNRECOVERABLE_CHANGE# FROM V$DATAFILE; NAME                                                  UNRECOVERABLE ----------------------------------------------------- ------------- /oracle/dbs/tbs_1.dbf                                       5216 /oracle/dbs/tbs_2.dbf                                          0 /oracle/dbs/tbs_3.dbf                                          0 /oracle/dbs/tbs_4.dbf                                          0 4 rows selected.null
    修复由于主库nolog操作引起的备库ora - 01578和ora - 26040错误