ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl151/system01.dbf'
2025-05-19 09:04:30 阅读次数:2
data,oracle
系统:CentOS 7.9
数据库:11.2.0.4
问题描述:在物理备库重新duplicate后,open数据库报错ORA-10458、ORA-01152、ORA-01110,如下所示:
SQL> alter database open;
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: '/u01/app/oracle/oradata/orcl151/system01.dbf'
解决过程:
查看主库log_archive_config、log_archive_dest_2参数,均未做设置.此为之前测试时做的的更改.
SQL> show parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string
重新设置该参数.
SQL> alter system set log_archive_config='dg_config=(orcl150,orcl151)';
System altered.
SQL> alter system set log_archive_dest_2='service=orcl151 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl151';
System altered.
备库执行
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
主库执行
SQL> alter system switch logfile;
System altered.
备库执行
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
结论:备库恢复正常.
注意:主库未设置log_archive_config、log_archive_dest_2参数,测试后备库也可以执行duplicate.
版权声明:本文内容来自第三方投稿或授权转载,原文地址:https://blog.51cto.com/u_12991611/5668215,作者:Liujun_Deng,版权归原作者所有。本网站转在其作品的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如因作品内容、版权等问题需要同本网站联系,请发邮件至ctyunbbs@chinatelecom.cn沟通。
上一篇:《剑指Offer》按之字形顺序打印二叉树——最容易理解的思路,两分钟学会~
下一篇:mysql只有在任务处于完成状态才能运行