Inicio Foros Bases de datos Oracle Error ORA-01033 Inicialización o cierre de ORACLE en curso Respuesta a: Error ORA-01033 Inicialización o cierre de ORACLE en curso

#3660
Varios
Moderador

En el archivo que comentas, /opt/oracle/diag/rdbms/ora2/ORA2/trace/alert/log.xml me sale esto:

<msg time=’2019-07-30T22:27:00.158+02:00′ org_id=’oracle’ comp_id=’rdbms’
msg_id=’opiexe:3147:2802784106′ client_id=» type=’NOTIFICATION’
group=’admin_ddl’ level=’16’ host_id=’servidor.oracle.com’
host_addr=’192.168.1.100′ module=’sqlplus@servidor.oracle.com (TNS V1-V3)’ pid=’4360′>
<txt>Completed: ALTER DATABASE MOUNT
</txt>
</msg>
<msg time=’2019-07-30T22:27:00.178+02:00′ org_id=’oracle’ comp_id=’rdbms’
msg_id=’opiexe:3076:4222364190′ client_id=» type=’NOTIFICATION’
group=’admin_ddl’ level=’16’ host_id=’servidor.oracle.com’
host_addr=’192.168.1.100′ module=’sqlplus@servidor.oracle.com (TNS V1-V3)’ pid=’4657′>
<txt>ALTER DATABASE OPEN
</txt>
</msg>
<msg time=’2019-07-30T22:27:00.298+02:00′ org_id=’oracle’ comp_id=’rdbms’
client_id=» type=’UNKNOWN’ level=’16’
host_id=’servidor.oracle.com’ host_addr=’192.168.1.100′ module=’sqlplus@servidor.oracle.com (TNS V1-V3)’
pid=’4657′>
<txt>Errors in file /opt/oracle/diag/rdbms/ORA2/ORA2/trace/ORA2_ora_4657.trc:
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
ORA-01110: archivo de datos 1: /ORA2/ORA2/datafile/o1_mf_system_dc0ytsk9_.dbf
</txt>
</msg>
<msg time=’2019-07-30T22:27:00.298+02:00′ org_id=’oracle’ comp_id=’rdbms’
msg_id=’opiexe:3138:2780954927′ client_id=» type=’NOTIFICATION’
group=’admin_ddl’ level=’16’ host_id=’servidor.oracle.com’
host_addr=’192.168.1.100′ module=’sqlplus@servidor.oracle.com (TNS V1-V3)’ pid=’4657′>
<txt>ORA-10873 signalled during: ALTER DATABASE OPEN…
</txt>
</msg>
<msg time=’2019-07-30T22:31:20.539+02:00′ org_id=’oracle’ comp_id=’rdbms’
client_id=» type=’UNKNOWN’ level=’16’
host_id=’servidor.oracle.com’ host_addr=’192.168.1.100′ module=’backup incr datafile’
pid=’6524′>
<txt>ARCH: STARTING ARCH PROCESSES
</txt>
</msg>
<msg time=’2019-07-30T22:31:20.550+02:00′ org_id=’oracle’ comp_id=’rdbms’
msg_id=’ksbrdp:4257:1214121915′ type=’NOTIFICATION’ group=’process start’
level=’16’ host_id=’servidor.oracle.com’ host_addr=’192.168.1.100′