Solution : https://service.sap.com/sap/support/notes/4165 (SAP Service marketplace login required)
Summary :
Keyword: RECOVERY focuses on issues with Oracle database recovery post-structural modifications (e.g., tablespace manipulations and reorganizations). Key points include ensuring the control file reflects the DB’s updated physical structure prior to starting recovery, and only considering data files existent post-modification. To address recovery challenges, a structure-congruent control file is crucial, otherwise manual adjustments (Note 19519) might be necessary. A complete backup including OFFLINE DB or the current control file is recommended prior to any recovery attempts. Also, use "USING BACKUP CONTROLFILE" if the correct control file is missing, without reloading ONLINE redo logs, and be mindful of specific conditions dictated in notes 4161 and 4164 for complete or incomplete recovery processes.
Key words :
alter database create datafile 'filename' [, archived online redo logs, import redo log files, damaged online redo logs, redo log files required, data files affected offline, complete offline db backup, individual db data files, current control file exists, online redo logs
Related Notes :
| 605062 | FAQ: Restore and recovery |
| 43490 | Collective note: SAPDBA - Restore/recovery |