All technological notes.
NOLOGGING Database ObjectsNOLOGGING Database ObjectsNOLOGGING, minimal redo data is written to the redo stream to support
the creation of the object.

Example:
SALES_COPY table is created as a NOLOGGING table.APPEND hint, no redo is generated for that particular insert statement.
SALES_HISTORY table.CREATE TABLE sales_copy NOLOGGING;
INSERT /*+ APPEND */ INTO sales_copy
SELECT * FROM sales_history;
media recovery, and there are NOLOGGING objects involved, they will be marked logically corrupt during the recovery process.
NOLOGGING objects and re-create them. 因为没有 redo log, 所以会标记逻辑坏块. 只能移除该对象, 再重新创建.