safe harbor statement - oracle cloud · •the broker will set all the necessary parameters for you...

SafeHarborStatementThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.

OracleActiveDataGuardBuildoutyourOracleMaximumAvailabilityArchitecturePlatinumConfiguration

LarryM.CarpenterMasterProductManagerOracleHighAvailabilitySystems

Agenda

MAAReferenceArchitecturesReview

BuildingOracleDataGuardPlatinum

Alookforwardtothenextrelease

InClosing

MAAReferenceArchitecturesReview

ZeroDataLossDRtotheCloudUseCaseZeroDowntime

RACZeroDataLossBackuptotheCloudUseCase

Prod/Departmental

BusinessCritical

Dev,Test,Prod

MissionCritical

BackupandRecovery

Bronze +

ZeroDowntimeHighAvailability

YouKnowtheMAAReferenceArchitectures

Silver+

ZeroDataLossHAandDR

BRONZESILVER

PLATINUM

ZeroDowntimeGoldenGateCloudSvc.

ZeroDowntimeMaintenance/Migration

Local&RemoteBackups

Bronze +

Active/ActiveDatabaseClustering+Backup&Recovery

Silver+

RemoteReplicationwithnear-Zerodataloss,fasterfailover

Gold+AdvancedCapabilitiesforZeroApplicationOutagesandZeroDataLoss

You’veSeenAllThePictures

SingleInstance Database

Replicated backup

PrimaryDatacenter

RemoteDatacenter

Local backup

RAC /RAC One Database Local

backup

Replicated backup

PrimaryDatacenter

RemoteDatacenter

Local backup

Replicated backup

Local Standby

PrimaryDatacenter

RemoteDatacenter

Local backup

PrimaryDatacenter

RemoteDatacenter

Remote Standby

Local backupPrimary

Local Standby

Primary

Local backup

PrimaryDatacenter

RemoteDatacenter

Remote Standby

Local backupPrimary

Local ADG Standby

GoldenGateApp Cont, EBR

GOLDBRONZE SILVER PLATINUMSILVER+

AndWhereYouCanSetItAllUp

On-Premises(DRSite)

On-Premises(Production)

ClientsActiveLink

Applications

ActiveDataGuardReplication(FarSync)

ActiveLink

Applications

OnPremises

OracleCloudInfrastructure

(DRSite)

ClientsActiveLink

Applications Compute

ActiveLink

DBCS/ExaCS

Hybrid

OracleCloudInfrastructure(Production)

(DRSite)

ClientsActiveLink

Compute

ActiveLink

Compute

DBCS/ExaCS DBCS/ExaCS

InTheCloud

AndWhereYouCanSetItAllUp

• Thegoodnewsis– Intheendit’sallthesamebasicprocesstosetup.• Andtherequirementsandobjectivesarealsothesame.

On-Premises(DRSite)

ClientsActiveLink

Applications

ActiveLink

Applications

OnPremises

(DRSite)

ClientsActiveLink

Applications Compute

ActiveLink

DBCS/ExaCS

Hybrid

OracleCloudInfrastructure(Production)

(DRSite)

ClientsActiveLink

Compute

ActiveLink

Compute

DBCS/ExaCS DBCS/ExaCS

InTheCloud

WhatAreYourMainObjectives?• RecoveryPointObject(RPO)

– Howmuchdatacanyouaffordtolose,ever?

• RecoveryTimeObjective(RTO)– Howfastdoyouhavetobebackup?

• PerformanceLevelObjective(PLO)– Howwelldoyouexpecttoperformpost-event?

• PerceivedApplicationOutage(PAO)–Whatdoesanapplicationoutageactuallymean?

• Yes,Imadethelasttwoup.Buttheyarejustasimportant.

ObjectivesForLocalFailuresAndCompleteDisasters• RTO=Hours/Days,RPO=Hours/Days,PLO=None?

– Bronze

• RTO=Seconds/Hours/Days,RPO=Days/Hours,PLO=Reduced?– Silver

• RTO=Seconds/Days,RPO=Seconds/Minutes,PLO=Similar/Reduced?– Silver+

