重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-10458 RA-01196 ORA-01110错误 [打印本页]

作者: 橡皮草帽 时间: 2020-3-6 14:03
标题: 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'

作者: 橡皮草帽 时间: 2020-3-6 14:11
本帖最后由橡皮草帽于 2020-3-6 14:16 编辑

解决办法：
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;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)