J
James Palmer
Guest
I've found what I think is quite a serious issue. I've reproduced in 11.6 and 11.7.4. A prostrct repair on a database with an st file with fully qualified storage area locations which are wrong can lead to the BI getting out of date. Steps to reproduce: Create a sports2000 database in directory 1 Update the st file to have fully qualified paths Copy the folder and contents to directory 2 proserve the database in directory 1 prostrct repair the database in directory 2 without fixing the paths Access the db in directory 2 in single user mode Try stopping and starting the database in directory 1 You get errors 886-888 ** The database was last used . (886) ** The before-image file expected . (887) ** Those dates don't match, so you have the wrong copy of one of them. (888) In my opinion this shouldn't be allowed to happen. There should be some sort of control in place that stops the prostrct repair from happening - particularly against files on a running database.
Continue reading...
Continue reading...