Oracle Analytics Server (OAS) (MOSC) READ-ONLY

MOSC Banner

Discussions

Backing up SYSTEM.SCHEMA_VERSION_REGISTRY$

edited Jun 26, 2013 1:13AM in Oracle Analytics Server (OAS) (MOSC) READ-ONLY 2 commentsAnswered
http/docs.oracle.com/cd/E23943_01/doc.1111/e16793/patch_set_installer.htm#CHDBEJIH

As per link above, what is the strategy to take backup of the SYSTEM.SCHEMA_VERSION_REGISTRY$ along with _MDS and _BIPLATFORM schemas?

How do I restore the SYSTEM.SCHEMA_VERSION_REGISTRY$ table back?

I have been using expdp and impdp to take export of _MDS and _BIPLATFORM but impdp does not restore SYSTEM.SCHEMA_VERSION_REGISTRY$.

expdp \"sys/sys@orbolap1 as sysdba\" schemas=prod_biplatform directory=DATA_PUMP_DIR dumpfile=prod_biplatform.dmp logfile=prod_biplatform.log

expdp \"sys/sys@orbolap1 as sysdba\" schemas=prod_mds directory=DATA_PUMP_DIR dumpfile=prod_mds.dmp logfile=prod_mds.log

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center