OracleDataGuard_主库添加数据文件或创建表空间(三)

2014-11-24 09:16:49 · 作者: · 浏览: 5
/dev/raw/raw101' ORA-27041: unable to open file Linux Error: 13: Permission denied Additional information: 1 Fri Apr 8 10:00:22 2005 MTS; MRP0: Background Media Recovery process shutdown ARCH: Connecting to console port...
8.3.1.2.2 Recovering From Errors
8.3.1.2.2 恢复以上错误

To correct the problems described in Section 8.3.1.2.1, perform the following steps:

修改上节提到的错误,执行以下步骤:

Create the raw device on the standby database and assign permissions to the Oracle user.

在备库上创建裸设备,赋予oracle用户权限

Query the V$DATAFILE view. For example:

SQL> SELECT NAME FROM V$DATAFILE; NAME -------------------------------------------------------------------------------- /u01/MILLER/MTS/system01.dbf /u01/MILLER/MTS/undotbs01.dbf /u01/MILLER/MTS/sysaux01.dbf /u01/MILLER/MTS/users01.dbf /u01/MILLER/MTS/mts.dbf /dev/raw/raw100 /u01/app/oracle/product/10.1.0/dbs/UNNAMED00007 SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL; SQL> ALTER DATABASE CREATE DATAFILE 2 '/u01/app/oracle/product/10.1.0/dbs/UNNAMED00007' 3 AS 4 '/dev/raw/raw101';

In the standby alert log you should see information similar to the following:

在备用告警日志里你应该会看见以下相似的信息:

Fri Apr 8 10:09:30 2005 alter database create datafile '/dev/raw/raw101' as '/dev/raw/raw101' Fri Apr 8 10:09:30 2005 Completed: alter database create datafile '/dev/raw/raw101' a

On the standby database, set STANDBY_FILE_MANAGEMENT to AUTO and restart Redo Apply:

在备库,设置STANDBY_FILE_MANAGEMENT 为AUTO,然后重新启用重做应用:

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO; SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT;

At this point Redo Apply uses the new raw device datafile and recovery continues.

在这一点,重做应用使用新的裸设备上的数据文件并继续恢复。