9I DATAGUARD备库的MRP0进程shutdown

1.巡检时发现备库的alert中有以下告警信息，9i+AIX
 sort_area_size           = 524288
 "alert_jtpstd.log" 10970 lines, 460367 characters
 Media Recovery Waiting for thread 1 seq# 8110
 Thu Apr 12 12:11:15 2012
 RFS: Possible network disconnect with primary database
 Thu Apr 12 12:12:02 2012
 Media Recovery Log /arch/p750/1_8110.dbf
 Media Recovery Waiting for thread 1 seq# 8111
 Thu Apr 12 12:12:25 2012
 RFS: Possible network disconnect with primary database
 Thu Apr 12 12:14:32 2012
 Media Recovery Log /arch/p750/1_8111.dbf
 Media Recovery Waiting for thread 1 seq# 8112
 Media Recovery Log /arch/p750/1_8112.dbf
 Thu Apr 12 13:38:58 2012
 Media Recovery Waiting for thread 1 seq# 8113
 Media Recovery Log /arch/p750/1_8113.dbf
 Thu Apr 12 14:56:46 2012
 Media Recovery Waiting for thread 1 seq# 8114
 Media Recovery Log /arch/p750/1_8114.dbf
 WARNING: File being created with same name as in Primary
 Existing file may be overwritten
 File #15 added to control file as 'UNNAMED00015'. Originally created as:
 '/oradata/jtp/perfstat.dbf'
 Recovery was unable to create the file as:
 '/oradata/jtp/perfstat.dbf'
 MRP0: Background Media Recovery terminated with error 1274
 Thu Apr 12 15:24:47 2012
 Errors in file /oranew/admin/jtp/bdump/jtpstd_mrp0_303302.trc:
 ORA-01274: cannot add datafile '/oradata/jtp/perfstat.dbf' - file could not be created
 ORA-01119: error in creating database file '/oradata/jtp/perfstat.dbf'
 ORA-27040: skgfrcre: create error, unable to create file
 IBM AIX RISC System/6000 Error: 13: Permission denied
 Some recovered datafiles maybe left media fuzzy
 Media recovery may continue but open resetlogs may fail
 MRP0: Background Media Recovery process shutdow
2.使用一下脚本mrp0确实没有啦
 selec process,status,sequence# from v$manager_standby;
 只剩下rfs进程了，而且日志已经中断了一段时间了
3.尝试取消日志的应用，已经停掉了
SQL> alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active
4.查询数据文件发现出了问题“/oranew/ora9i/dbs/UNNAMED00015”
SQL> SELECT NAME FROM V$DATAFILE;

NAME
--------------------------------------------------------------------------------
/oradata/jtp/system01.dbf
/oradata/jtp/undotbs01.dbf
/oradata/jtp/cwmlite01.dbf
/oradata/jtp/drsys01.dbf
/oradata/jtp/example01.dbf
/oradata/jtp/indx01.dbf
/oradata/jtp/odm01.dbf
/oradata/jtp/tools01.dbf
/oradata/jtp/users01.dbf
/oradata/jtp/xdb01.dbf
/oradata/jtp/system02.dbf

NAME
--------------------------------------------------------------------------------
/oradata/jtp/jtp_data1.dbf
/oradata/jtp/jtp_indx1.dbf
/oradata/jtp/jtp_data2.dbf
/oranew/ora9i/dbs/UNNAMED00015
5.手工接管
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;

System altered.
6.可以和主库的数据文件对一下，是由于之前安装statspack创建了perfstat的数据文件；
然后走了些弯路，尝试创建文件失败
SQL> create tablespace perfstat datafile '/oradata/jtp/perfstat.dbf' size 1024m;
create tablespace perfstat datafile '/oradata/jtp/perfstat.dbf' size 1024m
*
ERROR at line 1:
ORA-01109: database not open
--悲催的9i数据库
SQL> alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-16003: standby database is restricted to read-only access
7.从主库想办法
sql>alter tablespace perfstat begin backup;
cp /oradata/jtp/perfstat.dbf' /tmp/
sql>alter tablespace perfstat end backup;
scp /tmp/perfstat.dbf  备的ip：/tmp/
主库热备，考到备库，但是没装scp，而且备库/tmp只有1g，用ftp搞定
8.关键的一步,注意目录的主属
alter database rename file '/oranew/ora9i/dbs/UNNAMED00015' to '/oradata/jtp/perfstat.dbf';
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oradata/jtp/system01.dbf
/oradata/jtp/undotbs01.dbf
/oradata/jtp/cwmlite01.dbf
/oradata/jtp/drsys01.dbf
/oradata/jtp/example01.dbf
/oradata/jtp/indx01.dbf
/oradata/jtp/odm01.dbf
/oradata/jtp/tools01.dbf
/oradata/jtp/users01.dbf
/oradata/jtp/xdb01.dbf
/oradata/jtp/system02.dbf

NAME
--------------------------------------------------------------------------------
/oradata/jtp/jtp_data1.dbf
/oradata/jtp/jtp_indx1.dbf
/oradata/jtp/jtp_data2.dbf
/oradata/jtp/perfstat.dbf
9.开日志接受
alter system set STANDBY_FILE_MANAGEMENT=auto；
alter database recover managed standby database disconnect from session;
观察alter log，日志开始接受了
10.好了，喝口水吧....

转载于:https://www.cnblogs.com/myOracle/archive/2012/04/14/2447014.html