zdlra metronom
play

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

Feb 04, 2024 •355 likes •522 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 -

  1. ZDLRA @ METRONOM 1 0 .2 4 .2 0 1 8

  2. 1 I ntroduction Agenda 2 Mission 3 Best Practices 4 Target 5 Sum m ary

  3. I ntroduction 3

  4. I ntroduction

  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)

  6. Mission 6

  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

  8. Best Practices 8

  9. Best Practices 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 addzdlra.sh -d testdb -p gold • Copy libra.so to the LIB directory • Register database • Set new backup configuration • Enable Block Change Tracking • Run test Backup

  10. Best Practices 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

  11. Target 11

  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

  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

  14. Sum m ary 14

  15. Summary • Less tim e for Backups • Fast restore and recovery Easy Migration due to autom ated • processes • Scalable for data grow th

  16. Thank you for Stefan Reiners your attention!

Recommend

More recommend