• RTO=Seconds/Minutes,RPO=Zero/Seconds,PLO=Similar/Reduced?– Gold

• RTO=Zero,RPO=Zero,PLO=Exactlythesameallthetime?– Platinum

WhataboutPerceivedApplicationOutage(PAO)?• PAO=Totaloutage?

– Bronze

• PAO=SomewhatTransparent/Totaloutage?– SilverorSilver+

• PAO=MostlyTransparent?– Gold

• PAO=AlwaysTransparent?– Platinum

So,InSummary• Platinumrequires

– RTO=Zero– RPO=Zero– PLO=Exactlythesameallthetime– PAO=AlwaysTransparent

• Now,let’sgobuildthisbeast.

BuildingOracleDataGuardPlatinum

BuildingPlatinuminOracleDatabase12.2.0.1• Allocateatleast4DatabaseServersxNumberofRACnodesdesired

–OracleDatabase12.2.0.1andRAC,RACOneNodeorOracleRestart–Withtherequiredmemory,CPUsandStorage

• IftheseareintheOracleCloudInfrastructurethen,dependingontheiruserequirements,theStandbyscanbefewerCPUsandMemorythanthePrimaryastheycanbeincreasedatrolechangeevents.Storagewouldbethesamesizeandsameperformance

• Allocate4SmallerFarSyncservers–OracleDatabase12.2.0.1andOracleRestart– LessMemory,FewerCPUsandalotlessstoragebutwiththesameI/Ocapabilities

• Allocatenetworkconnectivitygreaterthanyourredogenerationrates• ConfigureTNSNAMESconnectivitybetweenall8+systems

SizingtheFarSyncServer• DiskrequiredforFarSyncinstanceisnegligible.

– RequiresdiskspacefortheStandbyRedoLogfiles– Spaceforarchivelogfilessufficienttohandlethelargestgapyouexpecttohappen.

• MemoryparameterscontrolledperSPFILE• I/OspeedoftheSRLdisksattheFarSyncismostimportant

– TheyneedtobefastifthePrimarygeneratesalotofredopersecond.

• RedotoTerminalStandbycanbecompressed–WillrequiremoreCPUandtheAdvancedCompressionOptionlicense

TheStartingConfiguration

Network

Prod ProdDG

Local LocalDG

FarSync2

FarSync1

FarSync4

FarSync3

EnsureThatYouHaveIsolation• ProdandLocalsystemsneedtobeclosebutisolatedfromeachother• ProdDG andLocalDG systemsneedtobecloseandisolatedaswell• Butbothpairsneedtoberemotefromeachother!• TheFarSyncsystemsalsoneedtofollowthesamerulesandbeisolatedfromtheirrespectivedatabases.– Youdon’twantalocalfailuretotakeoutmorethanoneobject

• Ifpossible

• Thismeansthatyouneedatleast2siteswith3datacenterseach– Fourormoredatacentersateachsitewouldbeevenbetter

CanIdothisintheOracleCloudInfrastructure?• Yes.

– TheexamplesinthistalkwereexecutedonseveralsystemsintheOracleCloudInfrastructureClassic environment.• WhileitwaspossibletogettheisolationbetweenthemainanddisasterrecoverysitesitisnotpossibletoensurelocalisolationbetweenthedatabasesandtheFarSyncinstancesinClassic.

• FullycontrolledisolationispossibleintheOracleCloudInfrastructure.• Thenexttwoslideswillshowexamplesofhowtodothat.

CreatingIsolatedDatabaseSystems• CreatetwoDBSystemsinoneRegionontwoAvailabilityDomains

CreatingIsolatedFarSyncSystems• CreatetwoInstancesinthesameRegionastheDatabaseSystems

–Oneonthe3rd AvailabilityDomain(ThiswillbethemainFarSync)– TheotherontheLocalstandbyAvailabilityDomain(ThiswillbetheBackupFarSync)

SoFarYouHaveThis

Ashburn

FarSync2

FarSync1

DoTheSameSetupinaDifferentRegion

