SAP Note 4162 - Missing "end backup"

Component : Oracle -

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

Summary :
This SAP Note addresses issues encountered with Oracle database shutdowns and restarts marked by errors ORA-01149, ORA-01113, and ORA-01110, which indicate problems like ongoing online backups and potential data file recoveries. The root causes are identified primarily as forgotten terminations of "end backup" commands post-online database backups, or disruptions during these backups. Resolutions involve executing "end backup" for affected tablespaces or using a SQL command to end all backups if the database remains in an open state. Additionally, guidelines for managing Oracle database backups, recovery procedures, and related SAPDBA and ORACLE documentation references are provided.

Key words :
sql> alter database datafile '<datafile>' end backup, simple commandsql> alter database end backup, sql> alter tablespace <tspname> end backup, sqlsql> select 'alter database datafile ', withsql> alter database end backup, alter tablespace <tspname> begin backup, sql> alter database open, manual online db backup, database shutdown fails, sql> startup mount

Related Notes :

656363Composite SAP Note: ORA-01194/ORA-01195
618868FAQ: Oracle performance
605062FAQ: Restore and recovery
43490Collective note: SAPDBA - Restore/recovery