Re: partitioning

> 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"