Oracle DataGuard主库NOLOGGING问题

alert 日志报错信息：

ORA-01578: ORACLE data block corrupted (file # 1, block # 2521)
ORA-01110: data file 1: '/u01/app/oracle2/datafile/ORCL/system01.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option

出现原因：

如果主库未做强制日志传输，出现NOLOGGING 子句会影响到备库日志恢复式

需要将主库设置强制日志
SQL> ALTER DATABASE FORCE LOGGING;

处理：

1）查询受NOLOGGING 影响的文件
SQL> SELECT FILE#, FIRST_NONLOGGED_SCN FROM V$DATAFILE WHERE FIRST_NONLOGGED_SCN > 0;
       
     FILE#      FIRST_NONLOGGED_SCN
   ---------- -------------------
      4            20606544

2）清空删除受影响的数据文件
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE DATAFILE 4 OFFLINE FOR DROP;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

3）利用查询的SCN 号，进行增量备份
RMAN> BACKUP INCREMENTAL FROM SCN 20606544 DATAFILE 4 FORMAT '/data/Dbf_inc_%U' TAG 'FOR STANDBY';

4）拷贝备份文件到备库

5）备库rman 注册备份文件
RMAN> CATALOG START WITH '/data/Dbf_inc_';

6）备库取消日志应用，并ONLINE 相应的数据文件
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE DATAFILE 4 ONLINE;

7)恢复相应的数据文件
RMAN> RECOVER DATAFILE 4 NOREDO;

8）再次查询确认
SQL> SELECT FILE#, FIRST_NONLOGGED_SCN FROM V$DATAFILE WHERE FIRST_NONLOGGED_SCN > 0;

9）备库启动日志应用
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;