SQL> alter database open read only
2 ;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
2 ;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf'
解决办法:
SQL> alter database recover managed standby database using current logfile disconnect from session; (需要在备库建立standby logfile,否则会出现ORA-38500错误)
在主库
sql> alter system switch logfile;
在备库
SQL> alter database recover managed standby database cancel;
数据库已更改。
SQL> alter database open;