Oracle Active Data Guard 12c: Far Sync Instance, Real-Time Cascade and Other Goodies!

2014 © Trivadis BASEL BERN BRUGG LAUSANNE ZUERICH DUESSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MUNICH STUTTGART VIENNA Data Guard 12c: Far Sync Instance, Real-Time Cascade Standby and other goodies Ludovico Caldara Oracle ACE, Senior Consultant Trivadis SA 02.10.2014 Oracle Active Data Guard 12c 1

2014 © Trivadis About Ludovico Caldara 2 ■14 Years DBA (started with 7.3.4) ▪I do it everywhere (also on Windows) ■RAC ATTACK Ninja & co-writer ■RAC SIG Board member ■OCP (11g, 12c, MySQL) & OCE ■Italian Living in Switzerland ■http://www.ludovicocaldara.net ■@ludodba ■ludovicocaldara

2014 © Trivadis Trivadis is a market leader in IT consulting, system integration, solution engineering and the provision of IT services focusing on and technologies in Switzerland, Germany and Austria. We offer our services in the following strategic business fields: Trivadis Services takes over the interacting operation of your IT systems. O P E R A T I O N About

2014 © Trivadis 4 11 Trivadis branches and more than 600 employees 200 Service Level Agreements Over 4,000 training participants Research and development budget: CHF 5.0 / EUR 4 million Financially self-supporting and sustainably profitable Experience from more than 1,900 projects per year at over 800 customers Hamburg Düsseldorf Frankfurt Freiburg Munich Vienna Basel Zurich Bern Lausanne 4 Stuttgart Over 600 specialists and IT experts in the DACH region

2014 © Trivadis AGENDA 1.Real-Time Cascade Standby 2.Far-Sync Instances 3.Other goodies ;-) 4.Q&A 02.10.2014 Oracle Active Data Guard 12c 5

2014 © Trivadis 02.10.2014 Oracle Active Data Guard 12c Real-Time Cascade Standby 6

2014 © Trivadis Cascade Standby 7 PRIMARY CASCADING CASCADED

2014 © Trivadis Cascade Standby in 11gR2 8 ARCH or LGWR (SYNC, ASYNC) ARCH ONLY!! Supported by the broker Not possible with 11g broker! Only manual configuration of LOG_ARCHIVE_DEST_n!

2014 © Trivadis Cascade Standby in 12cR1 9 SYNC, FASTSYNC or ASYNC (LGWR) ASYNC (LGWR) <none> (ARCH) Cascade now supported by the 12c broker

2014 © Trivadis Cascade Standby Without Broker 12 PROD DR REP

2014 © Trivadis Cascade Standby Without Broker 13 PROD LOG_ARCHIVE_DEST_2=‘SERVICE=DR, SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)’ DR REP

2014 © Trivadis Cascade Standby Without Broker 14 PROD LOG_ARCHIVE_DEST_2=‘SERVICE=DR, SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)’ DR REP LOG_ARCHIVE_DEST_2=‘SERVICE=REP, ASYNC NOAFFIRM VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE)’

2014 © Trivadis Cascade Standby Without Broker 15 PROD LOG_ARCHIVE_DEST_2=‘SERVICE=DR, SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)’ DR REP LOG_ARCHIVE_DEST_2=‘SERVICE=REP, ASYNC NOAFFIRM VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE)’ REAL-TIME CASCADE AND ACTIVE DATA GUARD

2014 © Trivadis Cascade Standby Without Broker 16 PROD LOG_ARCHIVE_DEST_2=‘SERVICE=DR, SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)’ DR REP LOG_ARCHIVE_DEST_2=‘SERVICE=DR, SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)’ LOG_ARCHIVE_DEST_2=‘SERVICE=REP, ASYNC NOAFFIRM VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE)’

2014 © Trivadis Cascade Standby Without Broker 17 PROD LOG_ARCHIVE_DEST_2=‘SERVICE=DR, SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)’ DR REP LOG_ARCHIVE_DEST_2=‘SERVICE=DR, SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)’ LOG_ARCHIVE_DEST_2=‘SERVICE=PROD, ASYNC NOAFFIRM VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)’ LOG_ARCHIVE_DEST_2=‘SERVICE=REP, ASYNC NOAFFIRM VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE)’

2014 © Trivadis Cascade Standby with 12cR1 Broker 18 PROD DR REP RedoRoutes=‘(LOCAL : DR)’ RedoRoutes=‘ (PROD : REP ASYNC) (REP : PROD ASYNC) (LOCAL : REP , PROD)’ RedoRoutes=‘(LOCAL:DR)’

2014 © Trivadis Cascade Standby with 12cR1 Broker 19 PROD DR REP RedoRoutes=‘(LOCAL : DR)’ RedoRoutes=‘ (PROD : REP ASYNC) (REP : PROD ASYNC) (LOCAL : REP , PROD)’ RedoRoutes=‘(LOCAL:DR)’

