Solution : https://service.sap.com/sap/support/notes/639986 (SAP Service marketplace login required)
Key words :
terms recover databaseadvance log sequence reason, sql> alter system dump logfile '<path, sql sql> select 'alter database datafile ', /oracle/<sid>/saptrace/usertrace directory, sqlsql> select 'alter database datafile ', script completely recovers data files, recovery ignores offline data files, sqlsql> select 'recover datafile ', approximately 3x<redologfile sizes>, database parameter setting check
Related Notes :
| 605062 | FAQ: Restore and recovery |
| 491160 | Restore scenarios for lost files of oracle databases |