ORA-10458 RA-01196 ORA-01110错误

橡皮草帽

打开从库数据库遇到报错：
SQL> select open_mode from v$database;
OPEN_MODE
----------------------------------------
MOUNTED
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-10458: standby database requires recovery
ORA-01196: 文件 1 由于介质恢复会话失败而不一致
ORA-01110: 数据文件 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF'

橡皮草帽

解决办法：
1.从库启动到mount状态：
SQL> shutdown immediate
SQL> startup mount

SQL> alter database recover managed standby database using current logfile disconnect from session;

2.主库操作
SQL> aliter system witch logfile;

3.备库操作：
SQL> alter database recover managed standby database finish force;
SQL> alter database open;

SQL> alter database recover managed standby database using current logfile disconnect from session;