Ashburn Phoenix

Prod ProdDG

Local LocalDG

FarSync2

FarSync1

FarSync4

FarSync3

SomeGroundRules• DuringthecreationoftheStandbyDatabasesandtheFarSyncInstances

– RemoveanyexistingDataGuardparametersfromthePrimary– DonotsetanyDataGuardparametersotherthantheBrokeronesonthenextslide.

• TheBrokerwillsetallthenecessaryparametersforyouafterwhichyoucanmodifythem.• AsofOracleDatabase12cRelease1theBrokerrequiresthatnoRedoTransportparameters(wheretheSERVICEattributeisused)bedefinedpriortocreatingtheBrokerconfiguration.– ‘Foreign’redodestinationsfordownstreamGoldenGate captureareOK.(NOREGISTERattribute)

– IfusingtheRMANduplicationmethodandyoucreateaDB_UNIQUE_NAMEstaticentryremembertoremoveitwhenyouaredone.

– ItnotusingOracleRestart,RACOneNodeorRACcreatethe“DB_UNIQUE_NAME_DGMGRL”staticentriesoneachdatabase system.

– Donotcreateany otherstaticentries.

CreateTheStandbyDatabasesFromProd• OnthePrimarydatabase,dothefollowing

– AddStandbyRedoLogfiles• SotheygetcreatedoneachStandbyDatabaseandFarSync.

– SettheBrokerfileparameterscorrectlyasyoudonotwantthedefaults• dg_broker_config_file1=‘/u01/app/oracle/product/12.2.0/dbhome_1/dbs/dr1Prod_01.dat’• dg_broker_config_file2=‘/u01/app/oracle/product/12.2.0/dbhome_1/dbs/dr2Prod_01.dat’• ChangethedefaultsandremembertheymustbothbevisibletoallRACnodesofadatabase

– SettheBrokerStartparametertoTRUE• dg_broker_start =‘TRUE’

CreatetheStandbyDatabases• OneachStandbysystemcreateaStandbyDatabase

– SeeMOSNote“CreatingaPhysicalStandbyDatabaseinan11.2,12.1,12.2orlaterenvironment”(DocID2275154.1)foryouroptions.

• InourexamplethesearethestandbysfromthePrimaryProd_01(onProd)– Prod_02(onProdDG)– Local_01(onLocal)– Local_02(onLocalDG)

CreatetheFarSyncInstances• SamebasicprocedureastheStandbyDatabases

–WewillcreateFarSync_01,FarSync_02, FarSync_03, FarSync_04– Createvariousdirectories,theStaticentry,passwordfileandthetempinit.ora file– StarttheFarSyncInstanceNOMOUNT

rmanconnect target sys/password@Prod_01; # Primaryconnect auxiliary sys/password@FarSync_01; # FarSyncrun {

allocate channel prmy1 type disk;allocate auxiliary channel stby1 type disk;

duplicate target database for Farsync from active databasespfile

parameter_value_convert 'Prod','FarSync1'set 'db_name'='Prod'set 'db_unique_name'='FarSync_01'

nofilenamecheck;}

EverythingisReadybutnotTalkingtoEachOtherProd_01 Prod_02

Local_01 Local_02

FarSync_02 FarSync_04

Ashburn Phoenix

EnterTheOracleDataGuardBroker!• Thisiswhereyouwillfinderrorsifyoudidnotfollowtherules.

–MakesureyousettheBrokerparameterscorrectly.• Thefilelocation(directories)youspecifiedmustexistoneachdatabaseandFarSync• BothBrokerfilesoneachClustereddatabasemustbethesame2filesforallRACNodes!

• Basicflowisasfollows– Createtheconfiguration– Addthe3StandbyDatabases– Addthe4FarSyncInstances– ConfigureRedoTransport– Enabletheconfiguration– EnsureZeroDataLoss

Createtheconfiguration

[oracle@Prod-dg01 ~]$ dgmgrl sys/Password@prod_01DGMGRL for Linux: Release 12.2.0.1.0 - Production on Wed Aug 16 18:20:55 2017

