Oracle错误

显示全部楼层 · 2014-7-24 11:05:12

数据库是另一数据库的同步，现进入sqlplus，出现如下提示，无法进入，什么原因？
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 16 09:32:11 2014

Copyright (c) 1982, 2013, Oracle.All rights reserved.

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Enter user-name:

千问 · 2014-7-24 11:05:12

sqlplus / as sysdba
shutdown immediate
startup
--关闭后启动试试,信息贴多点

千问 · 2014-7-24 11:05:12

z597011036 发表于 2014-9-16 09:51
sqlplus / as sysdba
shutdown immediate
startup
--关闭后启动试试,信息贴多点
多谢！
我运行之后显示如下：
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size
2260088 bytes
Variable Size
1140851592 bytes
Database Buffers 3120562176 bytes
Redo Buffers
12107776 bytes
Database mounted.
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '+DATADG/lotus_stb/datafile/system.288.852804935'

千问 · 2014-7-24 11:05:12

那个错误提示说明数据库正在启动或者处于关闭状态。如果shutdown immedite不行；你试试这样。
sqlplus / as sysdba
startup open;
然后就可以登录oarcle进行各类操作了

千问 · 2014-7-24 11:05:12

月光宝盒-pb 发表于 2014-9-16 10:01
多谢！
我运行之后显示如下：
参考一下看能否解决问题:http://blog.csdn.net/fffygapl/article/details/8541374

千问 · 2014-7-24 11:05:12

db_master 发表于 2014-9-16 10:04
那个错误提示说明数据库正在启动或者处于关闭状态。如果shutdown immedite不行；你试试这样。
sqlplus / a ...
结果还是一样不行。
SQL> startup open;
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size
2260088 bytes
Variable Size
1140851592 bytes
Database Buffers 3120562176 bytes
Redo Buffers
12107776 bytes
Database mounted.
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '+DATADG/lotus_stb/datafile/system.288.852804935'

千问 · 2014-7-24 11:05:12

月光宝盒-pb 发表于 2014-9-16 10:08
结果还是一样不行。
SQL> startup open;
ORACLE instance started.
你这是控制文件出问题了，所以无法open，只能到mount状态。是不是备份过？
我解决不了，坐等大神。

千问 · 2014-7-24 11:05:12

ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '+DATADG/lotus_stb/datafile/system.288.852804935'
dg库？
你再应用日志，然后看看