1 requirements, Better edge backup v5.2 – Deonet Backup Solutions 5.2.7.0 User Manual

Page 59

Better Edge Backup v5.2

User Guide

Page 59 of 121

(September 16, 2008)

Backup/Restore Oracle 8i/9i (Professional Version Only)

This chapter will describe in details how Better Edge Backup backup your Oracle 8i/9i and how you can restore an
Oracle 8i/9i database using the backup files.

9.1 Requirements

Better Edge Backup 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:

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

Switch to archived log mode

SVRMGRL> connect internal;
SVRMGRL> startup mount;
SVRMGRL> alter database archivelog;
SVRMGRL> alter database open;

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

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

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;