Recovering a Tablespace While Database Is Open With RMAN

The following example takes tablespace USERS offline, restores and recovers it, then brings it back online:

run {
allocate channel c1 device type disk;
sql "ALTER TABLESPACE USERS OFFLINE IMMEDIATE";
restore tablespace USERS;
recover tablespace USERS;
sql "ALTER TABLESPACE USERS ONLINE";
}