|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: can't read auto-log file 002 after 001 was read successfully
From: Döhr, Markus ICC-H (Markus.Doehr
siegenia-aubi.com)
Date: Wed Jan 05 2005 - 10:08:19 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> > tries to tell, that your recover_start was successful, that
> all needed
> > log information was read from the log backup and the log volume and
>
> In this case it's strange that I have two auto-log files, but
> need only to restore one of them. Why do I have two auto-log
> files than? Does the second one contain rollback information,
> which I won't need because I want to go forward as much as
> possible? Or does the second one contain one large, but
> not-yet-committed transaction ? That's possible, because I
> just imported some database files, some with around 12000 rows.
The LOG gets cyclically overwritten so the part, that was necessary to get
the DB up was not yet overwritten and it could be taken to redo the last
transactions.
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.: +49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: markus.doehrsiegenia-aubi.com
Internet: http://www.siegenia-aubi.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]