Performing backups of Oracle Databases on Datto SIRIS is easy

by | Jul 13, 2012 | Business Continuity

What you need to know about performing backups of Oracle Databases on Datto SIRIS

Today’s blog post provides simple, step-by-step direction on performing backups of Oracle Databases on Datto SIRIS. Specifically, it covers the topic of how to ensure the ShadowSnap Agent for Datto SIRIS provides application aware backups during VSS operations for Oracle databases.

Prerequisites
  • • Starting with Oracle 10g Patch Set version 10.2.0.3 the “Oracle VSS Writer” Service can be installed to provide application consistent backups of the Oracle Database.
    • • For “Oracle 10g Database for Windows” please visit Oracle’s KB for instructions for installing the Oracle VSS Writer for installations of “Oracle 10g for Windows” by clicking here.
  • • Starting with “Oracle 11g for Windows” the Oracle VSS Writer Service is installed by default.
  • • For an Oracle Database running in NOARCHIVELOG, the database must be in a consistent state when you create a VSS snapshot. Backups made while the database is open read/write are not supported.
  • • Microsoft Shadow Copy’s VSS Writers of the protected machine must be in a healthy state for it’s “Application Aware VSS Backup Engine” to perform a backup.

 Determining if the Oracle VSS Writer is operational on the production machine

  • • The Oracle VSS Writer does not appear when using the command “vssadmin list writers” as it simply injects itself into the metadata of the “System Writer”.
  • • The Oracle VSS Writer is displayed in services.msc as “Oracle ORCL VSS Writer Service”.  
Please note: This service should only be in a running state while a backup is in progress.


OracleVSSService.JPG

     Example: Oracle VSS Writer Service in services.msc displayed while no backups are currently in progress.

  • The local Datto Siris Web Console also displays the Oracle VSS Writer as a VSS Writer that may be excluded manually under the “Advanced Options” page for the agent.
YOU MIGHT ALSO LIKE:  How to Stop Cyber Extortion with Datto Ransomware Protection

 

VSSWritersListed.JPG

Example: Oracle VSS Writer as displayed in the Datto SIRIS Web Console’s Advanced Options page

What the ShadowSnap Agent and the Datto SIRIS can perform when the Oracle VSS Writer is installed

  • • With “Oracle VSS Writer” service installed the ShadowSnap Agent will have the ability to take a Shadow Copy of the volume(s) using the “Application Aware VSS” Backup Engine.
  • • The “STC Backup Engine” is not application aware and is provided as a fail-safe backup engine capable of taking Shadow Copies in a crash-consistent state.
  • • Backups taken by the Datto SIRIS can then be shared by performing a File Restoration on the local network for any Oracle Database Recovery Tools to be used.

 

For further assistance on performing backups of Oracle Databases on Datto SIRIS, please contact Invenio IT Support.

Dale Shulmistra is a Business Continuity Specialist at Invenio IT, responsible for shaping the company’s technology initiatives — selecting, designing, implementing & supporting business continuity solutions to bolster client operational efficiencies and eliminate downtime.

subscribe

Business Continuity Newsletter

Join over 17,000 subscribers and receive weekly business continuity news, tips & advice to protect your business.

You have Successfully Subscribed!