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 [email protected]:/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.