Не применяются арклоги на STANDBY сервере:
Reading datafile '/u01/app/oracle/oradata/databasename/superfile_edr_tbls01.dbf' for corruption at rdba: 0x054018ae (file 21, block 6318) Reread (file 21, block 6318) found same corrupt data (logically corrupt) Mon Jun 14 04:28:27 2021 Checker run found 1 new persistent data failures ERROR: ORA-00756 detected lost write of a data block Slave exiting with ORA-756 exception Mon Jun 14 04:28:32 2021 Errors in file /u01/app/oracle/diag/rdbms/databasename_bk/databasename/trace/databasename_pr02_22763.trc: ORA-00756: recovery detected a lost write of a data block ORA-10567: Redo is inconsistent with data block (file# 21, block# 6318, file offset is 51757056 bytes) ORA-10564: tablespace SUPERFILE_EDR_TBLS ORA-01110: data file 21: '/u01/app/oracle/oradata/databasename_bk/superfile_edr_tbls01.dbf' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 21388901
При живом PRIMARY восстановим файл с него на STB. Подключимся RMAN к стендбай серверу и дадим команду:
restore datafile 21 from service main;
…
alter database recover managed standby database disconnect from session;
profit