oracle data guard 12.2 - 18c - doag.org · • in oracle database 12c release 2, a storage failure...

Post on 28-Feb-2019

244 Views

Category:

Documents

2 Downloads

Preview:

Click to see full reader

TRANSCRIPT

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuard12.2-18c

UweKirchhoffTechnicalArchitectACSGlobalDelivery

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

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

3

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuardProposedEnhancements

Manageability

Protection

Performance

PlannedMaintenance

ClientFailover

1

2

3

4

5

4

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ManageabilityEnhancements12candBeyond

5

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuard-Manageability

• CreateDataGuardStandbyswithDatabaseCreationAssistant(DBCA)• RMANDUPLICATEforFarSync•  EnterpriseManagersupportforFarSynccreation•  EMCLIstandbydatabasecreation

6

StandbyCreation

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

DBCAStandbyCreation

• AttheStandbyserverinstalltheOracleSoftwareandstartalistener•  Executeasinglelinecommand

• ConfigureyournetworkTNSNAMESforDataGuard• BuildyourBrokerconfiguration.– OrjustaddthisnewstandbytoyourexistingBrokerconfiguration

7

Simpleandscriptable!

dbca -silent -createDuplicateDB –gdbName PROD.de.oracle.com –sid STBY -sysPassword oracle -primaryDBConnectionString linbar01:1521/PROD.de.oracle.com -createAsStandby –dbUniquename SPROD -customScripts $ORACLE_HOME/PostCR.sql

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

RMANandFarSync

• RMANwillbeabletocreateaFARSYNCInstanceusingDUPLICATE–  duplicate target database for farsync from active database; –  duplicate target database for farsync backup …

•  Samebasicsetupasthestandbyactiveduplicateprocessthen…

8

