Restore Oracle Database excluding some tablespaces
RESTORE


  Use an optional SKIP TABLESPACE 'tablespace_name' argument to avoid
  restoring specified tablespaces, which is useful when you want to
  avoid restoring tablespaces containing temporary data.
  
  If you specify SKIP FOREVER TABLESPACE, then RMAN specifies the DROP
  option of ALTER DATABASE DATAFILE ... OFFLINE when taking the
  datafiles that belong to the tablespace offline before the restore.
  The DROP option indicates that RMAN does not intend to recover these
  files and intends to drop their tablespaces from the database after
  the database is opened again. In other words, FOREVER indicates that
  RMAN never intends to do anything with the skipped tablespaces again.


Example:

RESTORE DATABASE SKIP FOREVER TABLESPACE TOOLS, EXAMPLE;