#Recovers a ARCHIVELOG database from LOSS OF DATAFILES
#belonging to the USERS and TOOLS Tablespaces
# OPEN Database Tablespace Recovery
 
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
sql ' alter tablespace users offline immediate';
restore tablespace users;
sql ' alter tablespace tools offline immediate';
restore tablespace tools;
recover tablespace users ;
recover tablespace tools ;
sql 'alter tablespace users online ';
sql 'alter tablespace tools online ';
release channel c1;
release channel c2;
}