ORA-01149:cannot shutdown-file 1 has online backup set
ORA-10873:file 1 needs to be either taken out of backup mode or media recovered
Fehler welcher ausgegeben wird:
SQL>; shutdown immediate; ORA-01149: cannot shutdown – file 1 has online backup set ORA-01110: data file 1: ‘/u01/app/oracle/oradata/system01.dbf’ SQL>; select a.tablespace_name, b.status from dba_data_files a, v$backup b where a.file_id = b.file# order by tablespace_name; TABLESPACE_NAME STATUS ------------------------------ ------------------ SYSAUX ACTIVE SYSTEM ACTIVE UNDOTBS1 ACTIVE USERS ACTIVE
zuerst versuchen:
SQL>; alter database end backup; Database altered.
wenn das nicht klappt:
SQL>; shutdown abort; ORACLE instance shut down.
Zum starten:
SQL> startup ORACLE instance started. Total System Global Area 1469792256 bytes Fixed Size 2213456 bytes Variable Size 1040189872 bytes Database Buffers 419430400 bytes Redo Buffers 7958528 bytes Database mounted.