i. The online backup manager must be installed onto the computer that can connect to your Oracle 8i/9i server using TCP/IP protocol.

ii. Data from Oracle 8i/9i database will be backed up to a temporary directory before they are sent to offsite backup server. Please make sure you have sufficient space on your computer to store these data when you run the backup job.

iii. Database must be in archived log mode To switch to archived log mode and enable automatic log archiving, please do the following:

a. Set the parameters below in the PFILE to enable automatic archiving

log_archive_dest = [directory where archived logs will be stored]

log_archive_format = ARCH%S.LOG

log_archive_start = TRUE

b. Switch to archived log mode

SVRMGRL> connect internal;

SVRMGRL> startup mount;

SVRMGRL> alter database archivelog;

SVRMGRL> alter database open;

c. Enable Oracle JVM for Oracle 8i/9i, please do the following:

1. Please make sure shared pool size is larger than 50MB and java pool size is larger than

20MB in the PFILE. For example:

java_pool_size = 20971520

shared_pool_size = 52428800

2. Run the scripts below

For Oracle 8i

SVRMGRL> connect internal

SVRMGRL> @?/javavm/install/initjvm.sql;

SVRMGRL> @?/rdbms/admin/catalog.sql;

SVRMGRL> @?/rdbms/admin/catproc.sql;

SVRMGRL> @?/javavm/install/initdbj.sql;

For Oracle 9i

SQL> connect sys/change_on_install as sysdba

SQL> @?/javavm/install/initjvm.sql;

SQL> @?/xdk/admin/initxml.sql;

SQL> @?/xdk/admin/xmlja.sql;

SQL> @?/rdbms/admin/catjava.sql;

For Oracle 10g

Oracle JVM is enabled by default. No additional steps required.

iv. JAVASYSPRIV role is granted to system account

You can grant this role to system account by executing:

SQL> grant JAVASYSPRIV to system;

OBM will backup your Oracle database by taking the following steps.

i. Connect to the Oracle database using SQL*NET over TCP/IP

ii. Run all Pre-Commands of this backup set

iii. If the backup type to run is [Database Backup type],

a. all data files in each of the tablespace(s) selected are copied to the temporary directory specified by this backup set

b. if there are temporary files in the database, the script to re-create the temporary files are generated to a file located in the temporary directory specified by this backup set

c. all non-default initialization parameters will be spooled to an initializing file located in the temporary directory specified by this backup set

d. all control files will be copied to the temporary directory specified by this backup set

e. all archived log files will be copied to the temporary directory specified by this backup set

iv. If the backup type to run is [Archived Log Backup type],

a. all archived log files will be copied to the temporary directory specified by this backup set

v. Run all Post-Commands of this backup set

vi. Upload all files copied to the temporary directory to the Offsite Backup Server

vii. Remove temporary files from the temporary directory if [Setting] -> [Temporary Directory for storing backup files] is enabled

Note:

If your Oracle database is running on Windows, please install the online backup manager onto the company running the Oracle database

if the online backup manager is to backup this Oracle database. This would shorten the time required to backup the Oracle database.

Please follow the instructions below to backup your Oracle database to the Offsite Backup Server.

i. Install the online backup manager onto your computer

ii. Open the online backup manager

Right click the online backup manager icon available in the system tray and choose [Open]

iii. Create a backup set

a. From the Menu, Choose [Backup Set] -> [New] -> [Oracle Database Backup Set]

b. Enter a name for your backup set

c. Enter the system password, the Oracle Database Server Host Name, TNS Port and SID

d. Select the tablespace(s) you want to backup

e. Enter a temporary location to store the database file(s) before they are sent to an Offsite Backup Server

f. Set the backup schedule for database backup and archived log backup

Note: You can have more than one schedule in a backup set, i.e. you can perform intra-day transaction log backup by adding more than one daily transaction log backup schedule to your backup set.

g. Set the encryption algorithm, encryption mode and encrypting key for this backup set

Hint: For maximum security, please select AES (Advanced Encryption Standard) Algorithm, CBC (Cipher Block Chaining) mode and use an encrypting key with more than 8 characters.

iv. Run Backup

b. Select the backup type (e.g. Database Backup, Archived Log Backup) you would like to perform

c. Select [Off-site Backup Server] to start backing up your files to an Offsite Backup Server.

Please follow the instructions below to restore your Oracle 8i/9i databases from an Offsite Backup Server.

i. Download the backup files from the Offsite Backup Server Please refer to the [Quick Start - Backup File] section for information on how to download backup files from Offsite Backup Server.

ii. Put all data files back to their original locations

iii. Control files, data files and archived logs are stored on Offsite Backup Server along with their full path information. You just need to put all these files back to their original locations when performing a database restore.

iv. Put the PFILE back to its default location

Oracle 8i: $ORACLE_HOME/dbs/init<SID>.ora

Oracle 9i: $ORACLE_HOME/admin/<SID>/pfile/init.ora

v. Restore Database (if Oracle 8i) Use Server Manager to restore you database by doing the following:

a. Run Oracle Server Manager (svrmgrl)

b. Connect to the target database

c. Startup mount

d. Reapply all transactions from the archived log files

e. Open database

Oracle 8i Example:

ORACLE instance started.

Total System Global Area 95874448 bytes

Fixed Size 64912 bytes

Variable Size 52744192 bytes

Database Buffers 40960000 bytes

Redo Buffers 2105344 bytes

Database mounted.

ORA-00279: change 419671 generated at 06/14/03 02:51:49 needed for thread 1

ORA-00289: suggestion : /data/ora815/vin/archive/ARCH0000000225.LOG

ORA-00280: change 419671 for thread 1 is in sequence #225

ORA-00278: log file '/data/ora815/vin/archive/ARCH0000000224.LOG' no longer needed for this

recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Log applied.

. . . . . . . . . . .

ORA-00279: change 547222 generated at 06/18/03 19:58:26 needed for thread 1

ORA-00289: suggestion : /data/ora815/vin/archive/ARCH0000000384.LOG

ORA-00280: change 547222 for thread 1 is in sequence #384

ORA-00278: log file '/data/ora815/vin/archive/ARCH0000000383.LOG' no longer needed for this

recovery

ORA-00308: cannot open archived log '/data/ora815/vin/archive/ARCH0000000384.LOG'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

ORA-00279: change 547222 generated at 06/18/03 19:58:26 needed for thread 1

ORA-00289: suggestion : /data/ora815/vin/archive/ARCH0000000384.LOG

ORA-00280: change 547222 for thread 1 is in sequence #384

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Media recovery cancelled.

Statement processed.

(if Oracle 9i) Use Recovery Manager to restore you database by doing the following:

a. Run Oracle Server Manager (rman)

b. Connect to the target database

c. Startup mount

d. Reapply all transactions from the archived log files to the last sequence

e. Open database

Oracle 9i Example:

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database (not started)

connected to target database (not started)

Oracle instance started

database mounted

Total System Global Area 269556596 bytes

Fixed Size 453492 bytes

Variable Size 243269632 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

Starting recover at 24-JUN-03

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=11 devtype=DISK

starting media recovery

archive log thread 1 sequence 56 is already on disk as file

C:\ORACLE\ORADATA\VIN\ARCHIVE\1_56.DBF

archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_56.DBF thread=1 sequence=56

archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_57.DBF thread=1 sequence=57

archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_58.DBF thread=1 sequence=58

archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_59.DBF thread=1 sequence=59

archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_60.DBF thread=1 sequence=60

archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_61.DBF thread=1 sequence=61

archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_62.DBF thread=1 sequence=62

media recovery complete

Finished recover at 24-JUN-03

database opened