Link Menu Expand (external link) Document Search Copy Copied

Oracle

Veeam Backup and Replication application-aware processing capability supports backup of virtual or physical machines running Oracle database server.

Oracle backup workflow

Oracle on Linux backup workflow

  1. Coordination component which will perform all the necessary steps is injected into the guest VM. This component is the same as the one used for Linux application-aware image processing in general.
  2. Perform application discovery. This is done using native OS methods, Veeam process queries /etc/oraInst.loc and reads inventory.xml which is then compared to /etc/oratab information.
  3. Status and version of instance(s) is fetched.
  4. Disk group information is retrieved for ASM instances.
  5. Log mode is identified, this information will later be used for decisions on how exactly the database has to be processed. Database files, CDB (for Oracle 12 and later) and current DBID information is retrieved.
  6. At this step necessary archive log information was collected and Veeam will start doing actual backup, modifying database state - current archive log is archived and all archive log information is retrieved.
  7. PFILE backup is created and archived into the backup metadata.
  8. Additional information is collected and recorded (current DBID, SCN, Sequence IDs, database unique name, domain, recovery file destination, basic listener information and current archive log).
  9. Coordination component is shut down and then restarted again to finalize the backup: database is put into backup mode and database snapshot is created.

Oracle on Windows backup workflow

Behavior on Windows depends on the state of VSS writer, Oracle version and database type.

  With Oracle VSS writer Without Oracle VSS writer Pluggable database
Oracle 11 Oracle VSS writer is engaged, NOARCHIVELOG databases are shut down and excluded from VSS processing Same worflow as for Linux N/A
Oracle >= 12 Oracle VSS writer is engaged, NOARCHIVELOG databases are shut down and excluded from VSS processing Same worflow as for Linux Same workflow as for Linux, VSS writer is skipped

Restore workflow

When performing restore Veeam Explorer follows the following steps:

  1. Oracle instance/database discovery is performed and information is collected, that includes path validation and disk space availability checks.
  2. VM disks are mounted.
  3. Target database is shut down and dropped, configuration is cleaned (configuration and temporary instance files).
  4. Database is started from the temporary location, if that fails another restore attempt is performed with safe set of parameters.
  5. After successful test start from temporary location database is restored to proper location using automatically generated RMAN script.
  6. Restore control files are restored after that. Database is updated to specific transaction prior to that in case point in time was selected for restore.
  7. Fast Recovery Area parameters are restored and database is upgraded accordingly if restoring 32-bit instance to 64-bit.
  8. To finalize restore mounted backup is removed from RMAN repository, restored database is restarted and new DB ID is generated. Remaining bits of the configuration are restored as well - parameter file is restored to proper path along with password file, DBNAME is changed if needed, logs are reset and online logs are recreated.

References


Back to top

Copyright © 2023 Solutions Architects, Veeam Software.