rmoug training days 2018 - amazon s3...disk pool: a file-system directory that stores backups. disk...

RMOUG Training Days 2018

OEM On-Prem for Hybrid and Cloud Backup and Recovery

Linda Seley, ArisantKaren Laine, Arisant

Agenda

• Introductions

• On-prem Backup

• Oracle Cloud Infrastructure Storage Software Appliance

• Hybrid Cloud Backup

• Oracle Public Cloud Backup

• Q&A

OEM On-Prem for Hybrid and Cloud Backup and Recovery

Founded in 2006 by, Arisant focuses on understanding business requirements to ensure the most effective implementation of the right solution

Our strategy is aimed at providing an honest and expert brand of consulting services for both the Private & Public Sectors

Arisant Overview

• HQ’d in Englewood, CO• Flexibility to Deliver across the World• Oracle Technology Focused

Managed Services➢ Database Administration➢ O/S System Administration➢ Middleware Administration➢ Storage Administration➢ Engineered System administration

Consulting Services➢ Architecture➢ Analysis➢ Design➢ Implementation➢ Project Management

Staffing/Support

Managed Cloud Services

Managed Hosting Services

Arisant Services

Identity & Access

Management

Business Intelligence

Managed Services

On-Premise Backup and Restore

• Database

• OS

Database backups:

Options:

1. Setup and schedule for each instance

2. Create groups of instances and configure and schedule backups for the entire group

Database backups, cont..:

Option 1: Configure backups for each individual database

Database backups, cont..:

Option 1: Schedule backup for each individual database

Database backups, cont..:

Option 2: Configure backups for a group of databases

Database backups, cont..:

Option 2 cont..:

Database backups, cont..:

Option 2 cont..:

Database backups, cont.:

Option 2 cont.:

Database backups, cont.:

Option 2 cont.:

Database backups, cont.:

Option 2 cont.:

OS backups:

Oracle Secure Backup+ Oracle Enterprise Manager

http://www.oracle.com/technetwork/database/availability/osb-12-1-overview-2420295.pdf

OSB Terminology (**):

Admin domain:A group of computers on your network that you manage as a common unit to perform backup and restore operations. An administrative domain must include one and only one administrative server. It can include the following:• One or more clients• One or more media serversAn administrative domain can consist of a single host that assumes the roles of administrative server, media server, and client.

Client:Any computer or server whose files Oracle Secure Backup backs up or restores.

Media Server:A computer or server that has at least one tape device or disk pool connected to it. A media server is responsible for transferring data to or from the devices that are attached to it.

OSB Terminology, cont..:

Disk Pool: A file-system directory that stores backups. Disk pools can be accessed concurrently by multiple backup or restore jobs.

Dataset:The contents of a file-system backup. A dataset file describes a dataset. For example, you could create the dataset file my_data.ds to describe a dataset that includes the /home directory on host myhost2.

Media Family:A named classification of backup volumes that share the same volume sequence file, expiration policy, and write window.

**http://docs.oracle.com/cd/E16926_01/doc.121/e16564/glossary.htm#OBADM831

OSB Integration with OEM:

After installing admin domain, add OSB as a target to OEM

OSB Integration with OEM, cont.:

This is what the main OSB target page looks like

OSB Integration with OEM, cont.:

Scheduling a backup:

Oracle Cloud Infrastructure Storage Software Appliance (OSCSA)

• Server Requirements

– 4-core CPUs Linux 7.4 or later

– 16-64GB memory Docker 1.12.6

– 300G disk open ports in firewall

Oracle Cloud Infrastructure Storage Software Appliance (OSCSA)

• Metadata

• Cache

– Read Cache

– Upload Buffer

• Logs

Oracle Cloud Infrastructure Storage Software Appliance (OSCSA)

• Metadata

• Cache

– Read Cache

– Upload Buffer

• Logs

OSCSA

OSCSA

OSCSA

OSCSA

mount -t nfs -o vers=4,port=9001 ol74s:/fs_bkup /mnt/fs_bkup

IaaS: Backups

Oracle Cloud Infrastructure Storage Software Appliance – Cloud Distribution+ Oracle Secure Backup+ OEM

High Level Steps:

1. Download Appliance Image from http://www.oracle.com/technetwork/topics/cloud/downloads/index.html2. Upload image to Compute -> Images and associate Image3. Complete all networking setup 4. Provision VM using the private image (either using the provisioning tool or through the web service console)5. Login to Appliance Console through browser6. Create filesystem7. Mount NFS on VM you want to backup8. Use OEM/RMAN to backup the database to NFS9. Use OEM/OSB to backup filesystems

IaaS: Backups

After provisioning the appliance, create a filesystem using the console:

IaaS: Backups

Storage Containers:

IaaS: Backups

Storage Containers:

VM with OSB – mount filesystem as NFS

OSB Disk Pool Definition

OSB Job Properties

OSB backup files:

Appliance Host level directory listing:

IaaS: Backups

backup01 Container Contents:

IaaS: Backups

backup01-archive Container Contents:

Hybrid Cloud Backups

• OEM

• Oracle Database Backup Service

Download opc_install.zip from

http://www.oracle.com/technetwork/database/availability/oracle-cloud-backup-2162729.html

java -jar opc_install.jar

-host https://a49****.storage.oraclecloud.com/v1/Storage-a49****

-identityDomain arisantpoc

-opcId 'linda.seley@arisant.com’

-opcPass ‘******’

-walletDir /home/oracle/opc/wallet

-libDir /home/oracle/opc/lib

Oracle Database Backup Service

RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt

PARMS='SBT_LIBRARY=/u01/app/oracle/product/12.1.0.2/dbhome_1/lib/libopc.so,

SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/opcorcl.ora)’;

• Password encryption

• Transparent Data Encryption (TDE)

