Kbase P13588: What to do on UNIX if a database file is deleted while the database is in use?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/04/2009 |
|
Status: Verified
GOAL:
What to do on UNIX if a database file is deleted while the database is in use?
GOAL:
What to do on UNIX if a database extent is deleted while the database is in use?
FACT(s) (Environment):
UNIX
FIX:
If a database extent/file is deleted while the database is running, it may be possible to extract the physically missing data. The process requires that one of the users who was connected to the database before the file(s) was removed have either a 4GL license or the capability to run precompiled dump routines. However, if the lock file (dbname.lk) has been removed this recovery may not be possible.
If the user can get to the procedure editor, write procedural code to dump all tables of the database to disk. If the user can get to the Data Dictionary then have them dump the data definitions and table contents via the Admin menu.
Do not forget to dump the _seqvals table for the sequence values of the database.