ZDLRA @ METRONOM 1 0 .2 4 .2 0 1 8 1 I ntroduction Agenda 2 - - PowerPoint PPT Presentation

▶
zdlra metronom
SMART_READER_LITE
LIVE PREVIEW

ZDLRA @ METRONOM 1 0 .2 4 .2 0 1 8 1 I ntroduction Agenda 2 - - PowerPoint PPT Presentation

Feb 04, 2024 355 likes •523 views

ZDLRA @ METRONOM 1 0 .2 4 .2 0 1 8 1 I ntroduction Agenda 2 Mission 3 Best Practices 4 Target 5 Sum m ary I ntroduction 3 I ntroduction I ntroduction Team of 1 3 DBAs ~ 2 1 0 0 Oracle databases AI X, Linux, W indow s -

slide-1
SLIDE 1

ZDLRA @ METRONOM

1 0 .2 4 .2 0 1 8

slide-2
SLIDE 2

Agenda

I ntroduction Mission Best Practices Target Sum m ary

1 2 3 4 5

slide-3
SLIDE 3

3

I ntroduction

slide-4
SLIDE 4

I ntroduction

slide-5
SLIDE 5

I ntroduction

Team of 1 3 DBAs

  • ~ 2 1 0 0 Oracle databases
  • AI X, Linux, W indow s - Servers
  • Database features including:
  • RAC
  • Data Guard
  • GoldenGate for Minimal Downtime

Maintenance (MDM)

slide-6
SLIDE 6

6

Mission

slide-7
SLIDE 7

Mission

  • Started POC in 2 0 1 6
  • Replication betw een tw o DCs
  • Easy Migration
  • Go Live April 2 0 1 7
  • Backup of m ore than 3 5 0 productive

databases by end of 2 0 1 7

  • Zero Dow ntim e
slide-8
SLIDE 8

8

Best Practices

slide-9
SLIDE 9

Easy m igration

  • Calculate how much space is needed
  • Enroll the database to the local ZDLRA
  • Grant access to the protected database to

a backup user

  • Modify sqlnet.ora
  • Create and verify a Wallet
  • Copy libra.so to the LIB directory
  • Register database
  • Set new backup configuration
  • Enable Block Change Tracking
  • Run test Backup

Best Practices

addzdlra.sh -d testdb -p gold

slide-10
SLIDE 10

MAX_ RETENTI ON_ W I NDOW

  • Set it, but not too aggressive

Don‘t Subm it m ultiple requests to Delete Databases

  • A delete can take a lot of time
  • If database delete does not progress for

some time, contact Support Don‘t Neglect the RA

  • Monitor and adjust the System
  • System Activity Report
  • Clarify Findings with Support

Best Practices

slide-11
SLIDE 11

11

Target

slide-12
SLIDE 12

Target

  • Use ZDLRA to Backup ~ 9 0 0 databases w ithin the next 1 2 m onths
  • Add m ore storage to ZDLRA for grow th and replication needs
  • I m plem ent Minim al Dow ntim e Maintenance patching solution via new RA High

Availability for Backup & Recovery procedure ( aka Auto-Failover to Replica RA)

  • Outsource Backups to Oracle Cloud
slide-13
SLIDE 13

RA-based Migration of I BM AI X to ExaCC/ OCC

ATTEND OUR MI GRATI ON SESSI ON [ TRN4 0 3 3 ] TOMORROW , 9 AM, MOSCONE W EST 3 0 0 4

slide-14
SLIDE 14

14

Sum m ary

slide-15
SLIDE 15
  • Less tim e for Backups
  • Fast restore and recovery
  • Easy Migration due to autom ated

processes

  • Scalable for data grow th

Summary

slide-16
SLIDE 16

Thank you for your attention!

Stefan Reiners