omniutil

NAME

SYNOPSIS

omniutil -a pd_create -i ora_sid -d basedir [ -v ora_vers ]

omniutil -a pd_link -i ora_sid -d basedir

AVAILABILITY

DESCRIPTION

The different tools can be started using the -a action option.

The remaining options are dependent of the selected action.

For a description of the functionality of the different actions see section OPTIONS.

OPTIONS

-h

usage message.

-a action

:

pd_create

create a pointer directory structure. This is a structure mainly consisting of symbolic links that will point to an $ORACLE_HOME after invoking -a pd_link later.

This enables DataProtector to backup databases, that have no own $ORACLE_HOME installation. The $ORACLE_HOME setting in DataProtector can be set to this "pretended" $ORACLE_HOME.

To allow a pseudo-dynamic setup, after invoking -a pd_create ... the two symbolic links ( .ora_home and .network_admin ) in the applied structure have to be set accordingly using -a pd_link ... .

See also section EXAMPLES.

pd_link

the structure applied using -a pd_create ... mainly contains symbolic links that first point to the two main symbolic links ( .ora_home and .network_admin ). This two links then should point to the real $ORACLE_HOME. This indirect symbolic link structure enables an automated update of the structure if an Oracle installation is patched creating a new $ORACLE_HOME with the applied patches. Normally the directory structure after installing a patch is identical, but the binaries etc. might change. If a patch is applied using this method it is only needed to update the two symbolic links .ora_home and .network_admin using the -a pd_link ... option.

In the configuration file omniutil.cfg the command to resolve the current $ORACLE_HOME and $TNS_ADMIN can be specified in the ORACLE_ENV_CMD setting. If it is not possible to resolve this environment variables, they can be set manually previous to the omniutil command invocation using export ORACLE_HOME=path and export TNS_ADMIN=path .

To ensure that the described symbolic links always point to the most recent $ORACLE_HOME the ~edrc/bin/omniutil -a pd_link -i ora_sid -d basedir can be defined as PRE_EXEC script in the DataProtector Barlist for the related database backup.

See also section EXAMPLES.

-i ora_sid

Oracle SID.

-d basedir

Base directory of the pointer directory structure.

-v ora_version

Database version (=template file ora_version.tar.gz located in edrc/var/omniutil/pd/ ).

ENVIRONMENT

EXIT STATUS

0

no error.

2

operating system not supported, see osid(3) if you get this error.

4

usage listed.

6

configuration file omniutil.cfg does not exist.

10

template for the specified Oracle version ( ora_vers ) does not exist.

11

DataProtector Oracle pointer directory ( <basedir>/<ora_sid> ) already exists.

12

template does not contain the directory for the specified Oracle version ( ora_vers ).

13

cannot write to the specified basedir.

21

DataProtector pointer directory <basedir>/<ora_sid> does not exist.

23

cannot write to the specified basedir.

FILES

edrc/etc/omniutil.cfg

configuration file for omniutil.

edrc/var/omniutil/pd/<ora_vers>/

template files for the pointer directory structure.

edrc/var/omniutil/pd/<ora_vers>.tar.gz

packed template files for the pointer directory structure. For easy distribution of the template structure, always the packed version of the structure template should be used.

<basedir>/<ora_sid>/

applied template pointer directory structure

<basedir>/<ora_sid>/.ora_home

main symbolic link of applied template pointer directory structure pointing to the $ORACLE_HOME directory of the installed Oracle software for a certain database ( ora_sid ).

<basedir>/<ora_sid>/.network_admin

main symbolic link of applied template pointer directory structure pointing to the $TNS_ADMIN directory of the installed Oracle software for a certain database ( ora_sid ).

EXAMPLES

1) create a pointer directory structure

This example shows how to create a pointer directory structure for the database FS90DMO in the directory /data_ps1/dat/omni/ that will be used as $ORACLE_HOME for this database in DataProtector. The $ORACLE_HOME that is used by the database itself is located in /ora/product/10204.

1.1) create the directory structure

Create the generic pointer directory structure for the database version 10gR2 :

[ /data_ps1/dat/omni ]
[ root@acme001 ][-sh]: ~edrc/bin/omniutil -a pd_create -i FS90DMO \
                         -d /data_ps1/dat/omni -v 10gR2

omniutil - DataProtector Utilities
 
create OBII Oracle pointer directory structure ...
    create /data_ps1/dat/omni/FS90DMO ... done.
    create structure ...
        using template: /opt/edrc/var/omniutil/pd/10gR2.tar.gz
        /data_ps1/dat/omni/FS90DMO/.patch_storage
        /data_ps1/dat/omni/FS90DMO/OPatch
        /data_ps1/dat/omni/FS90DMO/assistants
        /data_ps1/dat/omni/FS90DMO/bin
        /data_ps1/dat/omni/FS90DMO/cdata
        /data_ps1/dat/omni/FS90DMO/cfgtoollogs
        /data_ps1/dat/omni/FS90DMO/clone
        /data_ps1/dat/omni/FS90DMO/config
        /data_ps1/dat/omni/FS90DMO/crs
        /data_ps1/dat/omni/FS90DMO/css
        /data_ps1/dat/omni/FS90DMO/ctx
        /data_ps1/dat/omni/FS90DMO/dbs
        /data_ps1/dat/omni/FS90DMO/demo
        /data_ps1/dat/omni/FS90DMO/diagnostics
        /data_ps1/dat/omni/FS90DMO/has
        /data_ps1/dat/omni/FS90DMO/hs
        /data_ps1/dat/omni/FS90DMO/install
        /data_ps1/dat/omni/FS90DMO/inventory
:
:
        /data_ps1/dat/omni/FS90DMO/sqlj
        /data_ps1/dat/omni/FS90DMO/sqlplus
        /data_ps1/dat/omni/FS90DMO/srvm
        /data_ps1/dat/omni/FS90DMO/sysman
        /data_ps1/dat/omni/FS90DMO/tg4ifmx
        /data_ps1/dat/omni/FS90DMO/tg4ingr
        /data_ps1/dat/omni/FS90DMO/tg4sybs
        /data_ps1/dat/omni/FS90DMO/tg4tera
        /data_ps1/dat/omni/FS90DMO/uix
        /data_ps1/dat/omni/FS90DMO/wwg
        /data_ps1/dat/omni/FS90DMO/xdk
        /data_ps1/dat/omni/FS90DMO/.network_admin
        /data_ps1/dat/omni/FS90DMO/.ora_home
        0 blocks
    done.
done.

1.2) set the directory structure link

Update the symbolic links to point to the $ORACLE_HOME for the given database:

[ /data_ps1/dat/omni/FS90DMO ]
[ root@acme001 ][-sh]: ~edrc/bin/omniutil -a pd_link -i FS90DMO \
                         -d /data_ps1/dat/omni

omniutil - DataProtector Utilities
 
update OBII Oracle pointer directory symlinks ...
    in directory /data_ps1/dat/omni/FS90DMO ...
        omniutil-INFO: symlink '.network_admin -> /ora/product/10204/network/admin' created
        omniutil-INFO: symlink '.ora_home -> /ora/product/10204' created
    done
done.

SEE ALSO

NOTES

BUGS

AUTHOR

COPYRIGHT

This is free software; see edrc/doc/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.