online 7.22 onarchive questions

I have read TFM, but can someone give me a few simple answers. The database is continuously updated (16MB logical log data per hour). Need the ability to revert the database to a previous state, and the ability to restore the database up to last valid transaction. The database gets archived (to tape) in the following manner: day 1 - level 0 day 2 - level 1 day 3 - level 1 day 4 - level 1 day 5 - level 0 ... continuous logical log backups to disk (16MB per hour). When restore is required - always do full (all dbspaces) restores. 1. How do you restore (revert) a database to the state at a given level 1 backup (say day 3) ? 2. What logical logs do you need in order to do a full restore after a crash on day 4, 2 hours after level 1 archive? Do you need all logical logs since last archive level 0, or are the logical logs since the last level 1 archive enough. 3. Do you need all level 1 archives to restore to the day 4 level or does the day 4 archive include all the info in the previous level 1 archives? Thanks. -- Shimon Gonen Phone: (619) 552-9672 Fax: (619) 552-9854 Titan Information Systems http://www.titan.com/ 3033 Science Park Road San Diego, Ca 92121