首页 > 数据库 > oracle > 正文

alter database open命令报错误
2016-11-08 15:25:09   来源:cnop   评论:0 点击: 收藏

SQL> alter database open; 命令报如下错误ERROR at line 1:ORA-10458: standby database requires recoveryORA-01152: file

SQL> alter database open;     #命令报如下错误

ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/data/oracle/oradata/dg/system01.dbf'

主服务器日志如下:

tail -f /data/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log




原因:可能为密码不一致相关,重新同步主服务器orapworcl 密码。

从服务器:

$cd /data/oracle/product/11.2.0/db_1/dbs/
$scp oracle@192.168.0.200:/data/oracle/product/11.2.0/db_1/dbs/orapworcl  ./      
#说明,上面ip为我服务器ip和路径,请根据实际情况修改,或用其他方式拷贝。
$cp orapworcl orapwdg


重新启动数据库:

$sqlplus / as sysdba
SQL> startup nomount

ORACLE instance started.

Total System Global Area  977076224 bytes
Fixed Size      2219312 bytes
Variable Size    570426064 bytes
Database Buffers   398458880 bytes
Redo Buffers      5971968 bytes

SQL> alter database mount standby database;


Database altered.

SQL> alter database open;


Database altered.

相关热词搜索:命令 错误

上一篇:ORA-00401: the value for parameter compatible is not supported by this release
下一篇:oracle11g需要扩大共享内存shm的修改