Solution : https://service.sap.com/sap/support/notes/594601 (SAP Service marketplace login required)
Key words : 
/oracle/t01/sapdata1/cntrl          /oracle/t01/sapdata2/cntrl          /oracle/t01/sapdata3/cntrl          /oracle/t01/sapdata1/system_1          /oracle/t01/sapdata1/roll_1          /oracle/t01/sapdata2/user1d_1          /oracle/t01/sapdata2/user1d_2          /oracle/t01/sapdata2/user1d_3          /oracle/t01/saparch          /oracle/t01/saptrace          /oracle/t01/saptrace/background     note, setenv oracle_sid t01    setenv sapdata_home /oracle/t01step 4, question     exp sapr3/<passwd> tables=<table_name> file=<table_name>, oracle software installedthe table, ------------------------t01, sql> set linesize 132 pagesize 30000    sql> spool df_offline, terms recreate table user error reason, sql    sql> select 'alter database datafile ', - sql> alter database open resetlogs, - sql> alter database open
Related Notes : 
       
| 605062 | FAQ: Restore and recovery |