ORA-10873: file 1 needs to be either taken out of backup mode or media recovered

Alert.log
---------
ALTER DATABASE OPEN
Errors in file C:\ORACLE\diag\rdbms\dbserver\dbserver\trace\dbserver_ora_3128.trc:
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
ORA-01110: data file 1: 'H:\ORACLE\ORADATA\dbserver\DATAFILES\SYSTEM01.DBF'
ORA-10873 signalled during: ALTER DATABASE OPEN...

C:\Users\a-tsolar>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 14 19:16:35 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL> select * from V$BACKUP;
     FILE# STATUS                CHANGE# TIME
---------- ------------------ ---------- ------------------
         1 ACTIVE                 504855 26-MAR-16
         2 ACTIVE                 504860 26-MAR-16
         3 ACTIVE                 504865 26-MAR-16
         4 ACTIVE                 504870 26-MAR-16
         5 ACTIVE                 504870 26-MAR-16
         6 ACTIVE                 504875 26-MAR-16
         7 ACTIVE                 504875 26-MAR-16
         8 ACTIVE                 504881 26-MAR-16
8 rows selected.

SQL> ALTER DATABASE END BACKUP;
Database altered.

SQL> alter database open;
Database altered.

SQL> select * from V$BACKUP;
     FILE# STATUS                CHANGE# TIME
---------- ------------------ ---------- ------------------
         1 NOT ACTIVE             504855 26-MAR-16
         2 NOT ACTIVE             504860 26-MAR-16
         3 NOT ACTIVE             504865 26-MAR-16
         4 NOT ACTIVE             504870 26-MAR-16
         5 NOT ACTIVE             504870 26-MAR-16
         6 NOT ACTIVE             504875 26-MAR-16
         7 NOT ACTIVE             504875 26-MAR-16
         8 NOT ACTIVE             504881 26-MAR-16
8 rows selected.
SQL>

Komentáře