DG修改standby_file_management参数

问题:dataguard备库MRP进程停止，查看告警日志有如下报错：
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (eisoostd)
Mon Apr 17 15:34:09 2017
MRP0 started with pid=26, OS id=4241
MRP0: Background Managed Standby Recovery process started (eisoostd)
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/app/oracle/diag/rdbms/eisoostd/eisoostd/trace/eisoostd_mrp0_4241.trc:
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00007'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00007'
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery process shutdown (eisoostd)

查看数据库信息：
SQL> select name from v$datafile;

NAME
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/eisoostd/system01.dbf
/u01/app/oracle/oradata/eisoostd/sysaux01.dbf
/u01/app/oracle/oradata/eisoostd/undotbs01.dbf
/u01/app/oracle/oradata/eisoostd/users01.dbf
/u01/app/oracle/oradata/eisoostd/test01.dbf
/u01/app/oracle/oradata/eisoostd/esb01.dbf
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00007

SQL> show parameter standby_file_management

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
standby_file_management          string     MANUAL

问题原因：
standby备库参数standby_file_management=manual,在主库添加数据文件时备库不能自动添加，导致备库应用主库日志中断。

解决方案：
手动添加数据文件并修改tandby_file_management为auto

1、修改备库参数文件，添加db_file_name_convert和log_file_name_convert参数
*.db_file_name_convert='/u01/app/oracle/oradata/eisoo','/u01/app/oracle/oradata/eisoostd'
*.log_file_name_convert='/u01/app/oracle/oradata/eisoo','/u01/app/oracle/oradata/eisoostd'

2、手动添加备库缺失的数据文件
SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00007' as '/u01/app/oracle/oradata/eisoostd/test02.dbf';

Database altered.

SQL> select name from v$datafile;

NAME
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/eisoostd/system01.dbf
/u01/app/oracle/oradata/eisoostd/sysaux01.dbf
/u01/app/oracle/oradata/eisoostd/undotbs01.dbf
/u01/app/oracle/oradata/eisoostd/users01.dbf
/u01/app/oracle/oradata/eisoostd/test01.dbf
/u01/app/oracle/oradata/eisoostd/esb01.dbf
/u01/app/oracle/oradata/eisoostd/test02.dbf

3、修改standby_file_management参数
SQL> alter system set standby_file_management = auto;

System altered.

4、启动MRP进程
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#,BLOCKS,PID FROM V$MANAGED_STANDBY;

PROCESS   STATUS      THREAD#  SEQUENCE#     BLOCK#     BLOCKS      PID
--------- ------------ ---------- ---------- ---------- ---------- ----------
ARCH      CLOSING        1      91       4096        787     4750
ARCH      CONNECTED        0       0          0      0     4752
ARCH      CONNECTED        0       0          0      0     4754
ARCH      CONNECTED        0       0          0      0     4756
RFS      IDLE            0       0          0      0     4927
RFS      IDLE            1      92       1771      1     4794
RFS      IDLE            0       0          0      0     4796
MRP0      APPLYING_LOG        1      92       1771    1024000     4864

5、查看备库日志应用情况：
SQL> select * from v$dataguard_stats;

NAME                 VALUE                                  UNIT                 TIME_COMPUTED            DATUM_TIME
-------------------------------- ---------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------
transport lag             +00 00:00:00                              day(2) to second(0) interval     04/17/2017 16:19:43        04/17/2017 16:19:41
apply lag             +03 05:22:28                              day(2) to second(0) interval     04/17/2017 16:19:43        04/17/2017 16:19:41
apply finish time         +00 00:00:22.627                          day(2) to second(3) interval     04/17/2017 16:19:43
estimated startup time         13    

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

转载于:http://blog.itpub.net/30373263/viewspace-2137422/