当主备的目录结构不同时,需要设定db_file_name_convert进行路径转换,并设定standby_file_management=auto;但在某些情况下(例如BUG),仍会发生无法转换的状况,此时就需要进行手工同步。
1. 关闭备库MRP
SQL> alter database recover managed standby database cancel;
2. 确认从主库传送过来的新数据文件名
SQL> select name from v$datafile;
NAME
--------------------------------------------------
/u02/youngyang/oradata01/system01.dbf
/u02/youngyang/oradata02/undotbs01.dbf
/u02/youngyang/oradata01/sysaux01.dbf
/u02/youngyang/oradata01/users01.dbf
/opt/oracle/product/10.2.0/db_1/dbs/UNNAMED00005
3. 更改备库参数standby_file_managemen为manual
SQL> alter system set standby_file_management=manual scope=both;
System altered.
4. 依据主库路径,创建备库新数据文件
SQL> alter database create datafile '/opt/oracle/product/10.2.0/db_1/dbs/UNNAMED00005' as '/u02/youngyang/oradata01/users02.dbf';
Database altered.
5. 更改备库参数standby_file_managemen为auto
SQL> alter system set standby_file_management=auto scope=both;
System altered.
6. 启动备库MRP
SQL> alter database recover managed standby database disconnect from session;
Database altered.
发表评论