LCG 3D - Database Administrator Meeting @ CNAF

12 Jun 2007, 09:30 → 13 Jun 2007, 16:30 Europe/Zurich

C052 - Meeting Room, first floor. (INFN - CNAF)

The focus of this meeting will be to do a coordinated database recovery of the replicated setup with all Tier 1 sites and Tier 0. It would be good if as many sites as possible could attend in person, so that people can profit from each others experience with RMAN in this hands-on activity. In addition we will review the progress of the experiment scalability tests with the tier 1 database setups and discuss the status of the upcoming milestones in this area. For details about registration and accommodation please see Barbara's email A VRVS conference will be available in the room Ocean. A Phone conference will be available: - to join the phone conference, dial +39 051 4209801, - to let the system call you, please send an email to alessandro.italiano(at)cnaf.infn.it

Tuesday 12 June

09:40 → 13:40 Database Backup and Recovery - RMAN setup, Tier 1 recovery operations, Tier 0 streams operations

09:40 Coffee

10:00 Workshop Goals

Speaker: Dirk Duellmann

Slides dirkd-CNAF-ws-goals.pdf

10:10 VOMS replication test plans and required resources

Speaker: Valerio Venturi

Slides DB3Meeting.pdf

VOMS Working Group Wiki https://twiki.cern.ch/twiki/bin/view/LCG/VomsWG#VOMS_Replication

10:40 Backup and Recovery with RMAN

Speaker: Jacek Wojcieszuk

Slides Backup&Recovery_with_RMAN.pdf Backup&Recovery_with_RMAN.ppt

11:20 RMAN Setup @ CNAF

Speaker: Federico Bonifazi

Slides RMAN_Setup_@_CNAF.pdf RMAN_Setup_@_CNAF.ppt

11:40 Tier 1 experience with RMAN and RMAN setup questions

Speakers: Carlos Gamboa (BNL), Gordon Brown (RAL)

document RMAN_Questions_and_Answers.doc RMAN_Questions_and_Answers.pdf

Slides

• 3d_Bologna_RAL_Backup.pdf
• 3d_Bologna_RAL_Backup.ppt
• cnaf_presentation_dba_recovery_workshop.pdf
• cnaf_presentation_dba_recovery_workshop.ppt

12:10 Streams failover and resynchronisation

Speaker: Eva Dafonte Perez

Slides Streams_Resynchronization_-_DBA_meeting_CNAF.pdf Streams_Resynchronization_-_DBA_meeting_CNAF.ppt

12:40 Lunch

14:00 → 17:30 Experiment Scalability Tests and Deployment Schedule

14:00 Summary of Experiment Tests and Deployment Schedule

Speaker: Gancho Dimitrov (ATLAS)

Slides

• Atlas_LHCb_plans_CNAF.pdf
• Atlas_LHCb_plans_CNAF.ppt
• bologna_stonjek.pdf
• bologna_stonjek.ppt
• Frontier-3D-INFN-20070612.pdf
• stefan_plot.pdf

15:30 LFC r/o replicas for LHCb - setup schedule

Speaker: Dirk Duellmann

16:00 Coffee

16:15 Visit at CNAF Computing Room

20:30 → 22:00 Social Dinner

Wednesday 13 June

09:00 → 14:00 Hands-on sessions performing a complete RMAN Recovery and Streams Resynchronisation

09:00 Hands-on session part 1

11:00 Coffee

11:15 Hands-on session part 2

13:00 Lunch

14:00 → 16:30 Database Setup Consolidation and new Replication Requests

• VOMS, SAM, Gridview, GOC DB, CIC Portal

14:00 Tier 0 database extensions and multi-core / 64-bit studies

Speaker: Maria Girone

Slides cnaf.pdf cnaf.ppt

14:40 Summary of Tier 1 consolidation plans for LFC, FTS and other Oracle based services

Speakers: Doris Wochele (GridKA), Luis Diaz (PIC)

Slides 20070611lfcftsGM.doc 20070611lfcftsGM.pdf

15:30 Wrap up session

Speaker: Dirk Duellmann