 |
|
Q: |
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. |
|
Copyright © 2011 Software Concepts International |