general ideas about recovery

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