Log Retain and Restore

[kozlow]

I was trying to restore a production database with log retain = to Recovery to a development database with log retain = No from an online backup....

I first did a:
alter database config for X using logretain recovery

It completed, but did not take effect. I could not run a db2stop because there is multi databases associated with the Instance....

I then ran a:
db2 "restore database P from /dev/rmt1.1 into D buffer 256 replace existing "

restored the Log files from P to the SQLOGDIR for D, but was unable to rollforward....

I then tried to:
db2 "restore database P from /dev/rmt1.1 into D buffer 256 replace existing without rolling forward"

again failing due to the fact that it needed to be rolled forward....

I finally found a offline backup of the P database and was able to run.

Any Ideas of what I should of or could have done?????

 

[sathyarams]

Changing the logretain db cfg parameter does NOT require an instant restart ... 'Restart'ing the database will do ..

An online backup cannot be used unless you rollforward, atleast to a minimum point in time ..

A possibility is that you could have changed logretain recovery to no after restoring the backup ...

HTH

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8