1 / 9

STREAMS Resynchronization Scenarios and Tests

This workshop covers various scenarios and tests for resynchronizing streams, including point-in-time recovery and recovery on source/destination databases. The session involves practical examples and discussions on recovery strategies in a streaming environment.

jkilroy
Download Presentation

STREAMS Resynchronization Scenarios and Tests

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. STREAMS Resynchronization Scenarios and Tests LCG 3D workshop @ CERN September 2006 Eva Dafonte Perez (CERN) Gordon Brown (RAL)

  2. CERN CNAF RAL B&R Streams Test • Streams environment preparation: • Script written in python • Based on condition data • Insert only workload Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 2

  3. B&R Streams Test Recovery on destination (I) • Scenarios: • Point-in-time recovery on the destination database • Tier1 database crashes and all data are lost # Dropped the table and recorded the time SQL> SET TIME ON 09:40:12 SQL> DROP TABLE streams_throughput.apl10; # Stopped the database 09:40:18 SQL> shutdown immediate; # Connected to RMAN, recovery catalogue and target database RMAN> RESTORE DATABASE UNTIL TIME "TO_DATE('30-AUG-2006 09:30','DD-MON-YYYY HH24:MI')"; RMAN> RECOVER DATABASE UNTIL TIME "TO_DATE('30-AUG-2006 09:30','DD-MON-YYYY HH24:MI')"; # Restart database to make sure OK Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 3

  4. oldest SCN >> captured SCN CERN CNAF RAL propagation jobs propagation jobs point-in-time recovery RAL RAL RAL propagation jobs LCR LCR CNAF CNAF RAL RAL CNAF start SCN = oldest SCN new capture process x x propagation job propagation job oldest SCN RAL B&R Streams Test Recovery on destination (II) ## select oldest_message_number from dba_apply_progress: 5985270908207 capture process x Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 4

  5. SCN recovery B&R Streams Test Recovery on source (I) • Scenario: • Point-in-time recovery on the source database # Dropped the table and recorded the time SQL> SET TIME ON; 10:38:02 SQL> drop table STREAMS_THROUGHPUT.test; # New transactions # Stopped the database # Connected to RMAN, recovery catalogue and target database RMAN> RESTORE DATABASE UNTIL TIME "TO_DATE('06-SEP-2006 10:37:55','DD-MON-YYYY HH24:MI:SS')"; RMAN> RECOVER DATABASE UNTIL TIME "TO_DATE('06-SEP-2006 10:37:55','DD-MON-YYYYHH24:MI:SS')"; ## Incomplete Recovery applied until change 5985369467709 # Restart database to make sure OK – restricted mode Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 5

  6. CERN CERN propagation jobs re-build data dictionary ## SCN value: 5985369471608 determine highest SCN applied ## SCN value: 5985369468070 CNAF RAL RAL CNAF SCN recovery 5985369467709 << SCN applied 5985369468070 capture process capture process SCN applied First SCN Start SCN = First SCN B&R Streams Test Recovery on source (II) x • set a Streams tag: transactions are not re-captured • manually execute transactions Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 6

  7. CERN propagation jobs propagation jobs captured SCN >= maximum SCN CNAF CNAF RAL RAL determine highest SCN applied SCN applied re-build data dictionary First SCN capture process capture process CNAF RAL capture process apply process CERN RAL Start SCN = First SCN B&R Streams Test Recovery on source (III) - proposal • Simulate SCN recovery >> SCN applied # Stopped the database # Connected to RMAN, recovery catalogue and target database ## Incomplete Recovery applied until change SCN recovery # Restart database to make sure OK – restricted mode x x apply process Maximum SCN = SCN recovery Start SCN = SCN applied Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 7

  8. CERN propagation jobs CNAF RAL CNAF RAL capture process Start SCN = First SCN capture process apply process apply process B&R Streams Test Recovery on source and destinations • Scenario: • Point-in-time recovery on the source and on the destination databases # Stopped the database # Connected to RMAN, recovery catalogue and target database ## Incomplete Recovery applied until Point-in-Time # Restart database to make sure OK x x x apply process reset SCN re-build data dictionary First SCN apply process Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 8

  9. Questions & Answers https://uimon.cern.ch/twiki/bin/view/PSSGroup/3DStreamsRecovery Streams Resynchronization Scenarios and Tests – LCG 3D workshop - 9

More Related