standby 上面裸设备和系统文件错误-CSDN博客

sql>alter database rename file '/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037' to '/dev/virbase06'

sql>ALTER SYSTEM SET standby_file_management='auto' SCOPE=BOTH;

sql>alter database recover managed standby database disconnect from session;

--执行完后发现日志信息如下

alter database rename file '/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037' to '/dev/virbase06'

Mon Feb 25 13:29:29 2013

Completed: alter database rename file '/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037' to '/dev/virbase06'

Mon Feb 25 13:29:58 2013

ALTER SYSTEM SET standby_file_management='auto' SCOPE=BOTH;

Mon Feb 25 13:30:38 2013

alter database recover managed standby database disconnect from session

Mon Feb 25 13:30:38 2013

Attempt to start background Managed Standby Recovery process (virz1)

MRP0 started with pid=27, OS id=975038

Mon Feb 25 13:30:39 2013

MRP0: Background Managed Standby Recovery process started (virz1)

Mon Feb 25 13:30:44 2013

Managed Standby Recovery not using Real Time Apply

Mon Feb 25 13:30:44 2013

MRP0: Background Media Recovery terminated with error 1110

Mon Feb 25 13:30:44 2013

Errors in file /db/oracle/admin/rz/bdump/virz1_mrp0_975038.trc:

ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [37] [/dev/virbase06]

ORA-01122: Message 1122 not found; No message file for product=RDBMS, facility=ORA; arguments: [37]

ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [37] [/dev/virbase06]

ORA-01251: Message 1251 not found; No message file for product=RDBMS, facility=ORA; arguments: [37]

Mon Feb 25 13:30:44 2013

Errors in file /db/oracle/admin/rz/bdump/virz1_mrp0_975038.trc:

ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [37] [/dev/virbase06]

ORA-01122: Message 1122 not found; No message file for product=RDBMS, facility=ORA; arguments: [37]

ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [37] [/dev/virbase06]

ORA-01251: Message 1251 not found; No message file for product=RDBMS, facility=ORA; arguments: [37]

Mon Feb 25 13:30:44 2013

MRP0: Background Media Recovery process shutdown (rz1)

Mon Feb 25 13:30:45 2013

Completed: alter database recover managed standby database disconnect from session

--日志信息系统停止在这里，并未执行recover

--擦，通过执行错误，sql语句错误，最初系统自动创建'/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037'文件系统，而'/dev/virbase06'文件也是手工创建

--执行alter database rename file '/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037' to '/dev/virbase06'语句本身就存在逻辑错误，该语句应该在将原系统文件--“UNNAMED00037”拷贝到相对应的路径/dev情况下才能执行该语句

--通过查看系统目录并未发现该文件(执行语句如下)

--$ls -l /db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037

sql>select name from v$datafile where name like '%virbase06%'

1 name

2 --------

3 /dev/virbase06

sql>

--既然没有，那么可以继续执行create创建语句

sql>alter database create datafile '/dev/virbase06' as '/dev/virbase06';

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

转载于:http://blog.itpub.net/187805/viewspace-754693/