1 / 10

Recovery Exercise Wrap-up

Recovery Exercise Wrap-up. Jacek Wojcieszuk , CERN IT-DM Distributed Database Operations Workshop November 2 6 th , 200 9. Teams. Team 1: Carmine & Elena (a CASTOR DB) Team 2: Jason, Luca, Doris, Kamil (D3R DB) Team 3: Carlos & Przemek & ... (D3R DB)

claudia-fitzpatrick
Download Presentation

Recovery Exercise Wrap-up

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. Recovery Exercise Wrap-up Jacek Wojcieszuk, CERN IT-DM Distributed Database Operations Workshop November26th, 2009

  2. Teams • Team 1: Carmine & Elena (a CASTOR DB) • Team 2: Jason, Luca, Doris, Kamil (D3R DB) • Team 3: Carlos & Przemek & ... (D3R DB) • Team 4: Dawid, Alexander & Gordon & ... (D3R DB)

  3. Status • 3 teams completed point-in-time recovery successfully • 1 team recovered spfile and controlfile • Many scaring/interesting issues encountered • No time to practice block media recovery • We will try to provide more details on Twiki how to intentionally corrupt datafiles and fix corruption with RMAN, so it can try it out on your own

  4. Team 1 • Point-in-time recovery completed • But it had to be repeated due to problems with backup registration • Lessons learned: • If database recovered to a different system, before starting datafile restore and recovery usually it is necessary to crosscheck and delete obsolete backup • If backup location is different than on the source system it is necessary to catalog it before starting datafile restore

  5. Team 2 • Restore of an spfile and a controlfile completed • So the most tricky part done • Everything prepared for datafile restore & recovery (which in this case would be smooth, anyway) • No time to complete other steps

  6. Team 3 • Point-in-time recovery completed after long fight • Many interesting problems. E.g: starting media recovery unable to find archive log archive log thread=1 sequence=26655 Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '+RECOR_DATADG1/d3r/datafile/system.771.703962999' released channel: TAPE_1 released channel: TAPE_2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 11/26/2009 17:22:09 RMAN-06054: media recovery requesting unknown log: thread 1 seq 26655 lowscn 6086420371648

  7. Team 3 – Lessons learned • It is worth to use the freshest available controlfile otherwise RMAN can have problems to find some needed backups • Discrepancy between controlfile contents and the state of the database at the chosen point-in-time can cause some extra troubles that need to be addresses separately

  8. Team 4 • Point-in-time recovery completed successfully • Also few problems. E.g: starting media recovery media recovery failed released channel: t1 released channel: t2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 11/26/2009 17:38:05 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed start until time 'NOV 24 2009 23:00:00' using backup controlfile ORA-00283: recovery session canceled due to errors ORA-01110: data file 1: '+D3R_DATADG1/d3r/datafile/system.259.657910831' ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '+D3R_DATADG1/d3r/datafile/system.259.657910831'

  9. Team 4 – lessons learned • If datafile location on the recovery system is different from the one on the original system or when OMF used, recovery will fail if it is not preceded with switch database to copy

  10. Thank you for participation

More Related