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

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 - Servers • • Database features including: • RAC • Data Guard • GoldenGate for Minimal Downtime Maintenance (MDM)

Mission 6

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

Best Practices 8

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

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

Target 11

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

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

Sum m ary 14

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

Thank you for Stefan Reiners your attention!