mooServer Backup


myObjectiveOLAP Server enables you to quickly and easily snapshot your meta-data analytic workspaces.


To access the mooServer Backup utility access the tool from the myObjectiveOLAP Server ribbon menu.



Enter a valid Oracle database directory alias which the MOOSERVER database user has WRITE access to and press Save.


The backup tool will backup the following analytic workspaces:


Analytic Workspace

Contents

MOOCODE

myObjectiveOLAP standard server code

LOCALCODE

Your local OLAP DML programs

PRD

The Process Manager daemon

MOOUSERS

All the information and meta-data relating to your application users.

PRCONTROL

All the information and meta-data relating to your application Processes and Workflows

       

All the analytic workspaces will be exported in EIF format to the directory alias supplied.  If an invalid directory alias or no alias is supplied, myObjectiveOLAP will report an error.


EIF files will be created in the following format:


[POSIX time]_[DDMMMYY]_[HH]:[MM]:[SS]_[AWNAME].eif


Backups can be queried either by creating a report, or looking at the MOOSERVER.MOOBACKUP$BACKUP.CTL variable:


> aw attach MOOBACKUP ro


> lmt BACKUP to last 1


> rpr w 40 down BACKUP.ATT w 50 BACKUP.CTL


                                         --------------------BACKUP.CTL--------------------

                                         ----------------------BACKUP----------------------

BACKUP.ATT                                                   1357052585

---------------------------------------- --------------------------------------------------

LOG                                      01JAN13 15:03:05 Backup up MOOCODE

                                         01JAN13 15:03:05 Backup up LOCALCODE

                                         01JAN13 15:03:05 Backup up PRD

                                         01JAN13 15:03:05 Backup up PRCONTROL

                                         01JAN13 15:03:05 Backup up MOOUSERS

MOOCODE_FILE                             1357052585_01JAN13_15:03:05_MOOCODE.eif

MOOLOCALCODE_FILE                        1357052585_01JAN13_15:03:05_LOCALCODE.eif

PRD_FILE                                 1357052585_01JAN13_15:03:05_PRD.eif

MOOUSERS_FILE                            1357052585_01JAN13_15:03:05_MOOUSERS.eif

CDA                                      OLAPCDA

PRCONTROL_FILE                           1357052585_01JAN13_15:03:05_PRCONTROL.eif



> aw detach MOOBACKUP


Backups of MOODATA would normally be carried out as part of your database backup and recovery strategy. RMAN etc....