可能一、(最普遍)
确实某个数据文件有问题,offline掉,重新恢复或者直接重新恢复
可能二、(最普遍)(dg没加convert参数或者写错,主库新位置添加数据文件)
方法一、手动
关mrp
alter database recover managed standby database cancel;
Show parameter standby_file_management
Alter system set standby_file_management=manual;
Alter database create datafile 103 as ‘/xxxx/xxx/xxxx/xxxx/abc.dbf’;
如果报错(ORA-01156)
看下mrp关了没
alter system set standby_file_management=auto scope=both;
备库改convert(redo的酌情要不要,db的一定要)
alter system set db_file_name_convert=‘/oracle/app/oradata/orcl2/’,‘/oracle/app/oradata/orcl1/’ scope=spfile;
alter system set log_file_name_convert=‘/oracle/app/oradata/orcl2/’,‘/oracle/app/oradata/orcl1/’ scope=spfile;
开mrp
alter database recover managed standby database disconnect from session;(非实时应用)
alter database recover managed standby database using current logfile disconnect from session;(实时应用)
方法二、自动
关mrp
alter database recover managed standby database cancel;
开omf
Alter system set db_create_file_dest=‘/das/wqe/ewq/raaa’ sid=‘*’ scope=both;
备库改convert(log_file_name_convert酌情要不要,db的一定要)
alter system set db_file_name_convert=‘/oracle/app/oradata/orcl2/’,‘/oracle/app/oradata/orcl1/’ scope=spfile;
alter system set log_file_name_convert=‘/oracle/app/oradata/orcl2/’,‘/oracle/app/oradata/orcl1/’ scope=spfile;
开mrp
alter database recover managed standby database disconnect from session;(非实时应用)
alter database recover managed standby database using current logfile disconnect from session;(实时应用)
可能三、
temp文件问题,重建temp文件
可能四、
Doc ID 184327.1 mos上很多种可能