Saturday, May 3, 2008

15-7. Backup sets vs. image copies

Data blocks
Image copies: all data blocks
Backup sets: no empty data blocks are copied (saves space). Typically 20% of database space is empty data block.

Granularity
Image copies: only the file we need has to be copied
Backup sets: all backup set must be retrieved even though only one of them is needed

A backup of a database running in NOARCHIVELOG mode must have all three attributes:
  • offline
  • full backup (level 0)
  • whole database

0 comments: