This content has been marked as final. Show 2 replies
please go through with the link Transportable Tablespace Option:
We are managing a huge amount of data warehouse on oracle 22.214.171.124.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'
please provide the last 50 line of alert log file.
See the documentation on TSPITR :
You would be using an Auxiliary Instance where the restore and recover of SYSTEM, SYSAUX, UNDO and the desired Tablespace is done. If you want the tablespace to be restored back into the original database, you would then use Transportable Tablespaces to transport the recover tablespace from the auxiliary to your original database.
Hemant K Chitale