單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4)

1. 複製結束後的Standby只啟動到mount standby的狀態。並沒有啟動MRP的應用歸檔程式。 所以這個時候查詢主備庫，歸檔是不同步的。需要手動的啟動MRP程式。

SQL> alter database recover managed standby database disconnect from session;

2. 備庫Online Redo Log問題

由於RMAN duplicate命令不會在從Primary資料庫複製檔案時複製Online Redologs，因此物理Standby資料庫在第一次啟動REDO應用時，會在Alert檔案中報Online Redo Logfile檔案不存在，沒有關係，物理Standby會自動重建這批檔案，同時也不用擔心會丟失資料，Online Redologs中的資料會以歸檔檔案的形式從Primary端接收。

alert_stby.log:

Fri Jul  1 15:43:47 2011

alter database recover managed standby database disconnect from session

Fri Jul  1 15:43:47 2011

Attempt to start background Managed Standby Recovery process (stby)

MRP0 started with pid=16, OS id=30427

Fri Jul  1 15:43:47 2011

MRP0: Background Managed Standby Recovery process started (stby)

Managed Standby Recovery not using Real Time Apply

 parallel recovery started with 3 processes

Fri Jul  1 15:43:52 2011

Waiting for all non-current ORLs to be archived...

Fri Jul  1 15:43:52 2011

Errors in file …/bdump/stby_mrp0_30427.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '…/stby/redo01.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 1 …/stby/redo01.log

Clearing online log 1 of thread 1 sequence number 37

Fri Jul  1 15:43:55 2011

Clearing online redo logfile 1 complete

Fri Jul  1 15:43:55 2011

Errors in file …/bdump/stby_mrp0_30427.trc:

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: '…/stby/redo02.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 2 …/stby/redo02.log

Clearing online log 2 of thread 1 sequence number 38

Clearing online redo logfile 2 complete

Fri Jul  1 15:43:58 2011

Errors in file …/bdump/stby_mrp0_30427.trc:

ORA-00313: open failed for members of log group 3 of thread 1

ORA-00312: online log 3 thread 1: '…/stby/redo03.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 3 …/stby/redo03.log

Clearing online log 3 of thread 1 sequence number 39

Clearing online redo logfile 3 complete