DataGuard ORA-01119 ORA-27054错误解决

DataGuard ORA-01119 ORA-27054错误解决

环境信息:

主库使用裸设备

备库使用file system

现象：

DataGuard异常

select process,status,sequnece#,thread# from v$managed_standby查不MRP进程 

standby alter log 错误信息:

File $1990 added to control file as 'UNNAMED01990'

.......

MRP0 Background Media Recovery terminated with error 1119

......

......

ORA-01119: error in creating database file '/dev/vx/rdk/barpxx/xxxx'

ORA-27054 NFS file system where the file is created or resides is not mounted with correct options

SRV4 Error: 13 Permission denied 

原因分析:

主机新增加vg后备库没有对db_file_name_convert参数修改，导致创建数据文件路径不存在

解决方法：

1.修改db_file_name_convert参数

2.手动创建数据文件

  alter system set standby_file_management=mannul scope=memory

  alter database create datafile  1990 as '/dataxx/xxxxdata/xxxxxxxx'

  alter system set standby_file_management=auot scope=memory

3.开启日志应用

  alter database recover managed standby database using current logfile  disconnect;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7419833/viewspace-713121/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7419833/viewspace-713121/