3 - availability 12c

8/10/2019 3 - Availability 12c

1/60

1 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Maximize Availability WithOracle Database 12c

Darl [email protected]


2/60


HA?


3/60


HA?


4/60


Oracle Database 12c: Extreme Availability Oracle Database 12c introduces significant new (HA) ca

Drastically cutdown planned and unplanned downtime

Eliminate compromisesbetween HA and Performance

Tremendously boostoperational productivity

These take Availability to unprecedented new levels

Next-generation Maximum Availability Architecture (MAA)

Optimized for Oracle


5/605 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Maximum Availability Architecture

Active Da

Data Pro

Query Of

GoldenGActive-ac

Heteroge

RMAN, OracBackup to ta

Active

Edition-based Redefinition,Online Redefinition, Data Guard, GoldenGateMinimal downtime maintenance, upgrades, migrations

RAC

Scalability

Server HA

FlashbackHuman error

correction

Production Site Application ContinuityApplication HA

Global Data ServicesService Failover / Load Balancing


6/606 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Oracle Database 12cHigh Availability Key New Features

Application Continuity Global Data Services

Data Guard Enhancements

RMAN Enhancements

Flex ASM Other HA Enhancements

GoldenGate Update


7/60


Database outages canflight work to be lost, leusers and applications

Often leads to

User pains

Duplicate submiss Rebooting mid-tie

Developer pains

In-Flight Work: Dealing With OutagesCurrent Situation

ApplicationServers

DatabaseServers

End User


8/60


Solving Application Development Pain

Transaction Guard

A reliable protocol and API

that returns the outcome ofthe last transaction

New in Oracle Database 12c

Application Contin

Safely attempts to rep

flight work following oand planned operat


9/60


Transaction GuardPreserve and Retrieve COMMIT Outcome

API that supports kn

outcome for every tr Without Transaction

failurestransactioncause logical corrup

With Transaction Guapplications can deawith error situations,improving end-user

Used transparently bApplication Continui

ApplicationServers

DatabaseServers

End User


10/60


Application ContinuityMasks Unplanned/Planned Outages

Replays in-flight workrecoverable errors

Masks many hardwarnetwork, storage errowhen successful

Improves end-user exproductivity without recustom app developm

Transaction Replayed

ApplicationServers

DatabaseServers

End User


11/60





RMAN Enhancements


GoldenGate Update


12/60


Databases in Replicated EnvironmentsChallenges

No seamless way to euse all the databases

No automated load baand fault tolerance

Primary

Active Standby

Active Standby

GoldenGate


13/60


Global Data Services


Extends RAC-style service f

balancing (within and acrosscenters), and managementa set of replicated database

Takes into account network replication lag, and service p

policies Achieve higher availability, i

manageability and maximizeperformance

Load Balancing and Service Failover for Replicated Datab


14/60



Reporting client routed to b

Based on location, response time,data lag

Reports will automatically run on le

Reporting client failover If preferred database not available

another database in same region

database

Global service migration Automatically migrates services ba

failover/switchover - if primary datCall Center service on the new pri

Active Data Guard Example

Active Data Guard

Reporting Service

Call Center Service


15/60



Call Center Client connectiorequests transparently routeclosest/ bestdatabase

Runtime load balancing metrics givinformation on which database to is

If a database fails, its global restarted on another replica

GoldenGate Example

GoldenGate

Call Center Service



16/60


Global Data ServicesUse Case: Active Data Guard without GDS

Primary Active Standby

Data Guard

Order History ViewOrder Capture

Critical E-Commerce App accessingActive Data Guard Standby

What happens whenActive Standby is down?

Orders

Service

History

Service

Primary

Data Guard

OrOrder Capture

Orders

Service


17/60


Global Data ServicesUse Case: Active Data Guard with GDS: All HA

When Active Standby is down GDS fails over History Service

to primary, redirectsconnection through FAN/FCF

Primary Active Standby

Data Guard

Orders

Service

History

Service


Order HistView

OrderCapture

History

Service


18/60



Load-balancing of application workloads across regionsoptimal resource utilization

Extends RAC-like connect time & run time load balanci

Elastically add/remove databases from the GDS infrast

Supports seamless service failover

Easier management for globally distributed multi-databconfigurations


19/60





RMAN Enhancements


GoldenGate Update


20/60


Zero Data Loss Challenge

The longer the distance, the larger the performance impac

Synchronous Communication Leads To Performance Trad

Primary S

Commit

Commit Ack

Network Send

Network Ack

Data Guard Async Today


21/60


PrimaryASYNC

Data Guard Async TodaySome Data Loss Exposure Upon Disaster

