> -----Urspr�ngliche Nachricht-----
> Von: Filip Sergeys [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 11. August 2004 12:06
> An: [EMAIL PROTECTED]
> Betreff: autolog_on -> databackup missing
>
>
> Hi,
>
> I just recovered a database with:
> db_activate RECOVER FULLBAKCUP
> recover_start ARCH LOG 740
> recover_replace ...
> ....
> recover_ignore
> util_release
> db_online
>
> I now want to switch on autologging
> autlog_on ARCH
>
> but I get an error message:
> ERR
> -24988,ERR_SQL: sql error
> -126,Databackup missing (Backuphistory lost)
>
> It only seems to work if I make a complete backup first. This is
> somewhat annoying to do because:
> a) the backup is big.
> b) This system is a copy of production system that get synchronised
> every night with the added complexity that during the day changes are
> made to that copy database
> So every night I reintialize the database, import the fullbackup plus
> all additional archived logs created on production ever since.
>
> If, additionally, I need to create a complete backup of that freshly
> installed copy, before I'm able to switch on autologging, it will take
> very long to run the entire process.
>
> In the documentation I could not exactly find that a fullbackup is
> needed before you can switch on autologging. This leads me to
> suggest I
> am missing something, but I don't know what. Who does or who can point
> me to the relevant information?
>
Hi,
after the command db_activate the backup-history is interrupted,
because the logvolume is implicitely cleared. If a logbackup would
be allowed in this state, than it would be impossible to decide
whether a newly created backup belongs to your production system
or to your backup-system.
The easiest solution to your problem would be not to recreate
the database each night, but only to recover the new logbackups:
Once:
create initial database (db_activate recover...)
each night:
recover_start logsave
recover_replace
recover_replace
...
recover_cancel
You have to start the recovery with the logbackup which had been
the last one in the previous night.
But NEVER bring the shadow database into online-mode. Otherwise
you cannot continue the logrecovery next night.
regards, martin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
