![Page 1: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/1.jpg)
![Page 2: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/2.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuard12.2-18c
UweKirchhoffTechnicalArchitectACSGlobalDelivery
![Page 3: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/3.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
SafeHarborStatementThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.
3
![Page 4: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/4.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuardProposedEnhancements
Manageability
Protection
Performance
PlannedMaintenance
ClientFailover
1
2
3
4
5
4
![Page 5: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/5.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
ManageabilityEnhancements12candBeyond
5
![Page 6: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/6.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuard-Manageability
• CreateDataGuardStandbyswithDatabaseCreationAssistant(DBCA)• RMANDUPLICATEforFarSync• EnterpriseManagersupportforFarSynccreation• EMCLIstandbydatabasecreation
6
StandbyCreation
![Page 7: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/7.jpg)
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
![Page 8: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/8.jpg)
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';}
![Page 9: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/9.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
EnterpriseManagerCloudControl
• YouwillalsobeabletocreateFarSyncInstancesusinganew,butfamiliarEMCCcreationWizard
9
FarSyncCreationandManagement
![Page 10: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/10.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.| 10
FarSyncCreationandManagementEnterpriseManagerCloudControl
![Page 11: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/11.jpg)
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
![Page 12: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/12.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuard-Manageability
• RESTfulServicesInterface– Creating,MonitoringandManagingaDataGuardBrokerConfiguration
• OracleDataGuardforDataWarehouses-NoLoggingsupport• SubsetStandbys• AutomaticallySynchronizePasswordFiles• TDETablespaceOfflineConversion
12
EaseofUse
![Page 13: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/13.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
DataGuardandNoForceLogging
• No-Loggingoperationsonlygenerateenoughredototellthestandbythatsomeblocksarenowunrecoverable.– Repairingthemmeantrestoringthecompleteaffecteddatafiles.
• No-LoggingblockswillbetrackedbythePrimarydatabase• StandbyscanthenbeeasilyrepairedusingRMAN– Validationandrepaironlyofblocksonstandbythatwereinvalidatedbynon-loggedoperations(suchasdirectloads)ontheprimary
– ThiswillquerythePrimaryforblocklocationsthatcontainnon-loggedblocksandrepairthestandbydatabase.
13
rman validate/recover .. nonlogged block
![Page 14: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/14.jpg)
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?
![Page 15: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/15.jpg)
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
![Page 16: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/16.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
TDETablespaceConversion
• Offlinedatafilemethodstillavailable– CompletewithPhysicalStandbymethod
• AnewSQLcommandwillarriveonthescene!
• Encryptsalldatafilesinthetablespaceonline.– Primaryonly&Requiresauxiliarydiskspace
• CanalsobedoneOFFLINEforbetterperformance– NoExtrastorage,butrequiresdataoutageonPrimary.– OfflinecanbedoneonaPhysicalStandbyfirstaswiththepreviousexample
16
(>=12.2)
alter tablespace users encryption encrypt
![Page 17: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/17.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuard-Manageability
• DGMGRLCommandImprovements• BrokerConfiguration-WideServiceName• SimplifiedObserverManagementformultipleFast-StartFailoverconfigurations
17
BrokerGeneralEnhancements
![Page 18: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/18.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
NewDGMGRLcommands
• EnhancedScriptingandExecution– Scriptexecutionvia‘@’– RepeatpreviousDGMGRLcommandwith‘/’– Executeoperatingsystemcommandwith‘HOST’or‘!’– Storeoutputinafilewith‘SPOOL’– Displaytimestampinpromptvia‘SETTIMEON/OFF’
18
![Page 19: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/19.jpg)
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'
![Page 20: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/20.jpg)
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;
![Page 21: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/21.jpg)
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))))
![Page 22: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/22.jpg)
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
![Page 23: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/23.jpg)
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
![Page 24: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/24.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
ProtectionEnhancements12candBeyond
24
![Page 25: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/25.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuard-Protection
• EnhancedAutomaticBlockRecovery• Zero-datalossFast-startFailoveruponstoragefailureeveninasyncmode– Ifinstancefails,shipsallredodataaccumulatedinlogbuffertostandby
• OracleDataGuardDatabaseCompare• EnhancedAlternateDestinations• BrokerProtectionEnhancements• DisasterRecoveryintheCloud
25
EnhancedProtection
![Page 26: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/26.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
EnhancedAutomaticBlockRecovery
• ActiveDataGuardAutomaticBlockRepairintroducedin11gRelease2
• Blockslikefileheadersetcwerenotrepaired.• InOracleDatabase12cRelease2thetypesofcorruptedblocksthatcanberepairedincreases!
26
ActiveStandbyDatabase
PrimaryDatabase
Read/WriteWorkload
Continuousredoshipping,validation&apply
Real-timeReporting
![Page 27: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/27.jpg)
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
![Page 28: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/28.jpg)
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"
![Page 29: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/29.jpg)
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
![Page 30: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/30.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
EnhancedAlternateDestinations• Alternatedestinationsgotmuchbetterin12.1– Butfailbacktothefirstdestinationhappenedwhetherornotyouwantedit– Andyoulostfailbackifyouconfiguredmorethanonealternate.
• Soin12.2wethrewawaytheALTERNATEattributeofredotransport– Replacingitwith2newattributes-GROUPandPRIORITY• GROUPsaysweareallpotentialalternatesofeachotherinthesamegroup• PRIORITYtellsDataGuardwhentofailbacktotheoriginaltargetbetweengroups
• Didyougetallthat?– Ididn’tthinkso,thisismygiveyouaheadachefeature.– Let’slookatanexample
30
![Page 31: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/31.jpg)
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
![Page 32: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/32.jpg)
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
![Page 33: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/33.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
ImprovedAlternateDestinations
• NormalSteadyState
33
Howaboutapicture?
PrimaryTS1FS1
TS2
FS2
SYNCASYNC
![Page 34: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/34.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
ImprovedAlternateDestinations
• FarSyncFS1Fails(StayinPriority1)
34
Howaboutapicture?
PrimaryTS1FS1
TS2
FS2
SYNCASYNC
![Page 35: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/35.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
ImprovedAlternateDestinations
• FarSyncFS1comesback(StayinPriority1,Nofailback)
35
Howaboutapicture?
PrimaryTS1FS1
TS2
FS2
SYNCASYNC
![Page 36: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/36.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
ImprovedAlternateDestinations
• FarSyncFS2FailsandFS1isstillnotavailable(MovetoPriority8)
36
Howaboutapicture?
PrimaryTS1FS1
TS2
FS2
SYNCASYNC
![Page 37: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/37.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
ImprovedAlternateDestinations
• FarSyncFS1comesback(MovebacktoPriority1)
37
Howaboutapicture?
PrimaryTS1FS1
TS2
FS2
SYNCASYNC
![Page 38: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/38.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuard-Protection
• BlockComparisonToolSupportinDGMGRL– Shownintheearlierexample
• MultipleAutomaticFailoverTargets• MultipleObservers• Fast-StartFailoverinMaximumProtectionMode• SupportforEnhancedAlternateDestination• SupportforTransportDestinationsofDifferentEndianess– Cross-endianDataGuard:AIXtoRecoveryAppliance
38
BrokerProtectionImprovements
![Page 39: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/39.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
PerformanceEnhancements12candBeyond
39
![Page 40: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/40.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDataGuard-Performance
• Multi-InstanceRedoApply– OracleDataGuardBrokerSupport• DatabaseIn-MemoryonanOracleActiveDataGuardStandbyDatabase• ActiveDataGuardsupportforDiagnosticPackfeatures• ActiveDataGuardSupportforSQLTuningAdvisor
40
PerformanceandTuningEnhancements
![Page 41: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/41.jpg)
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
![Page 42: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/42.jpg)
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
![Page 43: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/43.jpg)
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;
![Page 44: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/44.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
DatabaseIn-MemoryandActiveDataGuard
• In-memoryDBonActiveDataGuard– CreateIMCtablesandcolumnsforanalyticsonActiveDataGuard– Canpopulatewithdifferentdatathanproductiondatabase• Offloadevenmoretoyourstandby!
44
MonthIn-Memory
YearIn-Memory
StandbyPrimary
![Page 45: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/45.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
DiagnosticsandTuningforActiveDataGuard
• SupportforDiagnosticPack(AWR)
• SupportforTuningPackfeaturesandSQLPlanAnalyzer
45
![Page 46: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/46.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
AWRSupportforRemoteSnapshots
• InOracleDatabase12cRelease2,theAWRframeworkisenhancedtosupportcaptureofremotesnapshotsfromanygenericdatabaseincludingActiveDataGuard(ADG)databases.– Atargetcatalogdatabasecollectssnapshotsfromtheremotedatabases(sources)– Snapshotscanbecollectedautomaticallyormanually– AWRtablesonthecatalogdatabaseaccumulatesnapshotdatafromallsourcesviadatabaselinks
– SourcedatabasesmustberegisteredonthecatalogvianewDBMS_WORKLOAD_REPOSITORY.REGISTER_REMOTE_DATABASEAPI
46
OnanActiveDataGuardStandby
![Page 47: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/47.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
SQLTuningAdvisorSupportforActiveDataGuard
• AllSQLTuningAdvisortasksissuedatthestandby– Createtuningtask,executetuningtaskandimplementSQLTuningAdvisorrecommendations
– Testexecution(heavylifting)happensonstandby• Onlyminimalwriterelatedactivityonprimary
• Requireddatafetchedfromprimaryoveradatabaselinkfromstandby• Taskdetailsandtuningresultsarestoredatprimaryandtheessentialdatarequiredtoconstructthereportisaccessedremotelyfromprimary• Thereportisconstructedlocallyatthestandby,withnoCPUoverheadinprimary
47
![Page 48: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/48.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
Featurelist• Fasterqueryresponsewithfasterredoapply– Multi-InstanceRedoApplyonADGnowsupportsIn-MemoryColumnar&Block-changetracking
• ExtendADGenvironmentsforDataWarehousing– ADGsupportforNologgingworkloads• FasterapplicationresponseafterADGroletransition– PreserveBufferCacheonADGafterroletransition• ProtectPrimarydatabasefromlostwritestoragefailures– NewLostwritedetectioncapabilityusingshadowtablespacesatPrimary
48
![Page 49: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/49.jpg)
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
![Page 50: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/50.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
DataGuardandNoForceLogging*
• ExtendedtoprovidebettersupportinanActiveDataGuardenvironmentwithoutsignificantlyincreasingtheamountofredogenerated.• Twonewmodesareaddedasalternativestotheexistingnologgingmode– StandbyNologgingforLoadPerformance• Ensuresthatstandbyswillreceivethenonloggeddatachangeswiththeminimumimpacttothespeedofloadingattheprimary– Thestandbycantransientlyhavenonloggedblocks.Thesenonloggedblockswillbeautomaticallyresolvedbymanagedstandbyrecovery.
– StandbyNologgingforDataavailability• Ensuresallstandbyshavethedatawhentheprimaryloadcommitsbutatthecostofthrottlingthespeedofloadingdataattheprimary– Thestandbyswillneverhaveanynonloggedblocks.
50
*AvailableonEngineeredSystemsandOracleCloudonly
![Page 51: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/51.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
CreatingGTTsonActiveDataGuard• CreatingGTTstodaywillfailwhenexecutedonActiveDataGuard• In18.1.0.0CREATE GLOBAL TEMPORARY TABLEonActiveDataGuardwill:– CreatetheGTTonthePrimary– WaitfortheGTTtobereplicatedandappliedtotheActiveDataGuardstandby– Returncontroltotheuser
51
![Page 52: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/52.jpg)
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
![Page 53: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/53.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
NewBrokerDGMGRLcommands• EnhancedScriptingandExecution– SETECHO|DEBUGON|OFF– SHOWALL• ShowscurrentDGMGRLsettings
53
![Page 54: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/54.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
NewBrokerVALIDATEcommands• VALIDATEDATABASESPFILE– ValidateparameterssettingsbetweenthePrimaryandaStandbydatabase.
• VALIDATENETWORKCONFIG– Validatethenetworksetupbetweenalldatabasesintheconfiguration• VALIDATESTATICCONNECTIDENTIFIER– VerifythestaticconnectidentifiersetupinNon-CRSdatabases
54
![Page 55: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/55.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
Q&A
![Page 56: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/56.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.|
SafeHarborStatementTheprecedingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.
56
![Page 57: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/57.jpg)
Copyright©2015,Oracleand/oritsaffiliates.Allrightsreserved.| 57
![Page 58: Oracle Data Guard 12.2 - 18c - doag.org · • In Oracle Database 12c Release 2, a storage failure at the primary database will be handled by the Oracle Data Guard Asynchronous process](https://reader037.vdocuments.us/reader037/viewer/2022100220/5c774f3909d3f2a94e8bafd7/html5/thumbnails/58.jpg)