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: '/opt/oracle/oradata/yoon/system01.dbf' 查看备库: SQL>select switchover_status from v$database; SWITCHOVER_STATUS --- TO PRIMARY 查...
SQL> alter database open read only; alter database open read only * 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: '/oracle/oradata/BSTYLE/system.309.766573511' alter.log有报错 Err...
Database mounted. ORA-10458: standby database requires recovery ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01111: name for data file 6 is unknown - rename to correct file ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNN AMED00006' 报...
[置顶] Oracle 11.2.0.3.0 Active Data Guard 遇 ORA-10458、ORA-01152、ORA-01110 错误 2013-06-12 18:27 −今天第一次配 Oracle 11g R2 Active Data Guard,在用 RMAN 创建好 physical standby database 后, 尝试将 standby 以 read only 方式打开时遇如下错误: SQL> alter database open rea... ...
* 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: '/u01/app/oracle/oradata/STANDBY/datafile/o1_mf_system_8v8y9m2x_.dbf'
51CTO博客已为您找到关于ora-10458 ora-01152 ora-01110的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及ora-10458 ora-01152 ora-01110问答内容。更多ora-10458 ora-01152 ora-01110相关解答可以来51CTO博客参与分享和学习,帮助广大IT技术人实现成长和进步。
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'===《《《⽇志结束》》》=== 解决⽅法...
10458ORA-01152ORA-01110.0 今天第一次配 Oracle 11g R2 Active Data Guard,在用 RMAN 创建好 physical standby database 后, 尝试将 standby 以 read only 方式打开时遇如下错误: SQL alter database open read only; alter database open read only * ERROR at line 1: ORA-10458: standby database ...
Hello! I have restore my Database for standby and I couldn't open it and show the error: ERROR at line 1: ORA-10458:
Database mounted. ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recoverysession ORA-01110: data file 1:'/u01/APP/oracle/oradata/orcl151/system01.dbf' 查询资料,确认到异常原因为日志的scn与控制文件不一致,以下为处理步骤: ...