Welcome to DGMGRL, type "help" for information.Connected to "Prod_01"Connected as SYSDBA.DGMGRL> create configuration “fsc” > as primary database is “Prod_01” > connect identifier is “Prod_01”;

Configuration "fsc" created with primary database "Prod_01"

MustconnecttothePrimarydatabase

Addthe3Standbydatabases

DGMGRL> add database “Prod_02” as connect identifier is “Prod_02”;

Database "Prod_02" added

DGMGRL> add database “Local_01” as connect identifier is “Local_01”;

Database "Local_01" added

DGMGRL> add database “Local_02” as connect identifier is “Local_02”;

Database "Local_02" added

Addthe4FarSyncInstancesDGMGRL> add far_sync "FarSync_01" as connect identifier is FarSync_01;

far sync instance "FarSync_01" added

DGMGRL> add far_sync "FarSync_02" as connect identifier is FarSync_02;

TheCurrentConfigurationDGMGRL> show configuration;

Configuration - fsc

Protection Mode: MaxPerformanceMembers:Prod_01 - Primary database

Prod_02 - Physical standby databaseLocal_02 - Physical standby databaseLocal_01 - Physical standby databaseFarSync_01 - Far sync instanceFarSync_02 - Far sync instanceFarSync_03 - Far sync instanceFarSync_04 - Far sync instance

Fast-Start Failover: DISABLED

Configuration Status:DISABLED

ThisisTooMuchTalkingGoingOn(IfEnabled)Prod_01(Primary) Prod_02

Local_01 Local_02

FarSync_01

FarSync_02

FarSync_03

FarSync_04

Ashburn PhoenixSYNC

FixRedoTransport– Ashburn toPhoenixDGMGRL> edit far_sync "FarSync_01" set property redoroutes=‘(Prod_01 : Local_01, (FarSync_03, FarSync_04, Prod_02, Local_02))(Local_01 : Prod_01, (FarSync_03, FarSync_04, Prod_02, Local_02)) (Prod_02 : Prod_01, Local_01) (Local_02 : Prod_01, Local_01)';Property "redoroutes" updated

DGMGRL> edit far_sync "FarSync_02" set property redoroutes=‘(Prod_01 : Local_01, (FarSync_03, FarSync_04, Prod_02, Local_02))(Local_01 : Prod_01, (FarSync_03, FarSync_04, Prod_02, Local_02)) (Prod_02 : Prod_01, Local_01) (Local_02 : Prod_01, Local_01)';Property "redoroutes" updated

DGMGRL> edit database "Prod_01" set property redoroutes=‘(Local: (FarSync_01 SYNC, FarSync_02 SYNC, Prod_02, Local_01 SYNC, Local_02))';Property "redoroutes" updated

DGMGRL> edit database "Local_01" set property redoroutes=‘(Local: (FarSync_01 SYNC, FarSync_02 SYNC, Prod_02, Prod_01 SYNC, Local_02))';Property "redoroutes" updated

FixRedoTransport– Phoenix toAshburnDGMGRL> edit far_sync "FarSync_03" set property redoroutes=‘(Prod_02 : Local_02, (FarSync_01, FarSync_02, Prod_01, Local_01)) (Local_02 : Prod_02, (FarSync_01, FarSync_02, Prod_01, Local_01)) (Prod_01 : Prod_02, Local_02) (Local_01 : Prod_02, Local_02)';Property "redoroutes" updated

DGMGRL> edit far_sync "FarSync_04" set property redoroutes=‘(Prod_02 : Local_02, (FarSync_01, FarSync_02, Prod_01, Local_01)) (Local_02 : Prod_02, (FarSync_01, FarSync_02, Prod_01, Local_01)) (Prod_01 : Prod_02, Local_02) (Local_01 : Prod_02, Local_02)';Property "redoroutes" updated

DGMGRL> edit database "Prod_02" set property redoroutes=‘(Local: (FarSync_03 SYNC, FarSync_04 SYNC, Prod_01, Local_01, Local_02 SYNC))';Property "redoroutes" updated

