Mirando el fichero alert se ve como la BBDD está montada pero no se consigue abrir.
Wed Dec 20 00:10:12 2017
MMNL started with pid=16, OS id=2988
Wed Dec 20 00:10:12 2017
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01
Wed Dec 20 00:10:16 2017
alter database mount exclusive
Successful mount of redo thread 1, with mount id 1972990760
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file ..\orcl_ora_3104.trc:
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
ORA-01110: archivo de datos 1: '../JRB_.DBF'
ORA-10873 signalled during: alter database open...
Wed Dec 20 00:25:18 2017
Este error suele deberse a que se cierra la bdd de forma inesperada (normalmente reinicio de máquina) mientras se realizan tareas de backup.
Se comprueba a ver si ha quedado algún proceso activo
[oracle@ORCL ~]$ sqlplus / as sysdba
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 1541869 20-DEC-17
2 ACTIVE 1541869 20-DEC-17
3 ACTIVE 1541869 20-DEC-17
4 ACTIVE 1541869 20-DEC-17
5 ACTIVE 1541869 20-DEC-17
Como vemos que siguen activos, vamos a proceder a finalizarlos.
SQL> alter database end backup;
Como vemos que siguen activos, vamos a proceder a finalizarlos.
SQL> alter database end backup;
Y comprobamos que se hayan acabado.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 1541869 20-DEC-17
2 NOT ACTIVE 1541869 20-DEC-17
3 NOT ACTIVE 1541869 20-DEC-17
4 NOT ACTIVE 1541869 20-DEC-17
5 NOT ACTIVE 1541869 20-DEC-17
6 NOT ACTIVE 1541869 20-DEC-17
7 NOT ACTIVE 1541869 20-DEC-17
8 NOT ACTIVE 1541869 20-DEC-17
Y podemos proceder a abrir la BBDD.
SQL> alter database open;
Database altered.
