ontape warm restore question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug Fossmeyer - 30 Aug 2006 00:05 GMT

IDS 94FC8 using ontape for a restore. In performing a warm restore of a dbspace, how critical is it to have the exact same size and number of tempdb spaces? I have a tape from a previous period before we added several new tempdb spaces. I would rather not modify the system unless necessary to revert backwards or create a new instance just for this restore. The dbspaces for root, phy log, logical log and the to-be-restored space in question are the same. The manual talks of critical spaces being the exact same in size, name, offset, etc. Yet I am not sure if temp dbspaces is part of what they call the critical spaces.

Also, will the fc patch version be a hindrance? We have started this instance with fc2, applied fc6 and then fc8. The ontape -s -L 0 was from the fc6 patch.

Thanks in advance,
Doug

Reply to this Message

Superboer - 30 Aug 2006 08:03 GMT

> IDS 94FC8 using ontape for a restore. In performing a warm restore of a dbspace, how critical is it to have the exact same size and number of tempdb

you do not need the same tempspaces and sizes however
you have to have tempspace(s) which can hold the logical logs
configured in your system during the time the backup was taken
since you have to rollforward worst case a lot of logical logs.

you can use DBSPACETEMP env var to point to this big one and then
execute ontape....

realize that what you do not restore will be offline and not
accessible!!!

>>The manual talks of critical spaces

= rootdbs, dbspace where phys log and log logs reside in.

> Also, will the fc patch version be a hindrance? We have started this instance with fc2, applied fc6 and then fc8. The ontape -s -L 0 was from the fc6 patch.

Yes. installl fc6 to avoid problems before restoring.

Superboer

Doug Fossmeyer schreef:

> IDS 94FC8 using ontape for a restore. In performing a warm restore of a dbspace, how critical is it to have the exact same size and number of tempdb spaces? I have a tape from a previous period before we added several new tempdb spaces. I would rather not modify the system unless necessary to revert backwards or create a new instance just for this restore. The dbspaces for root, phy log, logical log and the to-be-restored space in question are the same. The manual talks of critical spaces being the exact same in size, name, offset, etc. Yet I am not sure if temp dbspaces is part of what they call the critical spaces.
>
> Also, will the fc patch version be a hindrance? We have started this instance with fc2, applied fc6 and then fc8. The ontape -s -L 0 was from the fc6 patch.
>
> Thanks in advance,
> Doug

Reply to this Message