2014 © Trivadis Cascade Standby with 12cR1 Broker 20 PROD DR REP RedoRoutes=‘(LOCAL : DR)’ RedoRoutes=‘ (PROD : REP ASYNC) (REP : PROD ASYNC) (LOCAL : REP , PROD)’ RedoRoutes=‘(LOCAL:DR)’ REAL-TIME CASCADE AND ACTIVE DATA GUARD

2014 © Trivadis Real-Time Cascade: Little demo? 21 O12p01 PROD O12p02 DR O12p03 REP

2014 © Trivadis 02.10.2014 Oracle Active Data Guard 12c Far-Sync Instances 22

2014 © Trivadis High distances = High latencies 23 Too far to support SYNC redo-transport ASYNC ONLY!!

2014 © Trivadis Solution with 11gR2 24 ASYNC REMOTE SYNC LOCAL

2014 © Trivadis Solution with 11gR2 25 ASYNC REMOTE SYNC LOCAL

2014 © Trivadis Solution with 12cR1 26 FAR_SYNC Instance SYNC LOCAL ASYNC REMOTE

2014 © Trivadis FAR_SYNC instance characteristics 1.Special controlfile ALTER DATABASE CREATE FAR SYNC INSTANCE CONTROLFILE; 2.NO datafiles and NO redo-apply 3.Standby logs are written and archived 4.The redo stream is redirected to the standby 5.Can’t be opened or converted to standby or primary 30 02.10.2014 Oracle Active Data Guard 12c

2014 © Trivadis One FAR_SYNC for each location 31 SYNC LOCAL ASYNC REMOTE FS_PROD FS_DR PROD DR REP

2014 © Trivadis One FAR_SYNC for each location 32 SYNC LOCAL ASYNC REMOTE FS_PROD FS_DR PROD DR REP

2014 © Trivadis FASTSYNC Log Transport Mode 1.table 2.No need to acknowledge the write on remote Standby Logs 3.Can be used with Maximum Availability 4.The commit overhead is due by the network only and not by the remote disk latencies LogXptMode Transport Acknowledge SYNC SYNC AFFIRM ASYNC ASYNC NOAFFIRM FASTSYNC SYNC NOAFFIRM 02.10.2014 Oracle Active Data Guard 12c

2014 © Trivadis Temporary UNDO: GTTs for ADG! 36 UNDO TBS TEMP TBS TEMP_UNDO_ENABLED = TRUE GLOBAL TEMPORARY TABLE DATA TBS SYSTEM TBS DATA & UNDO READ ONLY DATAFILES

2014 © Trivadis Temporary UNDO: GTTs for ADG! 37 UNDO TBS TEMP TBS TEMP_UNDO_ENABLED = TRUE GLOBAL TEMPORARY TABLE DATA TBS SYSTEM TBS DATA & UNDO READ ONLY DATAFILES

2014 © Trivadis VALIDATE DATABASE 41 DGMGRL> VALIDATE DATABASE ‘DR'; Database Role: Physical standby database Primary Database: South_Sales Ready for Switchover: Yes Ready for Failover: Yes (Primary Running) Flashback Database Status: PROD: On DR: Off . . .

2014 © Trivadis SQL Apply & Rolling Upgrades 1.SQL Apply enhanced: Text, Multimedia, Spatial Virtual columns Securefiles with dedup. 2.New DBMS_ROLLING is simplifying rolling upgrades Easy syntax and flow Needs Active Data Guard Option (again ) 02.10.2014 Oracle Active Data Guard 12c

2014 © Trivadis Other DataGuard improvements 1.New property ApplyLagThreshold raises a warning when the apply lag is too high (useless with DelayMins parameter) 2.New property TransportLagThreshold raises a warning when the transport lag is too high 3.New administrative privilege SYSDG (dgdba OS group) 02.10.2014 Oracle Active Data Guard 12c

2014 © Trivadis Two words about DG & Multitenant 1.Shared redo stream = The whole CDB has one role at time 2.No PDB granularity 3.All standby commands must be run into the root CDB 4.Creating PDB from seed is ok 5.Cloning PDBs depends on ADG 02.10.2014 Oracle Active Data Guard 12c

2014 © Trivadis Two words about Global Data Services 1.Evolution of Connection Manager 2.Slightly integrated with DG, GG, Advanced Replication 3.As of now, it works only when using Policy-Managed Clusters 4.Intelligent routing based on apply lag, region, workload 5.Requires ADG or GG licenses 02.10.2014 Oracle Active Data Guard 12c

2014 © Trivadis Questions and answers ... BASEL BERN BRUGG LAUSANNE ZUERICH DUESSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MUNICH STUTTGART VIENNA Ludovico Caldara Oracle ACE, Senior Oracle Consultant ludovico.caldara@trivadis.com @ludodba 02.10.2014 Oracle Active Data Guard 12c 48

Oracle Active Data Guard 12c: Far Sync Instance, Real-Time Cascade and Other Goodies!

More Related Content

What's hot

Viewers also liked

Similar to Oracle Active Data Guard 12c: Far Sync Instance, Real-Time Cascade and Other Goodies!

More from Ludovico Caldara

Recently uploaded

Oracle Active Data Guard 12c: Far Sync Instance, Real-Time Cascade and Other Goodies!