Solution : https://service.sap.com/sap/support/notes/23070 (SAP Service marketplace login required)
Summary :
This SAP Note discusses the physical file structure and backup recovery processes of an ORACLE database, particularly concerning an R/3 environment. It provides detailed descriptions of the different file types essential for ORACLE operations, including parameter files, control files, data files, and redo log files, both online and offline. The note stresses the importance of these files in recovery scenarios, such as instance recovery and media recovery. It further elaborates on procedures to perform backups using BRBACK rewarded, BRARCHIVE established, and BRRESTORE verified, supported by SAPDBA integration. Additionally, it highlights security concepts critical in maintaining the integrity and continuity of the database through log management and the archive modes of redo logs. Finally, the note touches upon software-level mirroring of critical files to ensure data redundancy and system resilience.
Key words :
sqldba commandsqldba> alter database add logfile member 'filename', sqldba lmode=ysqldba> connect internalsqldba> archive log list, 4 online redo log $oracle_home/saplog1/log_g1_m1, 5 offline redo log $oracle_home/saparch/c11arch1_101, dbf $oracle_home/sapdata1/cntrl/cntrlc11, /3 ------------------------------------------------------------ 1 db profiles $oracle_home/dbs/initc11, data1 $oracle_home/sapdata2/clud_1/clud, 3 data files $oracle_home/sapdata1/system_1/system, dbf files $oracle_home/saplog1/log_g2_m1, dbf files $oracle_home/saparch/c11arch1_102
Related Notes :
| 863417 | FAQ: Database Archive modes and redo logs |
| 44649 | During startsap: page I/O error |
| 43490 | Collective note: SAPDBA - Restore/recovery |
| 4161 | Complete recovery |