ORA-1578 or Broken Standby

ORA-1578 / ORA-26040 Corrupt blocks by NOLOGGING – Error explanation and solution (Doc ID 794505.1)
How to identify the corrupt Object reported by ORA-1578 / RMAN / DBVERIFY (Doc ID 819533.1)

Rolling a Standby Forward using an RMAN Incremental Backup To Fix The Nologging Changes (Doc ID 958181.1)
ORA:1578 ORA-26040 On Active Data Guard (Doc ID 1320878.1)
OERR: ORA-26040 “Data block was loaded using the NOLOGGING option ” Reference Note (Doc ID 71344.1)


SQL> select force_logging from v$database;


SQL> select tablespace_name, force_logging from dba_tablespaces;

TABLESPACE_NAME                FOR
—————————— —
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       NO
TEMP                           NO
USERS                          NO

SQL> create table t.nologg tablespace users nologging as select 1 d from dual;

Table created.


SQL> select * from t.nologg;
select * from t.nologg
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 4, block # 315)
ORA-01110: data file 4: ‘/home/oracle/base/DB03/datafile/o1_mf_users_08qsr5fo_.dbf’
ORA-26040: Data block was loaded using the NOLOGGING option

Don’t Waste Money On Information Technology

Suppose you have a startup of business but you aren’t sure that the idea is correct and you’ll get the profit. As a storage and processing of large amounts of data you selected Oracle database. You ready to invest in aggressive ad to attract customers dramatic, but just don’t want to buy expensive storage systems from IBM, HP, Hitachi, NetApp and other vendors. You want to build and grow your Internet service as a building, constructing additions floor by floor, depending on the line of business. However, you are aware that investments in ad will give you a a lot of visitors to your web site and you must serve them without delay. Because the negative unavailability of your web site will lead to loss of reputation. Continue reading “Don’t Waste Money On Information Technology”