oracle dg备库数据和日志转换路劲导致的报错

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/