connect target sys@PROD; connect auxiliary sys@PROD1FS; run {allocate channel prmy1 type disk; allocate auxiliary channel stby1 type disk; duplicate target database for farsync from active database spfile parameter_value_convert (’PROD',’SPROD') set 'db_unique_name'=’SPROD';}

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

EnterpriseManagerCloudControl

•  YouwillalsobeabletocreateFarSyncInstancesusinganew,butfamiliarEMCCcreationWizard

9

FarSyncCreationandManagement

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.| 10

FarSyncCreationandManagementEnterpriseManagerCloudControl

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

EnterpriseManagerCloudControl

•  EnterpriseManagerhashadaStandbyCreationWizardformanyversions•  ItalsohasacommandlineinterfacecalledEMCLI– Today(<12.2)youcannotscriptstandbycreationthroughit.– Butnotforlong!

– NoticehowthetargetcanbeaRACorSingleInstancedatabase– RMANduplicatefromactivedatabaseisalsothedefault

11

Commandlinestandbycreation

emcli create_standby -source_db_target_name=“PROD” -source_db_target_type=“rac_database” -dest_oracle_sid=“PROD1_1” -spname=“PROD1” -use_broker

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuard-Manageability

• RESTfulServicesInterface– Creating,MonitoringandManagingaDataGuardBrokerConfiguration

• OracleDataGuardforDataWarehouses-NoLoggingsupport•  SubsetStandbys• AutomaticallySynchronizePasswordFiles•  TDETablespaceOfflineConversion

12

EaseofUse

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

DataGuardandNoForceLogging

• No-Loggingoperationsonlygenerateenoughredototellthestandbythatsomeblocksarenowunrecoverable.– Repairingthemmeantrestoringthecompleteaffecteddatafiles.

• No-LoggingblockswillbetrackedbythePrimarydatabase•  StandbyscanthenbeeasilyrepairedusingRMAN– Validationandrepaironlyofblocksonstandbythatwereinvalidatedbynon-loggedoperations(suchasdirectloads)ontheprimary

– ThiswillquerythePrimaryforblocklocationsthatcontainnon-loggedblocksandrepairthestandbydatabase.

13

rman validate/recover .. nonlogged block

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

RemovingtheheadacheofPasswordfilemanagement

•  Today(<12.2)whenyouchangethepasswordofanyelevatedprivilegeuser– YoumustcopythepasswordfiletoallothernodesofthePrimaryANDallstandbys– Madealittlesimplerin12.1.0.1byasharedpasswordfileforRAC

•  InOracleDatabase12cRelease2– Changingelevatedprivilegedpasswordsontheprimaryautomaticallyupdatesallthestandbys’passwordfiles.

– Noneedtomanuallycopypasswordfiles!

• NewDGredoauthenticationprotocolthatusesSSLcertificatefor‘redo_transport_user’

14

Password,Password,who’sgottherightpassword?

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

TDETablespaceConversion

• RequiresanExportandImporttoencrypt• Cannotbedoneonlinesodataisunavailableduringtheprocess• OutageforthedatacanbemitigatedbyusingaTransientLogicalStandby– ConvertaPhysicalStandbytoaTransientLogicalStandby•  Exportthedata,Createtheencryptedtablespace,Importthedataatthetransientlogicalstandby

– Switchover– Athttp://www.oracle.com/goto/maaseethesetwopapers•  ConvertingtoTransparentDataEncryptionUsingActiveDataGuard12c(DBMS_ROLLING)•  ConvertingtoTransparentDataEncryptionUsingDataGuardTransientLogicalStandbywithOracleDatabase11g

15

<12.2

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

TDETablespaceConversion

• Offlinedatafilemethodstillavailable– CompletewithPhysicalStandbymethod

• AnewSQLcommandwillarriveonthescene!

•  Encryptsalldatafilesinthetablespaceonline.– Primaryonly&Requiresauxiliarydiskspace

• CanalsobedoneOFFLINEforbetterperformance– NoExtrastorage,butrequiresdataoutageonPrimary.– OfflinecanbedoneonaPhysicalStandbyfirstaswiththepreviousexample

16

(>=12.2)

alter tablespace users encryption encrypt

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuard-Manageability

• DGMGRLCommandImprovements• BrokerConfiguration-WideServiceName•  SimplifiedObserverManagementformultipleFast-StartFailoverconfigurations

17

BrokerGeneralEnhancements

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

NewDGMGRLcommands

•  EnhancedScriptingandExecution– Scriptexecutionvia‘@’– RepeatpreviousDGMGRLcommandwith‘/’– Executeoperatingsystemcommandwith‘HOST’or‘!’– Storeoutputinafilewith‘SPOOL’– Displaytimestampinpromptvia‘SETTIMEON/OFF’

18

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

Configuration-WideServiceName

• Providesasingleautomaticallystartedservicetoconnecttoanydatabase,PrimaryorStandby,inaDataGuardBrokerconfiguration.– DefaultstoPrimaryDBUniquenamewith‘_CFG’appended.– RequiredtoimplementtheSimplifiedObservermanagement(Nextslide)

• Canbesetbytheuserwith:

• Andseenwith:

19

edit configuration set property ConfigurationWideServiceName = ‘PROD_CFG’;

show configuration verbose ConfigurationWideServiceName; ConfigurationWideServiceName = ’PROD_CFG'

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

SimplifiedObserverManagement

•  Today(<12.2)whenyouhavemultipleBrokerconfigurationsusingFast-StartFailoveryoumustmanagetheObserversseparatelyeveniftheyallrunonthesame‘Observer’system.•  TheObserveralsorunsintheforeground•  Let’sfixthatlastonefirst

•  Thatsettlesthat• ButwhataboutmultipleFast-StartFailoverconfigurations?

20

start observer PRODObserver logfile is ‘/tmp/PRODObserver’ in background connect identifier is PROD;

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

SimplifiedObserverManagement

• CreateanObserverConfigurationfile(herewehave4Observers,2groups)

•  TheCONNECT_IDmustpointtothePrimaryandallpotentialFSFOTargets

21

OneCommandtoRunandManageMultipleObservers

BROKER_CONFIGS = ( (CONFIG = (NAME=SALES) (CONNECT_ID=SALES_P)(FILES=/home)) (CONFIG = (NAME=HR) (CONNECT_ID=HR_P)(FILES=/home)) (CONFIG = (NAME=CUSTOMER) (CONNECT_ID=CUSTOMER_P)(FILES=/home)) (CONFIG = (NAME=ORDERS) (CONNECT_ID=ORDERS_P)(FILES=/home))) CONFIG_GROUPS = ( (GROUP =(NAME=GRP_A ) (CONFIG_LIST = (NAME=SALES)(NAME=ORDERS))) (GROUP= (NAME=GRP_B) (CONFIG_LIST = (NAME=HR)(NAME=CUSTOMER))))

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

SimplifiedObserverManagement

•  SetthePropertytopointtoyourfileontheObserversystem

• Noticethatthereisnoneedtoconnecttoanydatabasetosetthisup

22

OneCommandtoRunandManageMultipleObservers

Oracle12c > dgmgrl DGMGRL for Linux: Release 12.2.0.0.0 Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> set observerconfigfile='/home/myobservers.ora'; DGMGRL> show observerconfigfile; ObserverConfigFile=/home/myobservers.ora

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

SimplifiedObserverManagement

• OncethefileissetupinstructtheBrokertoruntheObservergroups

•  Therearenopasswordsintheconfigurationfile•  YoumustusetheWalletforauthenticationonalldatabasesinvolved.

23

OneCommandtoRunandManageMultipleObservers

DGMGRL> start observing grp_a ; ObserverConfigFile=/home/myobservers.ora Observer configuration file parsing succeeded Submitted command "START OBSERVER" using connect identifier “SALES_P" Submitted command "START OBSERVER" using connect identifier “HR_P“ Check superobserver.log and individual observer logs

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ProtectionEnhancements12candBeyond

24

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuard-Protection

•  EnhancedAutomaticBlockRecovery•  Zero-datalossFast-startFailoveruponstoragefailureeveninasyncmode– Ifinstancefails,shipsallredodataaccumulatedinlogbuffertostandby

• OracleDataGuardDatabaseCompare•  EnhancedAlternateDestinations• BrokerProtectionEnhancements• DisasterRecoveryintheCloud

25

EnhancedProtection

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

EnhancedAutomaticBlockRecovery

• ActiveDataGuardAutomaticBlockRepairintroducedin11gRelease2

• Blockslikefileheadersetcwerenotrepaired.•  InOracleDatabase12cRelease2thetypesofcorruptedblocksthatcanberepairedincreases!

26

ActiveStandbyDatabase

PrimaryDatabase

Read/WriteWorkload

Continuousredoshipping,validation&apply

Real-timeReporting

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

Zero-DataLoss(ZDL)Fast-StartFailover

•  Today,ZDLFast-StartFailoversareonlypossibleinSynchronousconfigurationsrunninginMaximumAvailability– Manytimesthough,failuresarestoragerelatedandnotcompletesystemfailures

•  InOracleDatabase12cRelease2,astoragefailureattheprimarydatabasewillbehandledbytheOracleDataGuardAsynchronousprocess.– Iftheinstancefails,itwillshipallredodataaccumulatedinlogbuffertostandby– ThiswillallowFast-StartFailovertoperformaZeroDataLossfailover•  EventhoughtheconfigurationwasinMaximumPerformance

– SimilartoanAutomaticIn-Memory‘ALTERDATABASEFLUSHREDO;’atfailuretime

27

Enhancedforasynchronousconfigurations

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuardDatabaseCompare

• Highspeeddatabasecomparebetweenprimaryandstandby– DetectslatentcorruptionsonblocksthathavenotbeentouchedbyOracle•  Usefulindetectinglatentcorruptions,lostwrites•  Fastcompareatphysicallevel,accountsforblocksbeingmodified•  Network&computeefficiency– Send&compareblocksin“batches”– Optimizesforblockswhereversionsarethesame–  Ignoresemptyblocks

28

DGMGRL> validate database PROD1 datafile 10 output=checkPROD1; Operation requires a connection to database ”PROD1" Connecting ... Output files are created in /…/PROD1/trace on host “GRONAU1"

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.| 29

OracleDataGuardDatabaseCompareSummary: *************************************************************************** ID: Block Type Id TOTAL: Total number of blocks found DIFFV: Number of block pairs with different version LWLOC: Lost Writes at Local LWRMT: Lost Writes at Remote SAMEV: Number of block pairs with same version SAMEV&C: Number of block pairs with same version and checksum DIFFPAIR: Number of block pairs with same version but different contents ENCERR: Undecided blocks related to encryption/decrytion error. e.g. Wallet is not open. SKIPPED: Skipped blocks due to data corruption, etc ID TOTAL DIFFV LWLOC LWRMT SAMEV SAMEV&C DIFFPAIR ENCERR SKIPPED 29 0000001 0000000 0000000 0000000 0000001 0000001 0000000 0000000 0000000 30 0000125 0000000 0000000 0000000 0000125 0000125 0000000 0000000 0000000 58 0000512 0000512 0000000 0000000 0000000 0000000 0000000 0000000 0000000

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

EnhancedAlternateDestinations• Alternatedestinationsgotmuchbetterin12.1– Butfailbacktothefirstdestinationhappenedwhetherornotyouwantedit– Andyoulostfailbackifyouconfiguredmorethanonealternate.

•  Soin12.2wethrewawaytheALTERNATEattributeofredotransport– Replacingitwith2newattributes-GROUPandPRIORITY•  GROUPsaysweareallpotentialalternatesofeachotherinthesamegroup•  PRIORITYtellsDataGuardwhentofailbacktotheoriginaltargetbetweengroups

• Didyougetallthat?– Ididn’tthinkso,thisismygiveyouaheadachefeature.– Let’slookatanexample

30

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ImprovedAlternateDestinations• Ourconfiguration– WehaveaPrimarywithtwoStandbys(TS1andTS2)•  Theycouldbeonelocalandoneremoteorbothremoteorbothlocal– ButwithFarSyncweshiponcefromthePrimaryandgetZDLatbothifnecessary

– Wealsohave2FarSyncinstancesthatcanservicethetwoStandbys(FS1,FS2)•  FarSync1&2areofequalconfigurationandbothlocal(withinSYNClatency)– SowecanloseoneandtheotherwilltakeoverandmaintainMaximumAvailability

•  ButifbothFarSyncInstancesaredownwestillwantredotobeshippedtoTS1&TS2•  Sowesetour4“LOG_ARCHIVE_DEST_n”parametersasfollows(allvalidforthePrimaryrole/logfile)

• Allclear?

31

2:SERVICE=FS1 SYNC GROUP=1 PRIORITY=1 3:SERVICE=FS2 SYNC GROUP=1 PRIORITY=1 4:SERVICE=TS1 ASYNC GROUP=1 PRIORITY=8 5:SERVICE=TS2 ASYNC GROUP=1 PRIORITY=8

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ImprovedAlternateDestinations• OK,someEnglishtogowiththeparameters,theseareallthesamegroup

• ButthePrioritysays– SendRedotoFS1first,itforwardstheredotoTS1&TS2.– IfFS1failsstartsendingtoFS2whoforwardstheredotoTS1&TS2•  IfFS1comesbackdonothing,staywithFS2•  HoweverifFS2failsandFS1isback,reverttoFS1

– IfbothFS1andFS2failthensenddirectlytoTS1andTS2.•  SincetheyareconfiguredasASYNCtheProtectionLeveldropstoRESYNCHRONIZATION•  AfterthatifeitherFS1orFS2becomeavailablerevertbacktothem– ProtectionLevelgoesbacktoMaximumAvailability

32

2:SERVICE=FS1 SYNC GROUP=1 PRIORITY=1 3:SERVICE=FS2 SYNC GROUP=1 PRIORITY=1 4:SERVICE=TS1 ASYNC GROUP=1 PRIORITY=8 5:SERVICE=TS2 ASYNC GROUP=1 PRIORITY=8

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ImprovedAlternateDestinations

• NormalSteadyState

33

Howaboutapicture?

PrimaryTS1FS1

TS2

FS2

SYNCASYNC

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ImprovedAlternateDestinations

•  FarSyncFS1Fails(StayinPriority1)

34

Howaboutapicture?

PrimaryTS1FS1

TS2

FS2

SYNCASYNC

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ImprovedAlternateDestinations

•  FarSyncFS1comesback(StayinPriority1,Nofailback)

35

Howaboutapicture?

PrimaryTS1FS1

TS2

FS2

SYNCASYNC

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ImprovedAlternateDestinations

•  FarSyncFS2FailsandFS1isstillnotavailable(MovetoPriority8)

36

Howaboutapicture?

PrimaryTS1FS1

TS2

FS2

SYNCASYNC

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ImprovedAlternateDestinations

•  FarSyncFS1comesback(MovebacktoPriority1)

37

Howaboutapicture?

PrimaryTS1FS1

TS2

FS2

SYNCASYNC

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuard-Protection

• BlockComparisonToolSupportinDGMGRL– Shownintheearlierexample

• MultipleAutomaticFailoverTargets• MultipleObservers•  Fast-StartFailoverinMaximumProtectionMode•  SupportforEnhancedAlternateDestination•  SupportforTransportDestinationsofDifferentEndianess– Cross-endianDataGuard:AIXtoRecoveryAppliance

38

BrokerProtectionImprovements

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

PerformanceEnhancements12candBeyond

39

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

OracleDataGuard-Performance

• Multi-InstanceRedoApply– OracleDataGuardBrokerSupport• DatabaseIn-MemoryonanOracleActiveDataGuardStandbyDatabase• ActiveDataGuardsupportforDiagnosticPackfeatures• ActiveDataGuardSupportforSQLTuningAdvisor

40

PerformanceandTuningEnhancements

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

41

Single-InstanceRedoApply

MRPProcesses

MRPProcesses

StandbyInstance1

RFSProcess

CoordinatorProcess

MRPProcesses

StandbyInstance2

RFSProcess

CoordinatorProcess

MRPProcesses

StandbyInstance3

RFSProcess

PrimaryInstance1

ASYNC/SYNCProcess

PrimaryInstance2

ASYNC/SYNCProcess

PrimaryInstance3

ASYNC/SYNCProcess

Thread1Redo

Thread2Redo

Thread3Redo

SRL

SRL

SRL

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

42

Multi-InstanceRedoApply

CoordinatorProcess

MRPProcesses

StandbyInstance1

RFSProcess

CoordinatorProcess

MRPProcesses

StandbyInstance2

RFSProcess

CoordinatorProcess

MRPProcesses

StandbyInstance3

RFSProcess

PrimaryInstance1

ASYNC/SYNCProcess

PrimaryInstance2

ASYNC/SYNCProcess

PrimaryInstance3

ASYNC/SYNCProcess

Thread1Redo

Thread2Redo

Thread3Redo

SRL

SRL

SRL

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

Multi-InstanceRedoApply

• Parallel,multi-instancerecovery:standbywillkeepup– Standbyrecovery-utilizesCPUandIOacrossallnodesofRACstandby

– Haveseen3500MB+/secapplyrateonan8nodeRAC

• Multi-InstanceApplyrunsonallMOUNTEDinstancesorallOPENInstances•  ExposedintheBrokerwiththe‘ApplyInstances’propertyonastandbydatabase

43

recover managed standby database disconnect using instances 4;

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

DatabaseIn-MemoryandActiveDataGuard

•  In-memoryDBonActiveDataGuard– CreateIMCtablesandcolumnsforanalyticsonActiveDataGuard– Canpopulatewithdifferentdatathanproductiondatabase• Offloadevenmoretoyourstandby!

44

MonthIn-Memory

YearIn-Memory

StandbyPrimary

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

DiagnosticsandTuningforActiveDataGuard

•  SupportforDiagnosticPack(AWR)

•  SupportforTuningPackfeaturesandSQLPlanAnalyzer

45

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

AWRSupportforRemoteSnapshots

•  InOracleDatabase12cRelease2,theAWRframeworkisenhancedtosupportcaptureofremotesnapshotsfromanygenericdatabaseincludingActiveDataGuard(ADG)databases.– Atargetcatalogdatabasecollectssnapshotsfromtheremotedatabases(sources)– Snapshotscanbecollectedautomaticallyormanually– AWRtablesonthecatalogdatabaseaccumulatesnapshotdatafromallsourcesviadatabaselinks

– SourcedatabasesmustberegisteredonthecatalogvianewDBMS_WORKLOAD_REPOSITORY.REGISTER_REMOTE_DATABASEAPI

46

OnanActiveDataGuardStandby

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

SQLTuningAdvisorSupportforActiveDataGuard

• AllSQLTuningAdvisortasksissuedatthestandby– Createtuningtask,executetuningtaskandimplementSQLTuningAdvisorrecommendations

– Testexecution(heavylifting)happensonstandby•  Onlyminimalwriterelatedactivityonprimary

• Requireddatafetchedfromprimaryoveradatabaselinkfromstandby•  Taskdetailsandtuningresultsarestoredatprimaryandtheessentialdatarequiredtoconstructthereportisaccessedremotelyfromprimary•  Thereportisconstructedlocallyatthestandby,withnoCPUoverheadinprimary

47

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

Featurelist•  Fasterqueryresponsewithfasterredoapply– Multi-InstanceRedoApplyonADGnowsupportsIn-MemoryColumnar&Block-changetracking

•  ExtendADGenvironmentsforDataWarehousing– ADGsupportforNologgingworkloads•  FasterapplicationresponseafterADGroletransition– PreserveBufferCacheonADGafterroletransition• ProtectPrimarydatabasefromlostwritestoragefailures– NewLostwritedetectioncapabilityusingshadowtablespacesatPrimary

48

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

Multi-InstanceRedoApplyenhancements• Multi-InstanceRedoApplyallowsallstandbynodestoparticipateinrecovery•  In-memoryDB(IMC)onActiveDataGuardallows:*–  CreationofIMCtablesandcolumnsforanalyticsonActiveDataGuard–  Populationwithdifferentdatathanproductiondatabase–  Offloadingevenmoretoyourstandby!

• Multi-InstanceRedoapplyalsoworkswithBCT*AvailableonlyonExadataandOracleCloudOfferings

49

MonthIn-Memory

YearIn-Memory

StandbyPrimary

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

DataGuardandNoForceLogging*

•  ExtendedtoprovidebettersupportinanActiveDataGuardenvironmentwithoutsignificantlyincreasingtheamountofredogenerated.•  Twonewmodesareaddedasalternativestotheexistingnologgingmode– StandbyNologgingforLoadPerformance•  Ensuresthatstandbyswillreceivethenonloggeddatachangeswiththeminimumimpacttothespeedofloadingattheprimary– Thestandbycantransientlyhavenonloggedblocks.Thesenonloggedblockswillbeautomaticallyresolvedbymanagedstandbyrecovery.

– StandbyNologgingforDataavailability•  Ensuresallstandbyshavethedatawhentheprimaryloadcommitsbutatthecostofthrottlingthespeedofloadingdataattheprimary– Thestandbyswillneverhaveanynonloggedblocks.

50

*AvailableonEngineeredSystemsandOracleCloudonly

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

CreatingGTTsonActiveDataGuard• CreatingGTTstodaywillfailwhenexecutedonActiveDataGuard•  In18.1.0.0CREATE GLOBAL TEMPORARY TABLEonActiveDataGuardwill:– CreatetheGTTonthePrimary– WaitfortheGTTtobereplicatedandappliedtotheActiveDataGuardstandby– Returncontroltotheuser

51

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

ExecutingDMLonActiveDataGuard

• DMLRe-directionautomaticallyperformedfromActiveDataGuardstandbytothePrimarywithoutcompromisingACID– Enabledbysettingparameter“_enable_proxy_adg_redirect=TRUE”andappropriateconnectivityparameters•  StandbyADGsessionwaitsforupdatestoshowuponADGviaredoapply•  DMLdatare-directedbyanADGsessionisonlyvisibletothatsessionbeforecommit•  DMLdatare-directedisvisibletoallsessionsafterADGsessioncommits

– RespectsACIDpropertiesofadatabaseforADGsession– Targetedfor“ReadMostlyOccasionalUpdates”applications

52

RestrictedsupportforDMLRe-direction

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

NewBrokerDGMGRLcommands•  EnhancedScriptingandExecution– SETECHO|DEBUGON|OFF– SHOWALL•  ShowscurrentDGMGRLsettings

53

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

NewBrokerVALIDATEcommands• VALIDATEDATABASESPFILE– ValidateparameterssettingsbetweenthePrimaryandaStandbydatabase.

• VALIDATENETWORKCONFIG– Validatethenetworksetupbetweenalldatabasesintheconfiguration• VALIDATESTATICCONNECTIDENTIFIER– VerifythestaticconnectidentifiersetupinNon-CRSdatabases

54

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

Q&A

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|

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

56

Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.| 57

top related