> -----Urspr�ngliche Nachricht----- > Von: Martin Cordova S. [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 18. Juni 2003 17:41 > An: [EMAIL PROTECTED] > Betreff: Restoring from total crash... > > > Hello: > > 1) I simulated a crash by stopping my db instance and > deleting my log and data volume files. > > 2) Then I restarted my db instance and run this script to > recreate this > files: > > db_admin > util_connect > util_execute INIT CONFIG > util_release > > The log and data volumes where recreated > > 3) Then I run this script to restore the last full data > backup and the last autolog backup: > > db_cold > util_connect dbm,dbm > recover_start data DATA > recover_start auto LOG 002 > util_release > db_warm > > PROBLEM: > > Recover of the full data backup works OK, but the recover of > the autolog backup returns this error: > > >recover_start auto LOG 002 > ERR -24988,ERR_SQL: sql error -71,connection broken
the proper way of restarting a database after recovering the last log-backup is the command recover_ignore. After this the database is online. If this doesn't work, have also a look into the file knldiag, where a more detailed error-message can be found. regards, Martin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
