Brian Peasland wrote:
>>If I start one of these instances and my read-only historical data is
>>offline/on a broken hd/, I will gain access to the "current" table data
>>stored in the tablespace TB_CUR ?
>
>
> Since only one instance can control that tablespace, you will have to
> restore that tablespace for that instance before either instance can get
> data out of it, the first instance directly, and the second instance
> through a db link.
>
>
>>Suppose that I want to recover the DB.
>>I got a fresh backup of all data but I saved that historical tablespace only
>>once, because the backup procedure lasts too much in the night and I didn't
>>want to put a 5GB tablespace in readonly on my tapes .
>>Can I restore it without problem, since it was in read-only ?
>
>
> The nice thing about READ ONLY tablespaces is that you do not have to
> repeatedly backup them up. Just make sure that you do have a backup of
> that tablespace *after* you put it in READ ONLY mode. Then, this backup
> can be months old and you can use it to help restore your database. As
> with any backup/recovery plan, you'll want to test this out so that you
> know how it is done before you *need* to do it.
>
> HTH,
> Brian
>
How's putting it on CD/DVD?
--
Regards, Frank van Bortel
Received on Thu Oct 23 2003 - 15:08:19 CDT
