X hits on this document

PDF document

Can you really recover your data? - page 16 / 17

47 views

0 shares

0 downloads

0 comments

16 / 17

Ingres specifics

  • RTO Factors

    • Reduce recovery time using hardware.

    • Increase the number of locations.

  • Disc bandwidth may allow multiple locations on the same logical file

system. (Use different Paths for each location)

  • /ingdata1

  • -

    > ingdata1

  • /ingdata1/loc2 -> ingdata1_2

  • Unlikely to affect day-to-day performance.

  • Daytime Checkpoints

  • Ensure application is not doing any DDL (Create, modify etc.)

www.Comp-Soln.co.uk

Copyright ©2005 Comprehensive Solutions International Ltd.

All Rights Reserved

Backup Validation

  • All of the above is useless if you don’t regularly prove you can recover as required

  • Avoid the ‘False Sense of Security Syndrome’

    • We have all the necessary backups in place, we use trusted and reliable

software, so we are OK’.

  • Schedule regular recovery tests

    • Changes in size, transaction volume, many factors might affect recovery.

    • Gather timing metrics and track, looking for trends.

  • Test recovery after any changes

    • Configuration.

    • New application release.

  • Validate the recovery

    • Integrity checks.

    • Completeness.

  • Look for differences and/or anything unusual - that is generally bad.

www.Comp-Soln.co.uk

Copyright ©2005 Comprehensive Solutions International Ltd.

All Rights Reserved

31

32

16

Document info
Document views47
Page views47
Page last viewedSun Dec 11 12:13:50 UTC 2016
Pages17
Paragraphs1026
Words3214

Comments