• Dual-mode encryption (password encryption and TDE)

Oracle Database Backup Service

Oracle Public Cloud Backups

• IaaS

• DBCS

IaaS: Backups

There are multiple options – all managed through OEM:

Database backups:1. Backup to local storage on the IaaS host2. Use the Oracle Cloud Infrastructure Storage Software Appliance (Cloud) to mount an NFS and backup the

database to the NFS3. Use Oracle Database Backup Service

OS backups:1. Snapshots (point in time)2. OSB combined with OEM and Oracle Cloud Infrastructure Storage Software Appliance (Cloud)

IaaS: Backups, cont

Integrating OEM with Cloud hosts:

Steps:

1. Configure an on-premise management agent as a Gateway agent2. Validate connectivity and ssh key setup between the gateway agent host and the cloud host(s)3. Define credentials in OEM4. Deploy agent to cloud host(s)

IaaS: Backups, cont

Example: deploy agent

IaaS: Backups, cont

** Note the checkbox for “Configure Hybrid Cloud Agent”

DBCS: Backup and Recovery

Single instance options:

RAC options:

DBCS: Backup and Recovery

From https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/backing.html

DBCS: Backup and Recovery, cont

Backups and restores can be run using either the command line or the UI.

Single instance command line tools:bkup_apidbaascli

Backups are scheduled in /etc/crontab and run bkup_api as root:

DBCS: Backup and Recovery, cont

RAC instance command line tool:raccli

Backups are scheduled in root’s crontab and run raccli:

DBCS: Backup and Recovery, cont

DBCS Console:

DBCS: Backup and Recovery, cont

What gets backed up:• Database Files• System File Backups

• /home/oracle/bkup/oscfg.spec (non-RAC) or /opt/oracle/dcs/rdbaas/config/oscfg.spec (RAC)• Database Configuration File Backups

• /home/oracle/bkup/dbcfg.spec (non-RAC) or /opt/oracle/dcs/rdbaas/config/dbcfg.spec (RAC)• Grid Configuration File Backups

• /opt/oracle/dcs/rdbaas/config/gicfg.spec (RAC only)

DBCS: Backup and Recovery, cont

Viewing configuration – single instance:

DBCS: Backup and Recovery, cont

Viewing configuration – rac instance:

DBCS: Backup and Recovery, cont

Example cfg file contents:

DBCS: Backup and Recovery, cont

Example cfg file contents:

DBCS: Backup and Recovery, cont

Example cfg file contents:

DBCS: Backup and Recovery, cont

• Common tasks:• Change configuration settings

• OS config files to backup• DB config files to backup• GI config files to backup (RAC)• Recovery window• Schedule

• Run on demand backups• Run a backup with « keep forever » option• Restore database from backup• Restore config files from backup

DBCS: Backup and Recovery, cont

On demand backups - console

DBCS: Backup and Recovery, cont

On demand backups – command line

Run a backup Single instance: /var/opt/oracle/bkup_api/bkup_api bkup_start

RAC instance: raccli create backup

Run a long term backup:Single instance: /var/opt/oracle/bkup_api/bkup_api bkup_start –-keep -–tag=170925

RAC instance: raccli create backup –tag 170925

DBCS: Backup and Recovery, cont

Recovery - Cloud Service Console:

DBCS: Backup and Recovery, cont

Recovery – dbaascli• Latest backup, a specific backup, a specific point in time, specific scn

DBCS: Backup and Recovery, cont

Recovery – raccli• Latest backup, a specific backup, a specific point in time, specific scn

DBCS: Backup and Recovery, cont

Recovery – config files

If you use dbaascli or racli to restore config files, the database instance will be shutdown and all config files will berestored

DBCS: Backup and Recovery, cont

Recovery – config files

If you just need a single file (e.g. sqlnet.ora) restored, pull it directly from the storage container

DBCS: Backup and Recovery, cont

Recovery – config files

If you just need a single file (e.g. sqlnet.ora) restored, pull it directly from the storage container

DBCS: Backup and Recovery, cont

Integration w/OEM:• Use hybrid cloud agent• View only unless you chose « none » for the automatic backup configuration

DBCS: Backup and Recovery, cont

Integration w/OEM, cont

References:

Oracle Cloud Infrastructure Storage Software Appliance:

https://docs.oracle.com/en/cloud/iaas/storage-cloud/cssgu/getting-started-oracle-cloud-infrastructure-storage-software-appliance.html

https://docs.oracle.com/en/cloud/iaas/storage-appliance-cloud/sfsug/getting-started.html

Oracle Secure Backup:https://www.oracle.com/database/secure-backup/index.html

http://www.oracle.com/technetwork/database/availability/osb-12-1-datasheet-2420469.pdf

http://docs.oracle.com/cd/E16926_01/index.html

Integration w/OEM:http://docs.oracle.com/cd/E16926_01/doc.121/e16563/osb_interfaces.htm#OBINS198

References, cont.:

Oracle Database Backup Service:https://docs.oracle.com/en/cloud/paas/db-backup-cloud/index.html

Oracle Database Backup Service - FAQ (Doc ID 1640149.1)

OEM Hybrid Cloud:

https://docs.oracle.com/cd/E73210_01/EMADM/GUID-5D80BFCD-AA60-4805-89EE-26B4C1E9E4B0.htm#EMADM15141

Hybrid cloud agent work flow and important configurations (Doc ID 2104237.1)

References, cont.:

DBCS Backups:

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/back-and-recover.html

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/backing.html

Know More About the Backup Strategy Used in Database Cloud Backup and the Backup Size (Doc ID 2205674.1)

How To Check The Status, Input File Sizes Backed Up And The Location Of Database Backup In Oracle Database Cloud (Doc ID 2205127.1)

Questions?