Oracle RAC Standby 恢復歸檔numuber錯亂

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;