Set Up Unparalleled Data Protection with Oracle Active Data Guard 23ai [TUT3135].pdf

1、Set Up UnparalleledData Protection withOracle Active Data Guard 23aiLudovico CaldaraOctober 11th,2024Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates1AgendaOracle CloudWorld Copyright 2024,Oracle and/or its affiliates2Welcome and IntroductionOverview:Oracle Active Data Guard 23aiIntrodu

2、ction to the workshop environmentWrap-up and next stepsWelcome and IntroductionSet Up Unparalleled Data Protection with Oracle Active Data Guard 23aiOracle CloudWorld Copyright 2024,Oracle and/or its affiliates3Ludovico CaldaraSenior Principal Product ManagerOracleSinan Petrus TomaPrincipal Product

3、ManagerOracleNitin KarkhanisSoftware Development Senior DirectorOracleOracle CloudWorld Copyright 2024,Oracle and/or its affiliates4Click to edit TitleTuesday,September 10th Wednesday,September 11thThursday,September 12th Visit us all weekat our demo booth on the demo groundsMAA with Oracle RAC,Data

4、 Guard,ZDM,ZRCV and Full Stack DR Tuesday 10 am 7 pm Wednesday 7:30 am 6 pm Thursday 9 am 1:30 pmOracle Database 23ai High Availability New Features Tips and TricksLRN2954|8:30-9:15 am|Galileo 902,The Venetian,Level 1Deep Dive into Oracle Data Guard 23aiLRN2997|9:00-9:45 am|Titian 2306,The Venetian,

5、Level 2Application Continuity with Oracle Database 23aiLRN3303|9:45-10:30 am|Venetian Level 2:GOracle Real Application Clusters(RAC)23ai Smart Features Tips and TricksPAN2949|10:15 11:00 am|Titian 2302,The Venetian,Level 2Set Up Unparalleled Data Protection with Active Data Guard 23aiTUT3135|11:00 a

6、m 1:00 pm|Casanova 502,The Venetian,Level 1The Future of OLTP:Hyperscaling and Generative Development Roundtable 11:15 am-1:00 pmOracle Maximum Availability Architecture Best Practices:Everywhere and AnywhereLRN3003|2:45-3:30 pm|Galileo 1001,The Venetian,Level 1 Disaster Strikes?Be a Disaster Recove

7、ry hero in 90 min using OCI Full Stack DRTUT3061|1:30 pm 3:30 pm|Casanova 504,The Venetian,Level 1https:/ An Oracle MAA Zero Downtime Migration to DatabaseAzure&DatabaseGoogle CloudLRN3001|4:45 5:30 pm|Galileo 904,The Venetian,Level 1OverviewSet Up Unparalleled Data Protection with Oracle Active Dat

8、a Guard 23aiOracle CloudWorld Copyright 2024,Oracle and/or its affiliates6Oracle Active Data GuardOracle CloudWorld Copyright 2024,Oracle and/or its affiliates7SCALE-OUT FARMreads and occasional writesPrimaryDatabaseFARSYNCZero data lossat any distanceAutomatic failoverand transaction replaywithout

9、split brain or data lossEnd-to-end validationagainst corruptionsand ransomware attacksReal-timecascaded standbysClones forthe developersRemote Disaster RecoveryOffload compression&encryptionTransient Logical Standbyfor major maintenancewithout downtimeIsolated NetworkResilveringSnapshot Standby+Flas

10、hback DatabaseDML RedirectionSCALE AS YOU GROWMODERN DEVELOPMENT PLATFORMONLINE MAINTENANCECOMPREHENSIVE DATA PROTECTIONGLOBAL DATA SERVICESStandbyDatabaseStandby DatabasesStandby DatabasesLab 1:Prepare the database hostsOracle CloudWorld Copyright 2024,Oracle and/or its affiliates8adghol0_ Cloud Sh

11、elladghol1SQL*Net configuration12321SSH connections3TDE and passwordfile copy2Lab 2:Prepare the databasesOracle CloudWorld Copyright 2024,Oracle and/or its affiliates9ARCHIVELOGFORCE LOGGINGFLASHBACK ONDELETION POLICYSPFILE CREATIONDB_UNIQUE_NAMESTANDBY LOGSPARAMETERSadghol1adghol0123123Prepare the

