how to configure omni backup for oracle databases

Hi ,

Please find the steps to configure the omni backup for oracle servers

1. Please install the omni client in database machine.

That will be done by Unix administrators.

2. Create symbolic link between omni and $ORACLE_HOME

Go to $ORACLE_HOME/lib then run the below command.

ln -s /opt/omni/lib/libob2oracle8_64bit.so libobk.so

3. Create the catalog schema in the respective catalog databases.

A. % sqlplus '/ as sysdba'
SQL> CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE tools TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON tools;
SQL> GRANT CONNECT, RECOVERY_CATALOG_OWNER TO rman;


B. % rman catalog rman/rman @ catadb

RMAN> CREATE CATALOG;

Note: Please check the database version of catalog database and target database must be same otherwise upgrade the catalog schema.

Upgrade catalog steps:
---------------------------------------------------------------------------
% rman target / catalog rman/rman @ catdb

RMAN> UPGRADE CATALOG;RMAN-06435: recovery catalog owner is rman RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade RMAN> UPGRADE CATALOG;
-------------------------------------------------------------------------------------------------

C: Registering the target database

% rman TARGET / CATALOG rman/rman @ catdb RMAN> REGISTER DATABASE;

4. Configure the backup in target machine using below command

Go to /opt/omni/lbin directory

util_oracle8.exe -CONFIG $ORACLE_SID $ORACLE_HOME backup/backup@dwhprd rman_dwhprdnew/rman@irman10

5. Then we can configure the backup in GUI mode.