Suppose that you need to examine the archived database as of time
t0.
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 invRESOURCE permission
to create views, stored procedures, global or local temporary tables
or any other structures necessary for the investigation.