DGMGRL> edit database "Local_02" set property redoroutes=‘(Local: (FarSync_03 SYNC, FarSync_04 SYNC, Prod_02 SYNC, Prod_01, Local_01))';Property "redoroutes" updated

EnabletheConfigurationandRaisetheProtectionMode• EnabletheConfiguration

• SincewehavesetSYNCtotheFarSyncwecanraisetheProtectionMode

DGMGRL> enable configuration;Enabled.

DGMGRL> edit configuration set protection mode as MaxAvailability;Succeeded.

The‘Enabled’ConfigurationDGMGRL> show configuration;Configuration - fsc

Protection Mode: MaxAvailabilityMembers:Prod_01 - Primary database

FarSync_01 - Far sync instanceLocal_01 - Physical standby databaseFarSync_03 - Far sync instance

Prod_02 - Physical standby databaseLocal_02 - Physical standby database

Members Not Receiving Redo:FarSync_02 - Far sync instance (alternate of FarSync_01)FarSync_04 - Far sync instance (alternate of FarSync_03)

Configuration Status:SUCCESS (status updated 11 seconds ago)

The‘Enabled’ConfigurationDGMGRL> show configuration;Configuration - fsc

Protection Mode: MaxAvailabilityMembers:Prod_01 - Primary database

FarSync_01 - Far sync instanceLocal_01 - Physical standby databaseFarSync_03 - Far sync instance

Prod_02 - Physical standby databaseLocal_02 - Physical standby database

Members Not Receiving Redo:FarSync_02 - Far sync instance (alternate of FarSync_01)FarSync_04 - Far sync instance (alternate of FarSync_03)

Configuration Status:SUCCESS (status updated 11 seconds ago)

CurrentPriority1

NowWe’reTalking!Prod_01(Primary) Prod_02

Local_01 Local_02

Ashburn PhoenixSYNC

ShiponceacrosstheWAN!

Prod_01Primary

DGMGRL> show configuration when primary is "Prod_01";

Configuration when Prod_01 is primary - fsc

Members:Prod_01 - Primary databaseFarSync_01 - Far sync instanceLocal_01 - Physical standby databaseFarSync_03 - Far sync instanceProd_02 - Physical standby databaseLocal_02 - Physical standby database

FarSync_04 - Far sync instance (alternate of FarSync_03)Prod_02 - Physical standby databaseLocal_02 - Physical standby database

Prod_02 - Physical standby database (alternate of FarSync_03)Local_02 - Physical standby database (alternate of FarSync_03)

FarSync_02 - Far sync instance (alternate of FarSync_01)Local_01 - Physical standby databaseFarSync_03 - Far sync instanceProd_02 - Physical standby database (alternate of FarSync_03)Local_02 - Physical standby database (alternate of FarSync_03)

FarSync_04 - Far sync instance (alternate of FarSync_03)Prod_02 - Physical standby database (alternate of FarSync_03)Local_02 - Physical standby database (alternate of FarSync_03)

Prod_02 - Physical standby database (alternate of FarSync_03)Local_01 - Physical standby database (alternate of FarSync_01)Local_02 - Physical standby database (alternate of FarSync_03)

Prod_01Primary

Priority1

Prod_01Primary

Priority8

Prod_01Primary

FinalPriority8

Local_01Primary

DGMGRL> show configuration when primary is "Local_01";

Configuration when Local_01 is primary - fsc

Members:Local_01 - Primary databaseFarSync_01 - Far sync instanceProd_01 - Physical standby databaseFarSync_03 - Far sync instanceProd_02 - Physical standby databaseLocal_02 - Physical standby database

FarSync_02 - Far sync instance (alternate of FarSync_01)Prod_01 - Physical standby databaseFarSync_03 - Far sync instanceProd_02 - Physical standby database (alternate of FarSync_03)Local_02 - Physical standby database (alternate of FarSync_03)

Prod_02 - Physical standby database (alternate of FarSync_03)Prod_01 - Physical standby database (alternate of FarSync_01)Local_02 - Physical standby database (alternate of FarSync_03)

