[go: up one dir, main page]

0% found this document useful (0 votes)
2 views18 pages

BackupandDR v3.4

The document outlines Oracle's product direction regarding database backup and disaster recovery solutions using Oracle Cloud. It emphasizes that the information is for informational purposes only and is subject to change, advising consultation with sales and technical representatives for specific proposals. Key technologies discussed include Active Data Guard and GoldenGate for data protection and replication strategies.

Uploaded by

Vfsss Vfsss
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
2 views18 pages

BackupandDR v3.4

The document outlines Oracle's product direction regarding database backup and disaster recovery solutions using Oracle Cloud. It emphasizes that the information is for informational purposes only and is subject to change, advising consultation with sales and technical representatives for specific proposals. Key technologies discussed include Active Data Guard and GoldenGate for data protection and replication strategies.

Uploaded by

Vfsss Vfsss
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 18

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes
only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code,
or functionality, and should not be relied upon in making purchasing decisions. The development,
release, timing, and pricing of any features or functionality described for Oracle’s products may change
and remains at the sole discretion of Oracle Corporation.

Statements in this presentation relating to Oracle’s future plans, expectations, beliefs, intentions and
prospects are “forward-looking statements” and are subject to material risks and uncertainties. A detailed
discussion of these factors and other risks that affect our business is contained in Oracle’s Securities and
Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q
under the heading “Risk Factors.” These filings are available on the SEC’s website or on Oracle’s website
at http://www.oracle.com/investor. All information in this presentation is current as of September
2019 and Oracle undertakes no duty to update any statement in light of new information or future events.
Este documento tiene la única intención de esbozar a grandes rasgos las “soluciones” de backup y
respaldo usando Oracle Cloud y la información que al equipo comercial nos parece más destacable para
entenderlas mejor, a la fecha del documento.

Recomendamos consultar con el representante comercial y técnico al iniciar cualquier propuesta


concreta sobre estas soluciones, para que validarla en ese momento con los servicios disponibles.
Oracle Database Specific Technologies

Copyright © 2021, Oracle and/or its affiliates.


Database Cloud Backup Module

• Simulates a tape backup storage device for


RMAN to use to backup the source database
to Oracle Cloud Infrastructure Object Storage.
Database Strategies for DR

• Active Data Guard


Provides data protection and
availability for Oracle Database
in a simple and economical
manner by maintaining an
exact physical replica of the
production copy at a remote Active Data Guard
location that is open read-only
while replication is active.
Database Strategies for DR

• GoldenGate
• Enables advanced logical
replication that supports
multi-master replication,
hub and spoke deployment,
and data transformation.
• Provides customers flexible
options to address the
complete range of
replication requirements,
including heterogeneous
hardware platforms.
I.-Database Backup to Oracle Cloud

Copia de seguridad directamente en la nube – OCI


Archivo ZDLRA en el almacenamiento de objetos OCI
Object Storage

Option 1 – Faster restore Option 2 – Long term archival


Customer Cloud Region Customer Datacenter Cloud Region
Datacenter
1 month < 1 year
1 week – 1 year
retention retention
retention

Cloud
Local Cloud Local Local Cloud
Archive
Database Backup Database Backup Backup
Backup
I.- Database Backup to Oracle Cloud
CONSIDERACIONES
• Oracle Database Versions soportadas
(EE,SE,SE1,SE2)
• Documentacion official
• Supported Platforms (64-bit) : Linux,
Solaris, SPARC, Windows, HP-UX, AIX,
zLinux
• Requiere JDK version 1.7 or higher
II.- Backup + Recover/Test/Dev DB in Oracle Cloud
Customer Datacenter *CloudBackup cannot be appliedCloud Region
to DBCS in case of Onpremise Big
Endian DB

Cloud Backup
Clones

Production
Test/Dev
Database
Databases
II.- Backup + Recover/Test/Dev DB in Oracle Cloud
CONSIDERACIONES
• Replique su base de datos local en
entornos de prueba y desarrollo en la nube
• Link https://docs.oracle.com/en-
us/iaas/Content/Database/Tasks/recoverin
gOS.htm#Recovering_a_Database_from_Obj
ect_Storage

• Para la recuperación de un backup en


cloud creado a partir de una plataforma
que no sea Oracle Linux, hay bastante
documentación pero ninguna guía
estricta de como hacerlo. Dejamos aquí
algunos enlaces de referencia:

