DB version: 11.2.0.4
OS : Oracle Linux 6.6
I have the RMAN full backup of my production DB. Now, I want to restore this DB into another server (test DB server) .
But, out of 95 tablespaces, I want only one tablespace (FXDAT_TBS) to be restored obviously along with the essential ones like SYSTEM, SYSAUX, TEMP,UNDO. So, I can use SKIP clause as shown below and list all the tablespace I don't want as shown below. But this is going to be long as I will have to list 94 tablespaces.
run
{
RESTORE DATABASE SKIP TABLESPACE TBS1, TBS2,TBS3,TBS4..... TBSn ;
RECOVER DATABASE SKIP TABLESPACE TBS1, TBS2,TBS3,TBS4..... TBSn ;
}
Is there any other way to tell RMAN to restore only one tablespace plus the essential ones like SYSTEM, SYSAUX, TEMP,UNDO in a shorter way ?
The below won't work because SYSTEM, SYSAUX,UNDO won't be restored . Right ?
run
{
RESTORE TABLESPACE FXDAT_TBS;
RECOVER TABLESPACE FXDAT_TBS ;
}