X hits on this document

PDF document

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

33 views

0 shares

0 downloads

0 comments

13 / 17

Data Inventory

  • Extend Data inventory to describe impact of backup frequencies/types etc on recovery.

    • More frequent may reduce recovery time and data loss.

  • Testing required to ascertain recovery times

  • Iterate until required levels of backup are obtained

    • Typically 2 layers for everything (redundancy is important)

    • Example in the white paper (www.comp-soln.co.uk/whitepapers)

www.Comp-Soln.co.uk

Data Item

RecoveryDependency

BU

RPO

RTO

RPO Backup Frequency

RPO Notes

mydatabase

Data Locations Checkpoint iles Dump iles Journal iles Database CNF Customized cktmpl.def

Y Y Y Y Y Y Y

10

30

N/A

Anyvalid ckpt can be used if all journals are available

Data Location

Y

0

1

RT

Copyright ©2005 Comprehensive Solutions International Ltd.

Data Inventory

All Rights Reserved

Y Y

N/A

15

N/A

Y Y

N/A

15

N/A

Y

10

15

9

O

Y

10

1

9

Y

10

1

9

Copyright ©2005 Comprehensive Solutions International Ltd.

All Rights Reserved

Checkpoint Files

None

Dump Files

Checkpoint locations Checkpoint backup

Journal Files

Dump Location Dump ile backup

Journal Location Journal ile backup

Static Files

Static Files

Backup when changed

Database CNF

Root Data Location CNF Backup (DMP Location)

CNF Backup (DMP Location)

CNF Backup 2

RTO Backup Frequency

RTO Notes

Backup Method

Daily

15 mins to recover as of 27/07/05

Ckpt.ksh

Notes

Immediatelyafter

SysBackup.ksh or

Daily

Checkpoint

Ckpt.ksh

Immediatelyafter

Checkpoint or

SysBackup.ksh or

Dual Checkpoint

Ckpt.ksh

As per RPO

JournalArchive.ksh

As per RPO

Automatic

RT

Daily

Documentation

TBA

www.Comp-Soln.co.uk

25

26

13

Document info
Document views33
Page views33
Page last viewedSat Oct 29 00:18:39 UTC 2016
Pages17
Paragraphs1026
Words3214

Comments