Prod_02Primary

Local_02Primary

DGMGRL> show configuration when primary is "Local_02";

Configuration when Local_02 is primary - fsc

Members:Local_02 - Primary databaseFarSync_03 - Far sync instanceProd_02 - Physical standby databaseFarSync_01 - Far sync instanceProd_01 - Physical standby databaseLocal_01 - Physical standby database

FarSync_04 - Far sync instance (alternate of FarSync_03)Prod_02 - Physical standby databaseFarSync_01 - Far sync instanceProd_01 - Physical standby database (alternate of FarSync_01)Local_01 - Physical standby database (alternate of FarSync_01)

Prod_02 - Physical standby database (alternate of FarSync_03)Prod_01 - Physical standby database (alternate of FarSync_01)Local_01 - Physical standby database (alternate of FarSync_01)

CanYouDoThisWithoutTheBroker?• Yes,butdon’t.

– TheBrokerdynamicallyaddsthefollowingLOG_ARCHIVE_DEST_n parameters• FiveparametersProd_01• FiveparametersonFarSync_01andFarSync_02• TwoparametersonFarSync_03andFarSync_04

–WithouttheBrokeryouwouldneedtoconfigureall theparametersyourself• FiveparametersonProd_01• FiveparametersonLocal_01• FiveparametersonProd_02• FiveparametersonLocal_02• SevenparametersonFarSync_01andFarSync_02• SevenparametersonFarSync_03andFarSync_04

WillOracleCloudInfrastructureDoThisForMe?• We’reworkingonit.

– HAorDRstandbysarepossibletoday• Soonyouwillbeabletodoacombinationofbothautomatically

– AutomaticFailover(FSFO)iscoming(LocalorRemote)– RemoteZeroDataLossiscoming(FarSync)

• BuildingoutDataGuardPlatinumisonthebooks

So,WhatHaveWeAchieved?• RTO=Zero?

– Planned- “Zero”withService/SessionDraining,reasonablytransparent– SeePAO– Unplanned- Disconnect/LossofInflightTransaction

• EvenwithFast_Start Failover(FSFO)- LocalorRemote

• RPO=Zero?– Planned– Zero– Unplanned– Zero,unlessthereisatotalfailureofthecurrentproductionsite

• PLO=Exactlythesameallthetime?- Check!• PAO=AlwaysTransparent?

– Planned– Check,butwitha‘pause’:Unplanned– VisibleandnotZero

CurrentRTOCapabilities• Plannedeventsrequireaswitchover(The‘pause’butnodisconnect)

–O/SUpgrades– GridInfrastructure– RDBMS(StandbyFirstPatchingandRollingUpgrades)– ApplicationUpgrades(Noswitchoverrequiredhere)

• WhendonedirectlyinthePrimarydatabaseusingEditionBasedRedefinition(EBR)

• Unplannedevents– CurrentRead/Writeusersexperienceatransactionlossanddisconnect– ReadersontheActiveDataGuardFailoverStandbycontinuewithapause.– ReadersonbystanderActiveDataGuardStandbysseenointerruption

CurrentRPO Capabilities• PlannedEvents

– RPOisalwaysZerosinceaDataGuardSwitchoverisalwaysZeroDataLoss

• UnplannedEvents– ProductionFailure

• RPOisZero

– ProductionTotalSiteFailure• Zero,aslongasyouprotectthe‘Production’FarSyncsfromanyfailure

– Otherwiseafailovertotheremotestandbywillresultinsomedataloss.

ImproveRTO&PAOwithApplicationContinuity• CombinedwithSyncFastStartFailover(FSFO),ApplicationContinuitycanrenderanunplannedfailuretransparenttotheapplication– RTO=Zero– RPO=Zero

• HoweverFSFOcanonlyprovidethislocallyorremotelywithourconfiguration,notboth.– ThismeansProd_01toLocal_01(Locally)orProd_01toProd_02(Remotely).

• Prod_01toProd_02requiresthattheFarSync_01orFarSync_02weresynchronizedatfailuretime.• Prod_02toProd_01requiresthesameforFarSync_03orFarSync_04.

