5 Backup, Recovery, and Deinstallation of Oracle Airlines Data Model

Describes how to deinstall Oracle Airlines Data Model.

• Backing Up and Recovering Oracle Airlines Data Model
  Describes backing up and recovering Oracle Airlines Data Model.
• Overview: Deinstalling Oracle Airlines Data Model
  Perform several tasks to deinstall Oracle Airlines Data Model.
• Pre-Deinstallation Tasks
  Describes the pre-deinstallation tasks to perform before you run the deinstallation script.
• Deinstallation Execution
  Lists the steps for deinstalling Oracle Airlines Data Model.
• Post-Deinstallation Tasks
  Provides the steps for post-deinstallation cleanup.

Backing Up and Recovering Oracle Airlines Data Model

Describes backing up and recovering Oracle Airlines Data Model.

Steps for Backing Up and Recovering Oracle Airlines Data Model

To backup and recover Oracle Airlines Data Model perform the following steps:

1. Backup or recover the relational objects.

2. Backup or recover the analytic workspace that is part of Oracle Airlines Data Model.

• Exporting Oracle Airlines Data Model
  Perform these steps to backup Oracle Airlines Data Model.
• Importing Oracle Airlines Data Model
  Perform these steps to restore Oracle Airlines Data Model from the backup files.

Exporting Oracle Airlines Data Model

Perform these steps to backup Oracle Airlines Data Model.

1. Backup the OADM_SYS schema by executing the expdp utility.

   This utility exports all physical tables containing the data and trained mining models.

2. Backup the analytic workspace that is part of the Oracle Airlines Data Model. The analytic workspace is backed up as an EIF file, named OADM_BAK.EIF, which is generated under the ORACLE_HOME/oadm/pdm/olap directory.

   1. Connect to the Database with oadm_sys.

   2. Issue the following SQL statements:

      exec dbms_aw.execute('AW ATTACH OADM');
      exec dbms_aw.execute('CDA OADM_OLAP_DIR');
      exec dbms_aw.execute('EXPORT ALL TO EIF FILE ','OADM_BAK.EIF',' NOTEMPDATA');
      exec dbms_aw.execute('AW DETACH OADM');
      

Importing Oracle Airlines Data Model

Perform these steps to restore Oracle Airlines Data Model from the backup files.

1. Restore the OADM_SYS schema by executing the impdp utility.

   This utility imports all physical tables containing the data and trained mining models.

2. Connect to the Database with oadm_sys, and import the analytic workspace that was saved as an EIF file, named OADM_BAK.EIF, under the ORACLE_HOME/oadm/pdm/olap directory.

   exec dbms_aw.execute('IMPORT ALL TO EIF FILE ', 'OADM_BAK.EIF');
   

Overview: Deinstalling Oracle Airlines Data Model

Perform several tasks to deinstall Oracle Airlines Data Model.

Deinstalling Oracle Airlines Data Model

To deinstall Oracle Airlines Data Model, you do not simply run Oracle Universal Installer in deinstall mode. Instead, you perform the following tasks:

1. Backup Oracle Airlines Data Model.
2. Stop any sessions that use the Oracle Airlines Data Model schemas.
3. Execute the deinstallation script.
4. If you are deinstalling the sample reports, perform the post deinstallation tasks..

   Note:

   To deinstall Oracle Airlines Data Model, you do not simply run the Oracle Universal Installer in deinstall mode.

Pre-Deinstallation Tasks

Describes the pre-deinstallation tasks to perform before you run the deinstallation script.

The deinstallation script removes the oadm_sys schema.

Identifying if the oadm_sys schema is active

Consequently, before you run the deinstallation script, ensure that there are no active sessions that connect to the oadm_sys schema.

To identify if there are active sessions connecting to these schemas perform the following steps:

1. Sign in as DBA.
2. Execute the following SQL statements:

   select SID,SERIAL# from v$session where USERNAME='OADM_SYS'; 
   

If this query returns a session ID, then there is an active session.

Example 5-1 Ending an active oadm_sys schema session

To end an active session, execute the following statements in which you replace sid and serial are the session ID and serial number returned by the earlier queries:

alter system kill session 'sid,serial' ;

Deinstallation Execution

Lists the steps for deinstalling Oracle Airlines Data Model.

To deinstall Oracle Airlines Data Model:

1. Set the ORACLE_HOME to the location of the Database on which to deinstall Oracle Airlines Data Model.

   For example, suppose that Oracle home is in the directory /loc/app/oracle/product/12.1/

   In a Bourne, Bash, or Korn shell, use these commands to set ORACLE_HOME:

   $ ORACLE_HOME=/loc/app/oracle/product/12.1/
   $ export ORACLE_HOME
   

   In a C shell, use this command to set ORACLE_HOME:

   % setenv ORACLE_HOME /loc/app/oracle/product/12.1/
   

2. Execute the Oracle Airlines Data Model deinstallation script:

   $ORACLE_HOME/oadm/oadm_deinstall.sh

3. When prompted, enter the SYSTEM password.

   The script de-configures Oracle Airlines Data Model and executes the Oracle Universal Installer in deinstall silent mode.

See Also:

If you are deinstalling the sample reports, after the deinstallation script runs, perform the tasks described in "Post-Deinstallation Tasks"

Post-Deinstallation Tasks

Provides the steps for post-deinstallation cleanup.

If you are deinstalling the Oracle Airlines Data Model sample reports, then follow these steps to perform additional cleanup:

1. Delete oadm.rpd in the directory BIHome/Server/Repository.
2. Delete the oadmwebcat folder in BIDataHome/web/catalog.
3. Delete the following line from BIHome/Server/Config/NQSConfig.INI:

   Star    =    oadm.rpd, DEFAULT