Restore script

[adewri]

for restoring the tablespace

run {
allocate channel c1 type 'SBT_TAPE';
recover tablespace "XOVOLT01X";
release channel c1;
}

or

run {
allocate channel c1 type 'SBT_TAPE';
restore (datafile number);
recover tablespace "XOVOLT01X";
release channel c1;
}

well if you have a full database backup all you need to do is

run {
allocate channel c1 type 'SBT_TAPE';
recover databse;
release channel c1;
}

RMAN will see what all you need to recover and all your headach is gone :-) (of course if you want to have full control then you can use the other options as well)

in the event of a failure do I have to specify each individual one.

depends on how many you loose together...
what you can do is

run {
allocate channel c1 type 'SBT_TAPE';
recover tablespace "XOVOLT01X";
recover tablespace "XOVOLT02X";
recover tablespace "XOVOLT03X";
recover tablespace "XOVOLT04X";
release channel c1;
}

HTH