Re: Online Restore: exclusive access to tablespaces
If you use logretain or userexit, you can restore one or more tablespaces or the entire database ...
In case you are restoring only a few tablespaces, then specify the name of that tablespace along with the keyword online ... This will require exclusive acess only to the tablespace in question
For more details look into the comnmand reference
Originally posted by globetrotcom
I read that, for online restoration, exclusive access is required only for the tablespaces being restored.
I am curious as to how do you procure this exclusive access to tablespaces being restored on an online database.
Doesn't one, usually, backup all the tables, hence all tablespaces, in a database backup? If that's true, don't we need exclusive access to the full database for restore?
You can tell I am a newbie!
Visit the new-look IDUG Website , register to gain access to the excellent content.