Solution : https://service.sap.com/sap/support/notes/4164 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the process for restoring a database to a previous state due to user errors, missing, or faulty log or data files. It outlines three methods for incomplete recovery: recovery until a specific time, system change number (SCN), or redo log file. Before conducting another recovery, the database must remain closed until all redo log files are imported. The procedure involves performing an offline backup, reloading data files, and executing recovery commands with specific attention to control files and recovery options. After opening the database with RESETLOGS, perform an immediate offline backup for future restorations.
Key words :
sql> connect internalsql> startup mountsql> alter database create datafile '<file_name>', > alter database datafile '<file_name>' online, archived online redo log files, > alter database open resetlogs, time 'yyyy-mm-dd, redo log files required, import redo log files, requested redo log files, required online redo logs, online redo log files
Related Notes :
| 605062 | FAQ: Restore and recovery |
| 132496 | SAPDBA: Repeat 'Full restore and recovery' |
| 43490 | Collective note: SAPDBA - Restore/recovery |
| 26312 | SAPDBA: data file "" could not be created. |
| 4161 | Complete recovery |