Feasibility Study for Potential fP Software - Part #2
Keith' Weatherhead
keithw at ddltd.com
Sat Sep 16 10:25:04 PDT 2006
Fairlight wrote:
> Hi Everyone,
>
> I'm trying to do some market research for a potential ***filePro-related***
> product. It can't get much more filePro-related, so I'm not considering
> this off-topic. I would appreciate a few moments of anyone's time who's
> willing to participate.
>
[Text deleted]
>
> I appreciate your time, thanks!
>
> Bests,
>
> Mark Luljak
> Fairlight Consulting
> _______________________________________________
A couple of thoughts that came to mind after I hit the send button.
Who ever taught me to spell and type must be turning in their graves
now !! That aside !!
When writing EXTERNAL transactions to the local host. They are
written to the current hosts transaction logs.
When doing a straight recovery, due to a disk problem or the likes,
the recovery log is processed, once completed a checkpoint
transaction is added to indicate that a recovery had been done and
then it continues getting tacked onto.
When doing a recovery and modifying the transactions being applied
by removing stuff from a certain user, stationID, time range, etc. a
new transaction log is made and checkpointed upon completion of the
recovery and appended too going forward, the original transaction
log is then archived.
Transaction logs should be cycled, probably with something like a
filename of: TlogYYYYMMDDHHMMSS.001 and limited too a reasonable
amount of space. The system should then create a new log file and
increment the extension if it is on the same date as the previous
log file.
You might even add a backup set code in the filename, say after the
"Tlog?" where that character changes on the same date if a backup is
done, say mid-day.
Also, a new log file should be created at midnight, to start the
next day.
There should be a file that tracks the start/stop of log files and
the backup set-id for each host system. The system should know,
based on the backup set restored, what log files need to be
processed and the only other thing is whether it is a standard
recovery and a new log file is desired (normally not) or whether it
is a modified recovery, and if so, what is being deleted from
reapplication to the database, which is why a new log file MUST be
generated.
Regards,
Keith
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Keith F. Weatherhead keithw at ddltd.com
Discus Data, LTD Voice: (815) 237-8467
3465 S Carbon Hill Rd Fax: (815) 237-8641
Braceville, IL 60407 Nat'l_Pager: (815) 768-8098
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
More information about the Filepro-list
mailing list