SAP Note 4157 - General flowchart for ORACLE recovery

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/4157 (SAP Service marketplace login required)

Summary :
This SAP Note focuses on the general recovery procedures for ORACLE 7.0, detailing actions and considerations for system restoration and highlighting the importance of error analysis in recovery scenarios. Key aspects include initial analysis such around environmental checks, system type inquiries, and ORACLE version specification. Recovery operations detailed include checks for transactional control files, error messages, and necessary actions such as using "fschk" for suspected hardware issues. A series of action notes (391, 4160, 4161, etc.) provide guidance on specific recovery instances, offering targeted solutions for scenarios like stuck archivers or defective redo logs.

Key words :
/usr/ora/<sid>/sapbackup/<sid>/backup<sid>, touch /usr/ora/<sid>/sapdata<#>/dummyfilecheck, missing  4163  defective redo logs  4164  incomplete recovery  4165  recovery, current online redo log file missing, cancel> alter database open resetlogs, /usr/ora/<sid>/sapcheckcheck, /usr/ora/<sid>/sapcheck, missing current redo log file, online redo log file missing, hard disk check/restore    run

Related Notes :

43494Collective note: BRBACKUP, BRARCHIVE, BRRESTORE