Primary and secondary storage configuration and topology

01/29/2021 Contributors

In this example, the TechCo corporation runs its payroll database on a database server that is also a SnapManager for Oracle host and stores its payroll database data and configuration files on primary storage systems at company headquarters. The corporate requirement is to protect that database with daily and weekly backups to local storage as well as backups to storage systems at a secondary storage site fifty miles away.

The following illustration shows the SnapManager for Oracle and the NetApp Management Console data protection capability components required to support local and secondary backup protection.

This figure displays the components associated with a combined SnapManager for Oracle and Management Console database protection architecture

To manage the payroll database and support its local and secondary backup protection as illustrated in the previous graphic, the following deployment is used.

SnapManager host

The SnapManager host, payroll.techco.com, is located at company headquarters and runs on a UNIX server, which also runs the database program that generates and maintains the payroll database.
- Connections
  
  To support local backup and secondary backup protection, the SnapManager host has network connections to the following components:
  - SnapManager for Oracle client
  - SnapManager repository, which runs the database program, SnapDrive for UNIX, and SnapManager
  - Primary storage systems
  - Secondary storage systems
  - DataFabric Manager server
- Installed products
  
  The SnapManager host is installed with the following products for this example:
  - SnapManager server
  - SnapDrive for UNIX
  - Host Utilities
TechCo primary storage systems

The payroll database, including associated data files, log files, and control files, reside on the primary storage systems. These are located at TechCo company headquarters along with the SnapManager host and the network connecting primary storage and the SnapManager host. The latest payroll database transactions and updates are written to the primary storage systems. Snapshot copies, which provide local backup protection of the payroll database, also reside on the primary storage systems.
- Connections
  
  To support secondary backup protection, the primary storage systems have network connections to the following components:
  - SnapManager host running the database program, SnapDrive for UNIX, and SnapManager
  - Secondary storage systems
  - DataFabric Manager server
- Installed products
  
  The following licenses must be enabled on these systems for this example:
  - Data ONTAP 7.3.1 or later
  - SnapVaultData ONTAP Primary
  - FlexVol (required for NFS)
  - SnapRestore
  - NFS protocol
TechCo secondary storage systems

The secondary storage systems, located at a network-connected secondary storage site fifty miles away, are used to store secondary backups of the payroll database.
- Connections
  
  To support secondary backup protection, the secondary storage systems have network connections to the following components:
  - Primary storage systems
  - DataFabric Manager server
- Installed products
  
  The following licenses must be enabled on the secondary storage systems for this example:
  - Data ONTAP
  - SnapVaultData ONTAP Secondary
  - SnapRestore
  - FlexVol (required for NFS)
  - NFS protocol
DataFabric Manager server

The DataFabric Manager server, techco_dfm, is located at company headquarters in a location accessible by the storage administrator. The DataFabric Manager server, among other functions, coordinates the backup tasks between primary and secondary storage.
- Connections
  
  To support secondary backup protection, the DataFabric Manager server maintains network connections to the following components:
  - NetApp Management Console
  - Primary storage systems
  - Secondary storage systems
- Installed products
  
  The DataFabric Manager server is licensed for the following server products for this example:
  - DataFabric Manager
SnapManager repository

The SnapManager repository, located on a dedicated server, stores data about operations performed by SnapManager, for example the time of backups, tablespaces and datafiles backed up, storage systems used, clones made, and Snapshot copies created. When a DBA attempts a full or partial restore, SnapManager queries the repository to identify backups that were created by SnapManager for Oracle for restoration.
- Connections
  
  To support secondary backup protection, the secondary storage systems have network connections to the following components:
  - SnapManager host
  - SnapManager for Oracle client
NetApp Management Console

The NetApp Management Console is the graphical user interface console used by the storage administrator to configure schedules, policies, datasets, and resource pool assignments to enable backup to secondary storage systems, which are accessible to the storage administrator.
- Connections
  
  To support secondary backup protection, NetApp Management Console has network connections to the following components:
  - Primary storage systems
  - Secondary storage systems
  - DataFabric Manager server
SnapManager for Oracle client

The SnapManager for Oracle client is the graphical user interface and command line console used by the DBA for the payroll database in this example to configure and carry out local backup and backup to secondary storage.
- Connections
  
  To support local backup and secondary backup protection, SnapManager for Oracle client has network connections to the following components:
  - SnapManager host
  - SnapManager repository, running the database program, SnapDrive for UNIX, and SnapManager
  - Database host (if separate from the host running SnapManager)
  - DataFabric Manager server
- Installed products
  
  To support local backup and secondary backup protection, the SnapManager for Oracle client software must be installed on this component.

Primary and secondary storage configuration and topology

Creating your file...