WithApplicationContinuity- LocalProd_01(Primary) Prod_02

Local_1 Local_02

Ashburn PhoenixSYNC

ApplicationContinuityRTO=0

ObserverFarSync_01 FarSync_03

WithApplicationContinuity– OrRemoteProd_01(Primary) Prod_02

Local_01 Local_02

Ashburn PhoenixSYNC

ApplicationContinuityRTO=0

Observer

ExtendedFSFOFeaturesinOracleDatabase12.2• MultipleObserverscanbestarted

–Maximumof3–Onlyoneisthemasteratanytime– ChangingthemasterrequirescommunicationwiththePrimary

• MultipleStandbyTargetscanalsobedefined– Ifthecurrenttargetfails,anotherstandbyinthelistischosen– ChangingthetargetrequirescommunicationwiththePrimary– SoLocal_01,Prod_02andLocal_02canbetargets,inthatorder

• IfLocal_01failsFSFOwillbesetupbetweenProd_01andProd_02

– RequiresthattheapplicationtiercanseebothforApplicationContinuitytowork

HowDoWe“KickItUpaNotch”?• CurrentlytheStandbydatabasesareavailableforReadTransactions

– AncillaryDMLisalsopossiblebutnotfullapplicationtransactions

• ToimproveRTOyouneedtointroduceGoldenGate– No[Active– Passive]asitbuysyounothing.– Full[Active– Active]isrequired,completewithconflictdetectionandresolution

• PlannedEvents–MakesPAOfullytransparentforPlannedEvents

• Usersmoveastheybecomeidle

• UnplannedEvents– Totalgeographicfailures,50%ofuserslosetheirtransactionanddisconnect

CreateTwoDistinctBrokerConfigurationsProd_01(Primary) Prod_02(Primary)

Local_01 Local_02

Ashburn PhoenixSYNC

Observer Observer

GoldenGate

GoldenGate Active- Active

FarSync_01 FarSync_03ApplicationContinuity

ApplicationContinuity

NowWhereAreWe?• RTO=Zero?

– Planned– Zero,Usersmovewhenready,nodisconnect,notransactionloss– Prod_01orProd_02Unplanned– Zero,WithFSFOandApplicationContinuity– GeographicUnplanned– 50%disconnectandlosetransactions

• RPO=Zero?– Planned– Zero– Unplanned– Zeroforanysinglefailure.Butnotzeroforageographicalfailure.

• PLO=Exactlythesameallthetime?- Check!• PAO=AlwaysTransparent?

– Planned?Check- Unplanned?NotZerothroughallfailures

WhatistheNextStep?• TogettheRTOto100%zero

–WeneedApplicationContinuitybetweenthetwoGoldenGate databases.• We’renotthereyet.

• TogettheRPOto100%zero– Bothsidesoftheconfigurationneedtohavezerodatalossstandbysoutsidetheirgeographicallocations.• Thismeanstwomorestandbys.• Remember- Zero,aslongasyouprotectthe‘Production’FarSyncsfromanyfailure

– Otherwiseafailovertotheremotestandbywillresultinsomedataloss.

AddtheTwoStandbyDatabasesProd_01(Primary) Prod_02(Primary)

Local_01 Local_02

Ashburn PhoenixSYNC

Observer Observer

GoldenGate

GoldenGate Active- Active

Remote_02 Remote_01

BuildingPlatinuminOracleDatabase12.2.0.1• FromBronzetoPlatinumisquiteanevolution• WhenyourBosssays“IwantRTO=0andRPO=0”

– Youneedtounderstandwhatthatactuallymeans.– Askdetailedquestions

• WhatexactlydoesRTOofZeromean?• IsthereanyflexibilityintheRPOofZero?• WhatdotheyconsiderthePLOtobe?• AndisthereanyvariationinwhatweconsiderthePAO?

– You’llneedtointroducethatone!

– Andrespondaccordingly• Whattheyareaskingforisnotcheap

