ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl151/system01.dbf'
系统: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.
版权声明
本文仅代表作者观点,不代表博信信息网立场。