ORA-01110 While Shutdown if DB is in Begin Backup Mode (Doc ID 2499424.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Execute shutdown immediate failed with error ORA-1110 when DB is in begin backup mode.

eg.

SQL> alter database begin backup;

Database altered.


SQL> shutdown immediate
ORA-01149: cannot shutdown - file 1 has online backup set
ORA-01110: data file 1: '/<path>/system01.dbf'


message in alert.log
2019-01-10T02:49:14.396333+00:00
Shutting down instance (immediate) (OS id: 27092)
2019-01-10T02:49:16.827603+00:00
Stopping background process SMCO
Shutting down instance: further logons disabled
2019-01-10T02:49:19.426117+00:00
Errors in file <path>/<SID>_m000_27604.trc:
ORA-01110: data file 1: '/<path>/system01.dbf'
2019-01-10T02:49:19.702172+00:00
Errors in file <path>/<SID>_m000_27604.trc:
ORA-01110: data file 3: '/<path>/sysaux01.dbf'
2019-01-10T02:49:19.877972+00:00
Errors in file <path>/<SID>_m000_27604.trc:
ORA-01110: data file 4: '/<path>/undotbs01.dbf'
2019-01-10T02:49:20.022750+00:00
Errors in file <path>/<SID>_m000_27604.trc:
ORA-01110: data file 7: '/<path>/users01.dbf'

Changes

 on 12.2

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.