Kbase 17416: AI-file, BI-file deleted, Proshut fails. On Unix & NT
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/12/1999 |
|
AI-file, BI-file deleted, Proshut fails. What next?
BI-file or AI-file deleted, PROSHUT fails: What to do next?
Sometimes a "small" accident happens and 1 or more of the database-
files are deleted while the Database was in use in Multi-User mode.
When the BI-file is deleted a proshut cannot take place.
The returned errors are:
Cannot find or open file /73e/dbname.bi, errno = 2. (43)
Cannot find or open file /73e/dbname.bi, errno = 0. (43)
Even when the -F option is given the proshut command will fail with
these errors.
--------------------------------------------------------------------
On UNIX the workaround is to use the touch command to recreate the
missing file. (This will be an empty file!!)
SYNTAX: touch dbname.bi
Run the proshut after the touch command and the DB will shutdown.
!! REALIZE THAT NO TRANSACTION BACKOUT WILL TAKE PLACE !!
!! RESTART OF THE DATABASE WILL HAVE TO BE DONE IN SINGLE-USER MODE
WITH THE -F OPTION TO FORCE ACCESS INTO THE DATABASE.
DATABASE INTEGRITY WILL BE LOST!!
(Use standard procedure to get integity back to normal)
----------------------------------------------------------
If the bi file is deleted on Windows NT and Progress version 8 the way to recreate the bi file is to use the following command:
Proutil [dbname] -C truncate bi -F
when asked if you want crash recovery choose no.
-------------------------------------------------------
When the After-Image file has been deleted
==========================================
The procedure for a deleted AI-file is the same as described for
the deleted BI-file.
Since the AI-file is a seperate file from the DB-files, there is no
need to restart the db with the -F option, however it must be noted
that all transactions that were written into the AI-file are gone.
The db should be backed-up or if a NON-progress backup is used then
at least be marked as backed-up, before new After-Image is started.
Cannot find or open file /73e/dbname.ai, errno = 2. (43)
Cannot find or open file /73e/dbname.ai, errno = 0. (43)
Hilleke Oskamp (hos)
19 november 1997
Progress Software Technical Support Note # 17416