Describes backup, recovery and deinstallation tasks.
Describes backing up and recovering Oracle Utilities Data Model.
To backup and recover Oracle Utilities Data Model perform the following steps:
Perform these steps to backup Oracle Utilities Data Model.
Backup the OUDM_SYS schema by executing the expdp utility.
This utility exports all physical tables containing the data and trained mining models.
Backup the analytic workspace that is part of the Oracle Utilities Data Model. The analytic workspace is backed up as an EIF file, named OUDM_BAK.EIF, which is generated under the ORACLE_HOME/oudm/pdm/olap directory.
Connect to the Database with oudm_sys.
Issue the following SQL statements:
exec dbms_aw.execute('AW ATTACH OUDM);
exec dbms_aw.execute('CDA OUDM_OLAP_DIR');
exec dbms_aw.execute('EXPORT ALL TO EIF FILE ','OUDM_BAK.EIF',' NOTEMPDATA');
exec dbms_aw.execute('AW DETACH OUDM');
Related Topics
Perform several tasks to deinstall Oracle Utilities Data Model.
To deinstall Oracle Utilities Data Model, you do not simply run Oracle Universal Installer in deinstall mode. Instead, you perform the following tasks:
Describes the pre-deinstallation tasks to perform before you run the deinstallation script.
The deinstallation script removes the oudm_sys schema.
Identifying if the oudm_sys Schema is Active
Before you run the deinstallation script, ensure that there are no active sessions that connect to the oudm_sys schema.
To identify if there are active sessions connecting to these schemas perform the following steps:
If this query returns a session ID, then there is an active session.
Example 5-1 Ending an Active oudm_sys Schema Session
To end an active session, execute the following statements in which you replace sid and serial, the session ID and serial number returned by the earlier query:
alter system kill session 'sid,serial' ;
The following rules for tnsnames.ora are mandatory for Oracle Utilities Data Model deinstallation.
Non Oracle RAC Environment
For a non Oracle RAC environment, the installer sets the SID to the value of the lowercase tnsnames entry chosen by the user during installation (as the Net Service Name). Thus, during deinstallation the tnsnames entry must accurately reflect the Net Service Name supplied as a parameter during installation.
For example, if the SID is orcl11203, you cannot set the tnsnames entry to OUDM_Test. If SID is orcl11203, then tnsnames entry must be set to orcl11203.
Oracle RAC Environment
For an Oracle RAC environment, the Oracle System Identifier (SID) is set to lowercase tnsnames.ora entry chosen by the user during installation (as the Net Service Name). Thus, the tnsnames.ora entry should accurately reflect the SID for the system on which product is deinstalled in an Oracle RAC environment.
Modify the tnsnames.ora entry name to match the SID of the database node for the system. After the deinstallation, revert the tnsnames entry to the previous entry.
For example, if the SID is orcl2, you cannot set the tnsnames entry to localhost_orcl. In this case, if the SID is orcl2, then the tnsnames entry must be set to orcl2.