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:
在备用告警日志里你应该会看见以下相似的信息:
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.
在这一点,重做应用使用新的裸设备上的数据文件并继续恢复。