We accidentally
deleted a snapshot file, making the database inaccessible. Can we
recover from this without restoring the database from the previous
backup and applying all of the AIJ transactions?
A:
Fortunately,
snapshot files (.SNP) do not contain live data; therefore, you
don’t need to be concerned with the contents of the file you
deleted. In fact, snapshot files are not even backed up when you
perform a database backup; they are simply created and initialized
when the database is restored. You can use RMU/MOVE_AREA (for Rdb)
or DBO/MOVE_AREA (for DBMS).
First, create a dummy snapshot file so that Rdb or
DBMS can find this file to delete after the move. Use RMU/MOVE_AREA
or DBO/MOVE_AREA to "move" the storage area that corresponds
with the deleted snapshot file. The MOVE command rebuilds an empty
snapshot file.
