Hi everybody,
after a few days dealing with backups and recovery, i'd like to
synthetize mi ideas, (and fix the wrong ones!)
I will draw a vertical time line to illustrate a proccess:
[...]
- sql opertations
- sql operations
[...]
--- 9:00 i perform a complete data backup:
backup_start complete_1
- sql operations
- sql operations
- sql operations
[....]
--- 10:00 perform an interactive log backup (supposed i have filled
24kbs of log data)
backup_start log_backup_1
- sql operations
- sql operations
- sql operations
Now i'm gonna introduce several scenarios of recovery playing with
the backups i have done:
#scenario 1) need to recover the status of DB at 9:00
steps:
util_execute init config (reset the logs)
util_connect dbm,dbm
recover_start complete_1 DATA (recover full data backup
complete_1)
util_release
#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?
#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
Are those sequences of steps and commands OK? may somebody
correct me if they are wrong?
Which are the steps to be done in order to accomplish scenario3??
any help will be very appreciated. I realize that are two many
questions, but i think that this thread can be very very helpful to a
lot of people!!
daniel, spain
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
