please go through with the link Transportable Tablespace Option:
We are managing a huge amount of data warehouse on oracle 220.127.116.11.0. We need to take backup using rman of some tablespace not the whole database backup. we need a backup strategy in which we can restore the backup of some tablespace plus oracle instance if any disaster occur.
did you use the option like
I have taken backup using rman on test db of system , sysaux , user tablespace then i restore these tablespace successfully and make the remaining tablespace offline , but while open the database it show me below error. My question is how i backup using rman so that in case of disaster i restore oracle instance plus specific tablespace not full database. ERROR at line 1: ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\APP\ADMINISTRATOR\ORADATA\SYSTEM\SYSTEM01.DBF'