Active Data Guard Far Sync New in 1


22/60


Far Sync: light-weight Oracle instance: standby control fredo logs, archived redo logs, no data files

Receives redo synchronously from primary, forwards redasynchronously in real-time to standby

Upon Failover: Async standby transparently obtains last redo from Far Sync and applies: zero data loss failover

Second Far Sync Instance can be pre-configured to tranreverse direction after failover/switchover

Terminal standbys required to be Active Data Guard Sta

Active Data Guard Far Sync New in 1Zero Data Loss For Async Deployments

Active Data Guard Far Sync


23/60


Primary

Far SyncInstance

Active Data Guard Far SyncOperational Flow

ASYNCSYNC



24/60


Primary

Far SyncInstance

Active Data Guard Far SyncOperational Flow (contd.)

No Compromise Between Availability an

ASYNCSYNC

Zero Data Lo



25/60


Best data protection, least performance impact

Low cost and complexity

Best way to implement a near DR + Far DR model

Relevant to existing Data Guard ASYNC configurations

Data Guard Failover? No Problem! Just do itNo Data

Active Data Guard Far SyncBenefits

A ti D t G d R l Ti C di


26/60


Active Data Guard Real-Time CascadinEliminates Propagation Delay

Primary Standby 1

In 12.1, Standby 1 forwards redo to Standby 2 in real-timreceived: no propagation delay for a log switch

Standby 2 (Active Data Guard Standby) is up-to-date foread-only queries and reports

SYNC or ASYNC ASYNC

In 11.2, Standby 1 waits till log switch before forwarding

archived logs to Standby 2

D t G d F t S


27/60


Data Guard Fast SyncReduced Primary Database Impact for Maximum Availabil

Primary Standby

RedoLogs

StandbyRedoLogs

Commit

CommitAcknowledge

For SYNC transport: remacknowledges received rewriting it to standby redo

Reduces latency of comm

Better DRincreased SY

If network round-trip latentime for local online redo synchronous transport wiprimary database perform

NSS RFSLGWR

Commit

CommitAcknowledge

Acknowledge

returned on r eceipt

Primary Standby

RedoLogs

StandbyRedoLogs

NSS RFSLGWR

D t G d


28/60


Data GuardOther New Features in Oracle Database 12c

Rolling Upgrade With Active Data Guard

Automate complexity through simple PL/SQL Package:DBMS_ROLLING(12.1.0.1 onwards), with simple Init,Build, Start, Switchover, Finish procedures

Additional Data Type Support: XML OR, Binary XML,Spatial, Image, Oracle Text, DICOM, ADTs (simpletypes, varrays),

Validate Role Change Readiness

Ensure Data Guard configuration ready for switchoverwith automated health checksverify no log gaps,perform log switch, detects any inconsistencies,ensures online log files cleared on standby,

DML on Global Temporary

Temporary undo is not logged in Enables DML on global temporar

Data Guard: more reporting supp

Set by default on Active Data Gu

Unique Sequences

Primary allocates a unique rangeto each Standby

Enables more flexible reporting cGuard

O l D t b 12


29/60





RMAN Enhancements


GoldenGate Update

Fine grained Table Reco er From Bac


30/60


1 0 1

0 1 0 1 0

1 1 1 0 1 0 0 1

1 0 1 1 0 1 1 1 1 0

0 0 1 0 1 0 0 0 0

1 0 0 1 1 0 1

1 0 1 0

0 1

Fine-grained Table Recovery From Bac

Simple RECOVER TABL

recover one or more tarecent or older version)backup

Eliminates time and coassociated with manua& export

Enables fine-grained

recovery of individualthe contents of the enRMAN

Backups

12c RMAN Recover Table Example


31/60



RMAN> recover table mv_maint.inventory

until scn 1777348

auxiliary destination '/u01/uax'datapump destination '/u01/recover';

1. Creates an auxiliary instance

2. Performs PIT restore and recovery of the auxiliary database

SYSTEM, SYSAUX, UNDO and tablespace containing table

3. Data Pump export of table

4. Data Pump import into original database

5. Drops auxiliary instance and auxiliary data files



32/60



RMAN> recover table mv_maint.emp, mv_maint.deptuntil scn 1777348

auxiliary destination '/u01/aux'

datapump destination '/u01/recover;

Multiple tables, preserves PK/FK relationships

12c Recover Table Example


33/60


12c Recover Table Example

RMAN> recover table mv_maint.inventory

until scn 1777348

auxiliary destination '/u01/aux'

datapump destination '/u01/recover

remap table mv_maint.inventory:inventory_new;

Rename a table:

Other RMAN Restore Table 12c Option


