Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

help...database won't open or close



hi,

I have the following setup, and during a (too) massive delete process,
things died and now i can't seem get things going again...

RDB Version: Oracle Rdb V7.0-14
VMS Version:  VMS Version V7.1

 
An update process died, with a bugcheck dump, as follows:

%RDMS-I-BUGCHKDMP, generating bugcheck dump file
PATH$DB_JNL_DEV:[DB.BOB]RDSBUGCHK.DMP;

The .DMP file had the following error msgs:

***** Exception at 00642E87 : PIOABW$SYNCH_PAGE + 00000298
%RDMS-F-CANTWRITEDBS, error writing pages 198:8587-8587
-SYSTEM-F-EXQUOTA, process quota exceeded

and..

***** Exception at 00642AD9 : PIOABW$WRITE_PAGES + 00000182
%RDMS-F-CANTWRITEDBS, error writing pages 198:8587-8587
-SYSTEM-F-EXQUOTA, process quota exceeded

 
now when I try to access the database, I get:

$ sql
SQL> set verify;
SQL> declare transaction read only;
%SQL-F-ERRATTDEF, Could not use database file specified by SQL$DATABASE
-RDB-F-SYS_REQUEST, error from system services request
-RDMS-F-DBNOTOPEN, database is not open for access

 so I try to open it:

$ rmu/open sql$database /access=restricted
%RDMS-F-TERMINATE, database recovery failed -- access to database denied by
monitor

 so I try to close it:

$ rmu/close/abort=delprc/wait sql$database
%RDMS-F-TERMINATE, database recovery failed -- access to database denied by
monitor

 check users:
$ rmu/dump/users sql$database
Active user with process ID 0000105A (recovery in progress) 
    Stream ID is 2
    Monitor ID is 1
    Transaction ID is 582
    Recovery journal filename is
"PATH$DB_JNL_DEV:[DB.BOB]MS$00014C47455C.RUJ;1"
    Read/write transaction in progress
    Last Process quiet-point was AIJ sequence 4628
    Transaction sequence number is 0:4585043

 Does the process exist?:
$ show process/id=105a
%SYSTEM-W-NONEXPR, nonexistent process

 
Does the journal file exist?
$ dir PATH$DB_JNL_DEV:[DB.BOB]MS$00014C47455C.RUJ
Directory PATH$DB_JNL_DEV:[DB.BOB]

 MS$00014C47455C.RUJ;1                   

 Total of 1 file.

 
I've tried stopping/restarting the rdb monitor process, and rebooting the
machine, and still the problem persists.  Any help would be greatly
appreciated.

 
thanks,

John



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.