RMAN restore tablespace from disk.

Hi all,

My database is in archivelog mode, I have backed up a tablespace to disk, now I am trying to do a restore of the tablespace. However, i have some problem with the syntax of the rman restore script. Hope someone can help me out here. Thanks.

Backup script:

connect target / run { allocate channel d1 type disk; backup tag tbs_ssapp format '/u05/BRCDMP/tbs_ssapp_%t_%s' (tablespace ssapp); release channel d1; }

Restore script:

connect target / run { allocate channel t1 type disk sql "alter tablespace SSAPP offline"; restore tablespace "SSAPP"; recover tablespace "SSAPP"; sql "alter tablespace SSAPP online";