Backup/Resore Oracle 8i/9i

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

Requirements

JUSTBackupzOBM must be installed onto the computer that can connect to your Oracle 8i/9i server using TCP/IP protocol.
Data from Oracle 8i/9i database will be backed up to a temporary directory before they are sent to JUSTBackupz Offsite Backup Server. Please make sure you have sufficient space on your computer to store these data when you run the backup job.
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 archied 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;
Oracle JVM is enabled

To 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 20 MB in the PFILE, for example:

java_pool_size = 20971520
shared_pool_size = 52428800
Run the scripts below

JAVASYSPRIV role is granted to system accoun. You can grant this role to system account by executing;
SQL>grant JAVASYSPRIV to system;

Overview

JUSTbackupz will backup your Oracle database by taking the following steps.
1. Connect to the Oracle database using SQL *NET over TCP/IP
2. Run all Pre-Commands of this Backup set
3. If the backup type to run is [Database Backup Type]
1. all data files in each of the tablespace(s) selected are copied to the temporary directory specified by this backup set
2. if there are temporary files in the database, the script to re-create the temporary directory specified by this backup set
3. all non-default initialisation parameters will be spooled to an initialising file located in the temporary file
4. all control files will be copied to the temporary directory specified by this backup set
5. all archived log files will be copied to the temporary directory specified by this backup set
  1. If the backup type to run is [Archived Log Backup type] - all archived files will be copied to the temporary directory specified by this backup set
  2. Run all Post-Commands of this backup set
  3. Upload all files copied to the temporary directory to the Ahsay Offsite Backup Server
  Note:
  If your Oracle database is running on Windows, please install JUSTbackupzOBM onto the company running the Oracle database if JUSTbackupz is to backup this Oracle database. This would shorten the time required to backup the Oracle database.
  How to backup an Oracle Database
  
  Please follow the instructions below to back your Oracle database to the JUSTbackupz Offsite Backup Server.
  1. Install JUSTbackupz onto your computer
  2. Open JUSTbackupzOBM Right click JUSTbackupzOBM icon available in the system tray and choose [open]
  3. Create a backup set
  1. From the Menu, Choose [Backup Set] > [New] . {Oracle Database Backup Set]
  2. Enter a name for your backup set
  3. Enter the system password, the Oracle Database Server Host Name, TNS Port and SID
  4. Select the table space you want to Backup
  5. Enter a temporary location to store the database file(s) before they are sent to an JUSTbackupz Offsite Backup Server
  6. 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 transactionlog backup by adding more than one daily transaction log backup schedule to your backup set.
  7. Set the encryption algorithm, encryption mode and encrypting key for this backup set
  1. Run Backup
  1. Select the backup set you want to run on the left panel and press the [Start Backup] button
  2. Select the backup type (e.g. Database Backup, Archived Log Backup)you would like to perform
  3. Select {Offsite Backup Server] to start backing up your files to a JUSTbackupz Offsite Backup Server.
  How to restore an Oracle Database
  
  Please follow the instructions below to restore your Oracle 8i/9i databases from an Ahsay Offsite Backup Server.
  1. Download the backup files from the JUSTbackupz Offsite Backup Server - Please refer to the [Quick Start - Backup File] section for information on how to download backup files from JUSTbackupz Offsite Backup Server
  2. Put all data files back to their original locations
  3. Control files, data files and archived logs are stored on JUSTbackupz Offsite Backup Serve(OBS) along with their full path information. You just need to put all these files back to their original locations when performing a database restore
  4. Put the PFILE back to its default location
    Oracle 8i: $ORACLE_HOME/dbs/init.ora
    Oracle 8i: $ORACLE_HOME/admin./pfile/init.ora
6. Restore Database - (If Oracle 8i) Use Server Manager to restore your database by doing the following:
  1. Run Oracle Server Manager (svrmgrl)
  2. Connect to the target database
  3. Start mount
  4. Reapply all transactions from the archived log files
  5. Open database
  (If Oracle 9i) Use Recovery Manager to restore you database by doing the following:
  1. Run Oracle Server Manager (rman)
  2. Connect to the target database
  3. Startup mount
  4. Reapply all transactions from the archived log files to the last sequence
  5. Open database

Client Web login

FREE 14 days Trial

Backup/Resore Oracle 8i/9i

Requirements

How to restore an Oracle Database