Cloned Olap Database Gets ORA-01578 Nologging
(Doc ID 374036.1)
Last updated on NOVEMBER 25, 2019
Applies to:Oracle OLAP - Version 126.96.36.199 and later
Information in this document applies to any platform.
You made an image copy of the data files from your production instance (PROD). Moved the files to a test server and restored/renamed the database to TEST.
The schema's and AW should be the same in TEST since it's a recovered version of
the same database/instance.
You get the following error message when you try to attach the AW using Analytic Workspace
java.sql.SQLException: ORA-33272: (DBERR06) Analytic workspace TEST_USER.TESTAW
cannot be opened.
ORA-01578: ORACLE data block corrupted (file # 15, block # 59216)
ORA-01110: data file 15: '<DIR>/test_04.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
ORA-06512: at "SYS.DBMS_AW", line 18
ORA-06512: at line 1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document