1 / 4

Resync of Tier1s for disaster recovery experience and feedback

Distribute database Operation Workshop, Geneva, 15-16 November 2010. Resync of Tier1s for disaster recovery experience and feedback. Carmine Cioffi Database Administrator and Developer. Experience. Second time I collaborate in synchronizing a Tier1 database ASGC SARA

dirk
Download Presentation

Resync of Tier1s for disaster recovery experience and feedback

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. Distribute database Operation Workshop, Geneva, 15-16 November 2010 Resync of Tier1s for disaster recoveryexperience and feedback Carmine Cioffi Database Administrator and Developer

  2. Experience Second time I collaborate in synchronizing a Tier1 database ASGC SARA It is a tested and working procedure Compare db parameters between the two sites Identify the list of tablespaces to copy over Stop apply processes Make the selected tablespaces read only Copy data files over Make tablespaces read write Hand over the start up of the streaming to CERN The interesting part is done by CERN

  3. Experience The time to copy the files over is unpredictable. It took ~18hours The experiments involved need to be notified and we have to wait to get the go ahead . This is the most difficult part of all the procedure !

  4. Feedback • The experiments are not very happy to know that the streaming is down especially during the non LHC technical stops: • We should look into a possible alternative synchronization method were we do not need to stop the streaming or reduce at minimum the downtime. • Possible solution to reduce the streaming downtime….. • Use RMAN backup • Copy tablespaces on a local disk • Stop streaming. • Copy tablespaces and metadata on a local storage. • Start streaming. • Copy over the tablespaces with related metadata from the local storage. • Data Guard • RAL is always pleased to help other Tier 1 in the synchronization process.

More Related