搭建ADG过程中复制报错 RMAN-03009 ORA-03113

article/2025/9/14 16:57:41

搭建ADG过程中复制报错 RMAN-03009 ORA-03113

在这里插入图片描述
猜测主备之间网络路由过多导致。。。

开启mrp进程报错

在这里插入图片描述
发现数据文件是主库ASM的路径，备库是单机的

switch database to copy; 报错RMAN-6571

report schema;switch database to copy;

select name from v$datafile;select file#, name, checkpoint_change# from v$datafile_header;

参考链接

跳过数据文件2

switch datafile 1,2,3,4,5,6,7,8,9 to copy;;

在这里插入图片描述

问题：为什么size是 0 。。。

switch datafile 2 to copy;报错

alter database datafile 2 offline; 报错

alter database datafile 2 offline drop;

一种思路
另一种思路

恢复数据文件

主库备份

backup as compressed backupset datafile 2 format '/woqu/datafile_%U.bak' tag 'datafile2';

备库注册

catalog start with  '/woqu/datafile_%U.bak' ;
run{
set newname for datafile 2 to PATH/FILE_NAME;
restore datafile 2;
}

But失败了。。。

alter tablespace users rename datafile '当前库路径' to '备份文件';

成功了哎。。。

主库通道报错 ora-16058 & 备库 mrp进程gap状态

oerr ora 16058
16058, 00000, "standby database instance is not mounted"
// *Cause:  The Remote File Server (RFS) process on the standby database
//          received an internal error.
// *Action: Check the standby alert log and RFS trace files for more 
//          information.

重启备库。。。

oerr ora 01033
01033, 00000, "ORACLE initialization or shutdown in progress"
// *Cause: An attempt was made to log on while Oracle is being started up
//         or shutdown.
// *Action: Wait a few minutes. Then retry the operation.