Cloned Olap Database Gets ORA-01578 Nologging
(Doc ID 374036.1)
Last updated on NOVEMBER 08, 2022
Applies to:
Oracle OLAP - Version 9.2.0.5 and laterInformation in this document applies to any platform.
Symptoms
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
Manager.
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
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |