Oracle Backup and Restore

Ahsay brings you specialized client backup software, namely AhsayOBM, to provide a comprehensive backup solution for your Oracla Database Server. The Oracle Database Server module of AhsayOBM provides you with a set of tools to protect your Oracle Server with both full database and archived log backups while your database is online.

We recommend you read both the GUI and CLI segments of the Overview sections. This will help you become familiar with the different functions, settings, and features that can be configured in AhsayOBM. It will also be helpful to know the different features that can be customized in the backup set before creating one.

This guide will mainly focus on how to create and restore an Oracle Database backup set. There are different ways to be used in creating, running, and restoring the Oracle Database backup set; one is by using AhsayOBM as backup client software on Windows and Linux GUI mode, and the other one is by using Linux CLI mode.

This guide will only focus on:

  • How to create an Oracle Database backup set
  • How to run a backup job
  • How to recover an Oracle backup

Run on Client (Agent-based) Backup

Below is the system architecture diagram illustrating the major elements involved in the backup process among the Oracle Server, AhsayOBM, and AhsayCBS.

In this user guide, we will focus on the end-to-end backup and restore process using AhsayOBM as a client backup software.

success

Ahsay Oracle database and archived log backups use a spooling method to make a consistent snapshot of the database for backup.

For each database backup job, AhsayOBM will trigger Oracle to spool or make a copy of the following files to the temporary folder:

  • Database files (.DBF)
  • Archived Log files
  • Control files (.CTL)
  • Init.ora file

success

The following steps are performed during an Oracle Server backup job in Database and Archived Log backup modes.

For an overview of the detailed process for Steps 3, 5, 11, and 14, please refer to the GUI and CLI sections of the File Backup and Restore section.

  • Periodic Data Integrity Check (PDIC) Process (Step 3)
  • Backup Set Index Handling Process
    • Start Backup Job (Step 5)
    • Completed Backup Job (Step 14)
  • Data Validation Check Process (Step 11)

Database Backup Process

success

Archive Log Backup Process

success