判断问题:
1. cat alert_xxx.log | grep “ORA-01111: name for data file” # Recomment
2. cat alert_xxx.log | grep “ORA-19502: write error on file”
3. cat alert_xxx.log | grep “ORA-01274: cannot add datafile” # Recomment,这里需要注意的是其中包含的数据路径如果不存在,需要手动创建。(注意路径所有人与所有组信息)

获取必要的信息:
set linesize 400;
col name for a30;

select file#,name,bytes from v$datafile where name like ‘【从上面错误信息中得到的信息】’;
select file#,name,bytes from v$datafile where file#>【从上面错误信息中得到的异常数据文件编号】; # 该查询会得到一个%UNNAME%的条目,记住这个路径。

解决问题:
1. alter system set standby_file_management=manual;
2. alter database create datafile ‘【出问题的当下v$datafile中查到的地址】’ as ‘【正确的真实地址】’;
3. select process,pid,client_pid,status,delay_mins,known_agents,active_agents from v$managed_standby;
4. alter database recover managed standby database disconnect from session;
5. alter system set standby_file_management=auto;

————————
Done。

1 thought on “Oracle DG:主库满,备库日志应用进程停滞的解决方法(Pure Code)”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装