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

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 74|回复: 0

[Oracle] Logical Standby Databases Out Of Sync, ORA-01537 in dba_logstdby_events

[复制链接]
发表于 2024-7-7 17:41:50 | 显示全部楼层 |阅读模式
现象:
********

Disclaimer:

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

********

1. Logical Standby Databases Out Of Sync
2. ORA-01537 in dba_logstdby_events

改动:
A new data file has been added to the primary database

原因:
SELECT TO_CHAR(event_time, 'MM/DD HH24:MI:SS') time, commit_scn, current_scn, event, status FROM dba_logstdby_events ORDER BY event_time, commit_scn, current_scn;


02/03 16:22:37 8843273604198 8843273604195 alter tablespace <tablespace name> add datafile '/<directory>/oradata/database/<ta ORA-01537: cannot add file '/<directory>/oradata/database/ database_<tablespace name>_02.dbf' - file already part of database
02/03 16:22:42 ORA-16222: automatic Logical Standby retry of last action
02/03 16:22:42 Apply LWM 8843273604165, HWM 8843273604165, SCN 88 43273604164
02/03 16:22:42 ORA-16111: log mining and apply setting up
02/03 16:38:03 8843273604198 8843273604195 alter tablespace <tablespace name> add datafile '/<directory>/oradata/database/database_<tablespace name> ORA-01537: cannot add file '/u03/oradata/database/ database_<tablespace name>02.dbf' - file already part of database

A data file was added on the primary.
The same data file exists already on the standby side.
The standby_file_management parameter is set to AUTO


处理方法:
If the entire primary database is replicated to the logical standby database and if don't update the logical standby databases manually ( outside of primary) then must stop the apply on the logical standby and drop the existing file.
If don't use the same data file structure on primary and logical standby, so the data files on the logical standby are added manually then should  skip this DDL.

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-7-22 12:07 , Processed in 0.092776 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表