Review- DataGuard12.1NewFeaturesSummary• DataGuard

– SYSDGRoleforDataGuardspecificoperations– MultitenantDatabaseStandbys– DefaultRealTimeApply– TransparentOnlineDatafilemovement– SingleSQL*PlusSwitchovercommand– NoPrimaryinstanceshutdownforswitchover– FastSync (SYNCNOAFFIRM)– EnhancedExtendedDatatype Supportforupgrades– LogicalStandbysupportforadditionaldatatypes

• XMLType dataforallstoragemodels,OracleSpatial,OracleMultimedia,OracleText,ObjectsandCollections(includingVARRAYsandnestedcollections),DatabaseFileSystem(DBFS),XDB,OracleSecureFiles (deduplication),andUser-definedtypes.

– DBMS_SCHEDULERsupportforRollingUpgrades– BrokerVALIDATEDATABASEcapability– EnhancedBrokerconfiguringwithRedoRoutes– BrokerResumable switchover– NewBrokerObserverpropertiesandcapabilities– BrokersupportofCascadingRedodestinations

• ActiveDataGuard– RealTimeCascadingRedodestinations– WANDistanceZeroDataLosswithFarSync– GlobalTemporaryTableDMLonastandby– Sequences(globalandsession)onastandby– DBMS_ROLLINGautomatedrollingupgrades– SupportforOracleApplicationContinuity– SupportforOracleGlobalDataServices

Review- DataGuard12.2NewFeaturesSummary• DataGuard

– UseDBCAandEMCLItocreateStandbys– UseRMANandEnterpriseManagertocreateFarSync

InstancesinadditiontoStandbys– RestInterfacetotheDataGuardBroker– CheftoolstocreateandmanageDataGuardstandbys– ScriptingwiththeBrokerDGMGRLcommandlineinterface– EasilycreatingSubsetStandbydatabasesinMultitenant– MigrateandFailoverPDBswiththeBroker– AutomaticPasswordFilemanagement– EasyrepairofNoLoggingoperations– DataFileBlockComparisonbetweenPrimaryandStandby– MultipleFSFOTargetsandObservers– FSFOinMaximumProtectionmode– ZeroDataLossFailoversinanymodewithStorageFailures– EnhancedcontrolofAlternatedestinations– ConverttoTDEeasilywithlittleornodowntime

• ActiveDataGuard– UsingallyourStandbyInstancestoapplyredo– DataGuardBrokerSupportandinvolvementinDBMS_ROLLING

controlledrollingupgrades– UsetheInMemoryColumnStoreonyourStandby– UseAWRandSQLTuningAdvisortodiagnoseandtuneRedo

ApplyandQueryissuesonyourActiveDataGuardStandby– MoveuserstransparentlyduringrolechangewithSession

DrainingonthePrimaryandPreservingexistingconnectionsattheActiveDataGuardStandby

– MoreprotectionwithAutoBlockrepairenhancements

SafeHarborStatementTheprecedingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.

safe harbor statement - oracle cloud · •the broker will set all the necessary parameters for you...

Documents

upgrading oracle database 11.2.0.3 to 12.1.0 web...

dbatrainer.com · oracle dba 12c course highlights: oracle...

oracle weblogic server 12c: seamless oracle database...

oracle goldengate 12c

hol9396: oracle event processing 12c: fact data ......title:...

encryption and redaction in oracle database 12c … and...

plug into the cloud with oracle database 12c - white paper...

oracle database 12c release 2 -...

oracle em 12c

oracle 12c admin training | oracle 12c administration online...

oracle goldengate 12c - oracledwh.de€¦ · 1 oracle...

oca oracle database 12c sql fundamentals i · pdf fileoca...

oracle 12c sql

oracle data integrator 12c - doag.org€˜s new in oracle...

partner webcast – oracle soa 12c: bpm 12c integration with...

oracle goldengate 12c · release notes for oracle...

deploying oracle database 12c on oracle zfs storage...

3 - maximize availability with oracle database 12c ·...

oracle 12c seguridad

oracle database 12c release 2 training - doag.org · title:...