12、primaryDelete the second databaseRestore from primary4Finish the standby preparation4STANDBY LOGSPARAMETERSLab 3 and 4:Configure and verify Data GuardOracle CloudWorld Copyright 2024,Oracle and/or its affiliates10adghol1adghol0123Configure Data Guard with the brokerReview the configurationEnable fla

13、shback on the standbyData Guard Broker123Lab 5:Create role-based servicesOracle CloudWorld Copyright 2024,Oracle and/or its affiliates11adghol1adghol01Create role-based servicesRWROLab 6:Transparent Application ContinuityOracle CloudWorld Copyright 2024,Oracle and/or its affiliates12adghol1adghol01S

14、tart a transactionRWRWAutomaticTransactionReplaySwitchover2Switchover3Commit the transactionCOMMITINSERT123Lab 7:Snapshot StandbyOracle CloudWorld Copyright 2024,Oracle and/or its affiliates13adghol1adghol01Convert to snapshot standbyRWSNAP2Do some writes on the standby3Convert back to physical stan

15、dby213Lab 8:Real-Time Query and DML RedirectionOracle CloudWorld Copyright 2024,Oracle and/or its affiliates14adghol1adghol01Open the standby databaseRWRO2Enable SYNC replication3Read with external consistency2134Write on the standby databaseSYNCSELECTUPDATE4DML IS REDIRECTED TO PRIMARYDMLIS APPLIED

16、 TO PRIMARYDATA CHANGE IS STREAMED BACKLab 9:AWR Reports on the standby databaseOracle CloudWorld Copyright 2024,Oracle and/or its affiliates15adghol1adghol01Create the AWR snapshotsRWRO2Create the report1SNAPSHOT IS STOREDON THE PRIMARY2Introduction to the workshop environmentSet Up Unparalleled Da

17、ta Protection with Oracle Active Data Guard 23aiOracle CloudWorld Copyright 2024,Oracle and/or its affiliates16Showcasing how Oracles solutions solve your business problems available 24/7 for free!17Oracle CloudWorld Copyright 2024,Oracle and/or its affiliatesOracle LiveLabs1000+events run using Liv

18、eLabsworkshops700+free workshops,available or in development10 millionpeople have already visited LiveLabsLaptopOracle AccountRequirements for running a Hands-on-LabOracle CloudWorld Copyright 2024,Oracle and/or its Hands-on-Lab19Oracle CloudWorld Copyright 2024,Oracle and/or its a web browser2.Navi

19、gate to the provided URL3.Use your Oracle SSO account to log in Please note:This is NOT your Oracle Cloud Infrastructure accountOracle CloudWorld Copyright 2024,Oracle and/or its affiliates20Lets get the Start button to access the HOL2.Click Run on LiveLabs Sandbox3.Toggle the Start Workshop Now rad

20、io button4.Check the consent box5.Click Submit ReservationOracle CloudWorld Copyright 2024,Oracle and/or its affiliates21Lets get Launch Workshop once availablePlease note:The environments are available in a couple of minutes.Refresh the pageOracle CloudWorld Copyright 2024,Oracle and/or its affilia

21、tes22Lets get View Login Info2.Click Launch OCI to proceed to your workshop environmentOracle CloudWorld Copyright 2024,Oracle and/or its affiliates23Lets get Hands-on-Lab24Oracle CloudWorld Copyright 2024,Oracle and/or its affiliatesNeed Help?Set Up Unparalleled Data Protection with Oracle Active D

22、ata Guard 23aiOracle CloudWorld Copyright 2024,Oracle and/or its affiliates25Self-ServiceWatch the videos in beginning of each labGet help Self-ServiceFind the Need help?section in the sidebar of the workshopAsk us!I need help!Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates26Wrap up an

23、d next stepsSet Up Unparalleled Data Protection with Oracle Active Data Guard 23aiOracle CloudWorld Copyright 2024,Oracle and/or its affiliates273 membership tiers:Connect:oracleaceF experts helping peers globallyThe Oracle ACE Program recognizes and rewards community members for their technical and

24、 community contributions to the Oracle communityNominate yourself or someone you know: more details on Oracle ACE Program:Subtitle goes hereThank YouClick to add textOracle CloudWorld Copyright 2024,Oracle and/or its affiliates29Subtitle goes hereThank YouClick to add textOracle CloudWorld Copyright 2024,Oracle and/or its affiliates30