34/60


Other RMAN Restore Table 12c Option

Place table in a different tablespace

remap tablespace

Just create the Data Pump dump file

notableimport

Restore a just a table partition

recover table mv_maint.inventory:P1

Cross Platform Backup & Restore


35/60


1

1

1

01

1

01

1

01

1

1

1

01

001

01

00001

1

001

Cross-Platform Backup & Restore

Simplifies procedure for platform migration

Minimize read-only impact with multiple incremental backu

Simplified Platform Migration

Source Database (AIX)

Backupto Disk/Tape

(data files, optional

endian conversion,metadata export)

R(o

me

Destination Database (

RMAN Cross-Platform Backup example


36/60


RMAN Cross-Platform Backup example

Startup source database read only

BACKUP command must contain either the FOR TRANSPLATFORM clause:

Copy backup set to destination server

Issue RESTORE command

RMAN Transporting Example


37/60


RMAN Transporting Example

RMAN> BACKUP TO PLATFORM='Linux x86 64-bit'

FORMAT '/tmp/xplat_backups/db_trans_%U.bck'

DATABASE;

Copy backup set to destination platform and restore:

RMAN> RESTORE FOREIGN DATABASE TO NEWFROM BACKUPSET /tmp/xplat_restores/db_trans_%U.b

Multitenant Environment (Container/Pluggab


38/60


Oracle Multitenant Backup & Restore


39/60


While connected to root, BACKUP DATABASE command backs up CDB, includi

While connected to root, RESTORE DATABASEand RECOVER DATABASE comm

recovers CDB, including all PDBs

Can backup any pluggable database while connected as SYS to root container

Backup and recover specific pluggable databases with new PLUGGABLE DATARMAN> BACKUP PLUGGABLE DATABASE , ;

RMAN> BACKUP tablespace SALESPDB:SALES;

PDB Complete Recovery

RMAN> RESTORE PLUGGABLE DATABASE ;

RMAN> RECOVER PLUGGABLE DATABASE ;

Oracle Multitenant Backup & RestoreFine-Grained Backup & Recovery to Support Consolidatio

RMAN Connection as SYS to Pluggable


40/60


RMAN Connection as SYS to Pluggable

While connected to a pluggable database as SYS, can ocurrently connected to pluggable database files:

$ rman target sys/foo@salespdb

RMAN> backup database;

RMAN> restore database;

RMAN> recover database;

Scope limited to pluggable database

RMAN B&R in Multitenant


41/60


RMAN B&R in Multitenant

Pluggable Database PIT Recovery


42/60



$ rman target /

RMAN> alter pluggable database salespdb close;

RMAN> RUN {

SET UNTIL SCN 1998737;

RESTORE PLUGGABLE DATABASE salespdb;

RECOVER PLUGGABLE DATABASE salespdb;

ALTER PLUGGABLE DATABASE salespdb OPEN RESETLOGS; }

SQL> select pdb_incarnation# from v$pdb_incarnation;



43/60



RMAN restores PDB data files

Requires root containers UNDO tablespace to perform pdatabase PIT recovery

RMAN creates an auxiliary database containing roots S

SYSAUX, and UNDO tablespace

If using a FRA, auxiliary database datafiles are tempora

FRA If not using a FRA, specify the auxiliary database destinAUXILIARY DESTINATION clause

Internals

RMAN Duplicate to Create Pluggable


44/60


RMAN Duplicate to Create Pluggable

RMAN DUPLICATE leverages restore process (from bacDB) to create new clone or standby database

Clone the entire CDB or ROOT + selected PDBs

Commands:

RMAN> DUPLICATE TARGET DATABASE TO ;

RMAN> DUPLICATE TARGET DATABASE TO PDATABASE , ;

Better Performance


45/60


Other New Features in Oracle Database 12c

Enhanced Multi-section Backup capability: now supports

and incremental backups Enhanced Active Duplicate

Cloning workload moved to destination server via auxiliaryrelieving resource bottlenecks on source

Cloning can now use RMAN compression and multi-sectio

further increase performance

Run SQL Commands Directly from RM


46/60


Q yCommand Line

Old:RMAN> sql alter system switch logfile;

New in 12c:

RMAN> alter system switch logfile;

RMAN> select name from v$datafile;

Run SQL Directly from RMAN Prompt


47/60


y p

Old:

sql "alter database datafile ''/u01/dbfile/o12c/users01.dbf''set newname for datafile '/u01/dbfile/o12c/users01.dbf'

to '/u02/dbfile/o12c/users01.dbf';

New in 12c:

alter database datafile '/u01/dbfile/o12c/users01.dbf' offlin

set newname for datafile '/u01/dbfile/o12c/users01.dbf'

to '/u02/dbfile/o12c/users01.dbf';

Reduces complexity

Oracle Database 12c


48/60


High Availability Key New Features

Application Continuity



RMAN Enhancements

Flex ASM

Other HA Enhancements

GoldenGate Update

Automatic Storage Management (ASM) O


49/60


ASM Cluster Pool of Storage

Disk Group BDisk Group AShared DiskGroups

Wide File Striping

One to One

Mapping of ASMInstances toServers

ASM Instance

Database Instance

RAC Cluster

Node4Node3Node2Node1 ASM ASM ASM ASM

ASM Instance

Database Instance

DBA

DBA

DBB DB

BDB

B

Current State

Flex ASM: Eliminate 1:1 Server Mappin


50/60


New: ASM Storage Consolidation in Oracle Database 12c

ASM Cluster Pool of Storage

Disk Group BDisk Group AShared DiskGroups

Wide File Striping

Databases share

ASM instances

ASM Instance

Database Instance

RAC Cluster

Node4Node3Node2Node1

Node1runs as

ASMClient toNode2

Node1runs as

ASMClient toNode4

Node2runs as

ASMClient toNode3

ASM ASM ASM

ASM Instance

DBA

DBA

DBB DB

BDB

B

Oracle Database 12c


51/60






RMAN Enhancements

Flex ASM


GoldenGate Update



52/60


Online Redefinition Enhan

Improved sync_interim_table

Ability to redefine table with VPD p

Improved resilience of finish_re

Better handling of multi-partition re

Online Datafile Move

Relocate a datafile while users are activelyaccessing data:ALTER DATABASE MOVEDATAFILE

Maintains data availability during storagemigration

Separation of Duties

SYSDG/ SYSBACKUP: Data Guard & RMAN

specific administrative privileges

No access to user data: enforce securitystandards throughout the enterprise

Additional Online Operatio

Drop index online / Alter index unu

index visible / invisible online

Drop constraint online / Set unused

Online move partition:ALTER TABPARTITION ONLINE

Oracle Database 12c


54/60


Log-based

Changed Data

Oracle & Non-Oracle

Database(s)

Message Bus

Oracle Database12c *

Low-Impact, Real-Time Data Integration & Transactional R

Data Integrator

New DB/HW/OS/APP

Fully Active

DistributedDB

ReportingDatabase

DataWarehouse

ODS

Ze

Que

Data S

Rea

Event

Active

MessageBus

GlobalDataCenters

Exact Copyof Primary

DN

*: GoldenGate 12cfor Oracle Database 12cwill be available in FY14

GoldenGate Zero Downtime Migration/


55/60


Seamless Migration and Upgrades to Oracle Database 12

Consolidate/migrate/maintain systems without

downtime

Minimize risk withfailback option

Validate data beforeswitchover

Use Active-Activereplication for phaseduser migration

Nn-OracleERP

Oracle Database 12c

Non-OracleERP


Real-Time

Replication

For Migrations

Optional

Failback

Data Flow

Oracle10.2CRM

Oracle11.2DW

Oracle GoldenGate for Active-Active D


56/60


Increase ROI on Existing Servers & Synchronize Data

Utilize secondarysystems for transactions

Enable continuousavailability duringunplanned & plannedoutages

Synchronize data across

global data centers Use intelligent conflict

detection & resolution


Oracle Database 12c

Oracle10.2App2

Oracle11.2App3

Non-Oracle

App

Heterogeneous Bi-Directional

Real-Time Replication

Oracle Database 12cE t A il bilit S


57/60


Oracle Database 12c offers a tremendously sophisticateset of high availability (HA) capabilities

These capabilities

Further reduce downtime

Significantly improve productivity

Eliminate traditional compromises

OTN HA Portal: http://www.oracle.com/goto/availability

Maximum Availability Architecture:http://www.oracle.com/goto/maa

Extreme Availability: Summary

Safe Harbor Statement


58/60


THE PRECEDING IS INTENDED TO OUTLINE OUR GENE

PRODUCT DIRECTION. IT IS INTENDED FOR INFORMATPURPOSES ONLY, AND MAY NOT BE INCORPORATED INCONTRACT. IT IS NOT A COMMITMENT TO DELIVER ANYMATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NRELIED UPON IN MAKING PURCHASING DECISIONS. THDEVELOPMENT, RELEASE, AND TIMING OF ANY FEATU

FUNCTIONALITY DESCRIBED FOR ORACLES PRODUCTREMAINS AT THE SOLE DISCRETION OF ORACLE.


59/60



60/60


3 - availability 12c

Documents