• Link Doc ID 2013271.1 (RMAN with to


PLATFORM)
• Doc ID 2013271.1
• Link https://docs.oracle.com/en-
us/iaas/Content/Database/Tasks/recoveringOS.ht
m#Recovering_a_Database_from_Object_Storage
III.- Database Disaster Recovery - Data Guard Architecture
Oracle Database Enterprise Edition
III.-Database Disaster Recovery - Data Guard Architecture
Oracle Database Enterprise Edition • Dataguard debe respetar una estructura simétrica a nivel
de base de datos entre on premise y cloud

• Compatibilidad en Data Guard entre arquitecturas de


computación:
https://support.oracle.com/epmos/faces/DocumentDispl
ay?_afrLoop=425273798097123&id=413484.1&_adf.ctrl-
state=2n7hr8un_52

• Nota respecto a necesidad de encriptación y TDE:


Oracle Database Tablespace Encryption Behavior in Oracle
Cloud (Doc ID 2359020.1)

https://www.oracle.com/technetwork/database/availabili
ty/hybrid-dg-to-oci-5444327.pdf

*En el caso de no poder encriptar la base de datos on


premise (primary), se tendrá en cuenta que si se produjera
cualquier cambio de roles entre onprem y cloud (standby),
no se debería crear ningún tablespace nuevo durante el
tiempo de cambio; de lo contrario, el tablespace se crearía
encriptado y no se podría revertir a la situación inicial.
GoldenGate Architecture (Microservices)
Customer On-Premises Site 1 Customer On-Premises Site 2

GoldenGate GoldenGate
Source Installation Installation Target Key Points
• New Microservices
Architecture
• Support for REST-enabled
Performance Administration Administration Performance services
Metrics Server Server Server Metrics Server • Can be configured using
4 HTML interface
Network • Cloud Compatible
1 Service Receiver Distribution Service 7 • Distribution Server replaces
Manager Server Server Manager
classic Data Pumps
• Receiver replaces Collectors
Extract 4 Replicat • Bi-directional replication
Distribution Receiver needs Distribution and
Server Server
Trail Files Trail Files Receiver on both sites
• Supports only Oracle
2 3 5 6 Database

Source Deployment Target Deployment


GoldenGate Hub Architecture
GoldenGate Hub

Oracle Client Key Points


19c • Offloads processing from
GoldenGate individual database servers
Oracle Client
Installation 19c
• Centralized GoldenGate
12c Rel 2 GoldenGate installations
Deployment
GoldenGate • No Receiver and Distribution
Installation 12c Servers needed for
GoldenGate Service unidirectional replication
Manager
Deployment
• Cloud Compatible
• Hub must be close to Target
Source Administration Administration Target
Database Server Server Database database for uni-directional
replication <5ms
• For bi-directional
Extract Replicat
Trail Files
replication, two hubs are
needed
Performance Performance
Metrics Server Metrics Server
IV.-Database Replication - GoldenGate Hub Architecture
Unidirectional Replication

Customer Datacenter Cloud Data Center


AD2 AD1 AD1 AD2 AD3

GG
Replication

Local backup Local


Standby Primary GG Hub Primary Standby backup

GG Hub needs to be closer to the Target Database


IV.- Database Replication - GoldenGate Hub Architecture
Unidirectional Replication
• Escenario de replica UNIDIRECCIONAL en
tiempo real entre on premise y cloud tanto para
Oracle Database Enterprise Edition como para
Oracle Database Standard Edition

• Link a la Matriz de certificación de plataforma

• GG Hub se corresponde en cloud con el servicio


OCI Golden Gate

GG Hub needs to be closer to the Target


Database
V.-Database Disaster Recovery - GoldenGate Hub Architecture
Bidirectional Replication

Customer Data Center Cloud Data Center

AD3 AD2 AD1 AD1 AD2 AD3

GG
Replication

Local
Local
Standby Primary GG Hub Primary Standby backup
backup
GG
Replication

GG Hub

GG Hub for the customer Data Center needs to be manually configured


V.-Database Disaster Recovery - GoldenGate Hub Architecture
Bidirectional Replication

• Escenario de replica bidireccional, entre on


premise y cloud tanto para Oracle Database
Enterprise Edition como para Oracle Database
Standard Edition

• Adecuado para escenarios de Disaster


Recovery

• Link a la Matriz de certificación de plataforma

• GG Hub en Cloud Data Center se corresponde


con el servicio OCI Golden Gate

• GG Hub en Customer Data Center se


corresponde con licencias de Golden Gate

You might also like