Better Edge Backup v5.2
User Guide
Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved.
Page 59 of 121 (September 16, 2008)
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
i. Better Edge Backup must be installed ont o 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 u p 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 au tomatic log archiving, please do the following:
a. Set the parameters below in the PFILE to enabl e automatic archiving
log_archive_dest = [directory where archived log s 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. N o 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;