Data Consistency, Recovery, and Migration 4-47
Gather All Tapes Needed for Restore
Gather All Tapes Needed for Restore
To restore OnLine, you need all archive tapes (level-0, and possibly level-1
and level-2) and the tapes containing the logical log backups since the last
archive. The tapes you need are listed for you when you select the
DB-Monitor Status menu, Archive option. Refer to Figure 4-8 if you are
uncertain about how to determine which archive tapes are needed for a data
restore.
Figure 4-8
How to determine
which archive tapes
are needed for a
data restore
Archive Day
Level-2 2 3 5 6 8 9 11
Level-1 4 7
Level-0 1 10
Incremental Archive Schedule
Day Tapes Needed
1 Tape 1
2 Tapes 1 and 2
3 Tapes 1 and 3
4 Tapes 1 and 4
5 Tapes 1, 4, and 5
6 Tapes 1, 4, and 6
7 Tapes 1 and 7
8 Tapes 1, 7, and 8
9 Tapes 1, 7, and 9
10 Tape 10
11 Tapes 10 and 11
Restore Requirements