DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/BJDB ','/u02/oradata/stddb'
LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/BJDB ','/u02/oradata/stddb'
如果'/u01/app/oracle/oradata/BJDB '中包含空格,备库的数据文件和日志文件的位置会和主库的位置一样,而不会显示备库自己实际的位置,MRP进程会挂掉,由于数据文件和日志文件的实际位置与系统里记录的位置不一样,会提示找不到数据文件,执行alter database recover managed standby database disconnect from session;以后报错如下:
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (std)
Mon Dec 07 10:07:13 2015
MRP0 started with pid=22, OS id=3061
MRP0: Background Managed Standby Recovery process started (std)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Mon Dec 07 10:07:18 2015
Errors in file /u01/app/oracle/diag/rdbms/tianjin/std/trace/std_dbw0_2953.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/app/oracle/oradata/BJDB/system01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
去掉转换路径中的空格应用日志正常。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29302187/viewspace-1867876/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29302187/viewspace-1867876/