If you're using the mirror database (stop-restart) method of roll-forward
recovery, you probably need to purge the restart file created by a prior attempt
at recovery.  RUN DBRECOV.PUB.SYS,PURGE will accomplish this.  The "TurboImage
DBMS Reference Manual" should be able to provide more information -- probably in
the Logging and Recovery chapter (don't know the chapter number, offhand).
----
Lee Gunter                    The Regence Group
Supervisor, TRG HP/MPE Systems     503.375.4498
----
Opinions expressed are solely mine.





From: Scott Lindholm <[log in to unmask]> on 11/11/99 03:16 PM

Please respond to [log in to unmask]


To:   [log in to unmask]
cc:    (bcc: Lee Gunter/BCBSO/TBG)
Subject:  [HP3000-L] log file recovery problems




I am setting up a "poor man's" reporting box.  The method that I am trying
to utilize is FTPing log files to the report box and roll the data base
forward.  The recovery errors out as shown below:

>recover dms.data.azce
 DATABASE DMS LAST DBSTORED THU, NOV 11, 1999, 12:05 PM
>run
**** ERROR #1 **** Can't save restart file:  DUPLICATE PERMANENT FILE NAME
(FSE
RR 100)

DBRECOV ABORTS ON THU, NOV 11, 1999,  4:08 PM


DBRECOV STACKDUMP FOLLOWS:
       PC=a.00a44bb0 NL.PUB.SYS/stackdump_prime+$264
NM* 0) SP=418468d8 RP=a.00e56f70 stackdump2+$80c
       DP=c0202008 PSP=41846798 PCPRIV=2
NM  1) SP=41846798 RP=a.00e576b4 STACKDUMP+$208
       DP=c0202008 PSP=418465d8 PCPRIV=2
NM  2) SP=418465d8 RP=a.00e57498 ?STACKDUMP+$8
       DP=c0202008 PSP=41846518 PCPRIV=2
         export stub: 1450.00024b5c DBRECOV.PUB.SYS/abend+$3b0
NM  3) SP=41846518 RP=1450.0001dbe8 runcmnd+$978
       DP=41638000 PSP=418463d0 PCPRIV=3
NM  4) SP=418463d0 RP=1450.00017bd0 readcommands+$664
       DP=41638000 PSP=418462c8 PCPRIV=3
NM  5) SP=418462c8 RP=1450.0003d254 splob'+$11c
       DP=41638000 PSP=41846288 PCPRIV=3
NM  6) SP=41846288 RP=1450.00000000
       DP=41638000 PSP=41846130 PCPRIV=2
     (end of NM stack)
 Abort occured outside analysis and recovery time.
 Cause of abort is:
 Restart file open failed

I cannot find the file which is apparently causing the problem.  Does
anybody have any suggestions?

Thanks,
Scott Lindholm
Sr Systems Administrator
Corporate Express
303-664-3264
[log in to unmask]