Re: When is an offline backup not really offline?
Michael Hoffmann wrote:
> Keith wrote:
>> For Online case w/ include logs:
>> Look into LOGTARGET parameter of restore and use that in RF
> Thank you! Thank you! Thank you!
> That did the trick! :-D
> Now, all I need to do is figure out how to pass custom parameters to the
> automatic maintenance backup, so I can have it do online backups with
> INCLUDE LOGS and I'll breathe a lot easier.
One other note: With an offline backup, you have the option of
specifying 'WITHOUT ROLLING FORWARD' in the 'RESTORE DATABASE' command.
If you don't specify this -- then you can bring your database online
with the command, 'rollforward database complete'.
Also note (since no one else seemed to touch on this): You can
rollforward a database that is enabled for forward recovery regardless
of whether the backup was online or offline. By default (i.e. without
using the option mentioned above) DB2 will leave the database in
rollforward pending state.