aix下11gR1下raw racdb搭建asm active dataguard時要注意

直接透過duplicate target database for standby from active database
是搭建不成功的。

[@more@]

直接透過duplicate target database for standby from active database
錯誤如下：

.......此處省略n行
executing command: SET NEWNAME
Starting backup at 12-OCT-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/dev/rtbs_big1
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/12/2012 20:35:
16
ORA-19504: failed to create file "+DATA/rtbs_big1"
channel ORA_DISK_1 disabled, job failed on it will be run on another channel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/12/2012 20:35:16
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/12/2012 20:35:
16
ORA-19504: failed to create file "+DATA/rtbs_big1"
RMAN>

控制檔案可以restore，standby db也可以mount上，但是在恢復datafile時報錯，找不到原因，感覺和raw device有關，最後還是透過常規辦法：

先備份了db，然後把備份片複製到standby機器上執行：alter database recover managed standby database dorecover成功了。搭建之後dg也是可以active的：
SQL> startup
ORACLE instance started.

Total System Global Area 8551575552 bytes
Fixed Size 2139912 bytes
Variable Size 6308235512 bytes
Database Buffers 2214592512 bytes
Redo Buffers 26607616 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database using current logfile disco
nnect ;

Database altered.

SQL>
SQL>
在open下資料可以過來，dg的這一特性確實不錯。
SQL> select * from t;

ID
----------
1

SQL> select status,open_mode,database_role from v$database,v$instance;

STATUS OPEN_MODE DATABASE_ROLE
------------ ---------- ----------------
OPEN READ ONLY PHYSICAL STANDBY
在11gR1下只能看到read only,不能看到11gR2下的•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode


10g的時侯在standby機器上口令檔案我接的直接建立就可以，11gR1下口令檔案需要幾臺機器都統一，否則日誌不能傳到standby上，在那臺機器做的備份，把這臺機器的口令檔案複製到rac的其它節點上重新命名，同時也要複製到standby機器上，也就是所有的口令檔案只能使用這一個了。