Online Backup Files Not Backup?

[ConvertFromOldNGs]

by tyc >> Fri, 8 Mar 2002 9:43:48 GMT

Hi Jade Developers,

I'm trying to do a online backup using the Administration tool.. I was using the one that allows updating while backup, without any of the
check boxes checked.

It ended up saying some files are not backup : eg : K_Joss.dat, K_SMTP.dat, ominous.dat, and some user defined .dat files.

Does that mean the update is done without the need fo these .dat,
since I read that if updating was allow, the transaction logs is saved along?

Did I get it correct?
Please advise..
L.C. Lim
Bizpoint System Pte Ltd

[ConvertFromOldNGs]

by jadesupport >> Thu, 14 Mar 2002 19:46:40 GMT

This indicates that the files in question are defined in the control file and therefore expected to exist but do not currently exist on disk. In the case of the 3 listed CardSchema files, only transient classes are defined for these mapfiles and you may want to consider using jdbutil.exe to "delete" these files to remove the warnings from occurring during future backups. For your own user mapfiles, you will need to investigate why these are expected in the control file but do not exist on disk and take appropriate steps to remove the warnings for future backups.

<< Automatic Transaction log saving >>
The online backup only copies the recovery log to the backup directory for non-quiesced online backups for systems that do not have archival recovery enabled. ie: Only if EnableArchivalRecovery=false in the [PersistentDb] section of the ini file. This is done in order to help prevent potential recovery problems due to not having the db log file for the time of the backup if the system has since swapped recovery logfiles and removed the logfile that was active at the time of the online backup.


<< Further information that may be useful >>
There are two facilities provided by the JadeDatabaseAdmin class that can be utilised to help with the automated copying of recovery logfiles:

JadeDatabaseAdmin LogTransferEvent
The LogTransferEvent occurs each time a recovery logfile swap occurs. You can register for this event in an "Admin" application that could then perform the necessary operations to copy or FTP this file to another location.

JadeDatabaseAdmin::closeCurrentLog method
The closeCurrentLog method can be used to force the current logfile to swap. This can be utilised by an "Admin" application to force logfile swaps to occur at given times. For example, some companies such as financial institutions use this technique to force a logfile swap to occur at a predetermined time such as 12:30 so that they know they can use their DR procedures to restore to a given point in time during the day.

The JadeDatabaseAdmin class also provides methods to allow full online (updating allowed) or quiesced (no updates allowed) backups to disk. Both of these backups do not require any users to logoff the system, although the quiesced option also has the advantage of being able to perform the same verification of the integrity of the source database files as an offline backup.

Thanks,
Brian Johnstone,
JADE Support.

[ConvertFromOldNGs]

by jadesupport >> Fri, 15 Mar 2002 0:21:38 GMT

I should clarify that you will also have files listed in the "droppedFiles" array if the mapfiles are defined but have never been created on disk. In the previous posting, the situation I was describing would also have resulted in an error when it attempted to backup the missing files.

If you have any mapfiles defined for which there are only transient classes mapped and the files will therefore never be physically created in the /system directory, your backup process will need to expect these files to be in the droppedFiles array and handle this as appropriate.

Thanks,
Brian Johnstone,
JADE Support.