> -----Original Message-----
> From: Daniel Bl�zquez [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 28, 2003 7:48 PM
> To: [EMAIL PROTECTED]
> Subject: general ideas about recovery
[snip]
> Now i'm gonna introduce several scenarios of recovery playing with
> the backups i have done:
>
> #scenario 2) need to recover the status of DB at 9:30
>
> steps:
> util_execute init config (reset the logs)
> util_connect dbm,dbm
> recover_start complete_1 DATA (recover full data backup
> complete_1)
> recover_start log_backup_1 LOG UNTIL 20030828 093000 (recover
> log until specific time)
> util_release
>
> result:
> WHEN I PERFORM THE LOG RECOVERY, I OBTAIN
> -24988,ERR_SQL: sql error
> -71,connection broken
> DO I NEED TO RECOVER THE FULL DATA BACKUP OR IS SUFFICIENT
> WITH RECOVERING THE LOG WITH SPECIFIC TIME?
please have a look into the file knldiag whether there is a more
detailed error message.
>
>
> #scenario 3) need to recover the status of DB at 10:15
>
> I DONT KNOW HOW TO RECOVER AN SPECIFIC TIME WITHOUT HAVING
> LOG BACKUPS
after recovering your data, check if the LogPages which are still
on the LogVolume are sufficient for a restart. You can do this with
the dbmcli-command db_restartinfo. If the database is restartable,
the you do not need any log-backup. Rather you should execute a restart
until by using the command
db_online -u yyyymmdd hhmmss
regards, Martin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
