RE: general ideas about recovery

> -----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