Oracle10.2.0.4

Linux AS 5.3    3 nodes

今天做了一些大批量数据的处理及table字段改变， 3节点的producction DB 对应的
一个单台的Standby ， standby上的归档恢复发生错乱 。 如下： 

Media Recovery Log /ocfs_data/mxdell/arch/3_5901_703296551.arc
Errors with log /ocfs_data/mxdell/arch/3_5901_703296551.arc
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Sun Jan 31 14:30:06 2010
ALTER DATABASE RECOVER CANCEL
Sun Jan 31 14:30:08 2010
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Sun Jan 31 15:00:02 2010 
ALTER DATABASE RECOVER  standby database
Media Recovery Start
Managed Standby Recovery not using Real Time Apply
 parallel recovery started with 15 processes
ORA-279 signalled during: ALTER DATABASE RECOVER  standby database  ...
Sun Jan 31 15:00:02 2010
ALTER DATABASE RECOVER    CONTINUE DEFAULT
Sun Jan 31 15:00:02 2010
Media Recovery Log /ocfs_data/mxdell/arch/4_2364_703296551.arc
ORA-279 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Sun Jan 31 15:00:02 2010
ALTER DATABASE RECOVER    CONTINUE DEFAULT
Sun Jan 31 15:00:02 2010
Media Recovery Log /ocfs_data/mxdell/arch/3_3450_703296551.arc
Errors with log /ocfs_data/mxdell/arch/3_3450_703296551.arc
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Sun Jan 31 15:00:02 2010 
ALTER DATABASE RECOVER CANCEL
Sun Jan 31 15:00:05 2010
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Sun Jan 31 15:30:01 2010

on production db (node1) :
SQL> alter database create standby controlfile as '/u01/bb.ctl'  ;

copy bb.ctl to standby controlfile directory such as  /ocfs_data/mxdell/

then , shutdown immediate database (Standby DB)
$ cp  bb.ctl  control01.ctl
$ cp  bb.ctl  control02.ctl
$ cp  bb.ctl  control03.ctl 

SQL> startup nomount ;
SQL> alter database mount standby database;   

SQL> alter system set standby_file_management='MANUAL' scope=both;

SQL> recover standby database;

alter database create datafile '/ocfs_data/mxdell/undotbs03_2.dbf' as

'/ocfs_data/mxdell/undotbs03_2.dbf';

SQL> recover standby database;  --  if need datafile , try create datafile again . 

alter database create datafile '/ocfs_data/mxdell/undotbs01_3.dbf' as

'/ocfs_data/mxdell/undotbs01_3.dbf';

alter database create datafile '/ocfs_data/mxdell/undotbs01_4.dbf' as

'/ocfs_data/mxdell/undotbs01_4.dbf';

....

alter system set standby_file_management='AUTO' scope=both;

shutdown immedaite;

SQL> startup nomount ;
SQL> alter database mount standby database;    
SQL> alter database open read only ;
  

SQL> startup immediate ; 
SQL> startup nomount ;
SQL> alter database mount standby database;