Follow these steps to examine archived data.
Prerequisites
Suppose that you need to examine the archived database
as of time t0.
Task- Copy the archived read-only db.db0 to
a read-write file db.db0.working.
- Start db.db0.working. Note that
as long as the server name db.db0.working does
not conflict with the production system db.db,
there is no need to stop the production system. db.db0.working will
open A, B, C,
and D in read-only mode. This will not interfere
with db.db's use of these files on UNIX, although
Windows returns a sharing violation.
Note that the catalog file db.db0.working is
open in read-write mode.
- Create a user inv for an investigator
who wishes to examine the archived database.
- Grant inv RESOURCE permission
to create views, stored procedures, global or local temporary tables
or any other structures necessary for the investigation.
db.db0 as well as A,B and C remain
unchanged.