搭建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.