11gR1 raw racdb+asm active dataguard搭建遇到了问题

warehouse

貌似向客户吹上牛比了，这种环境下active dg貌似不行：
执行下面命令报错：
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>

warehouse

最后还是通过传统的先备份了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


SQL>

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

STATUS       OPEN_MODE  DATABASE_ROLE
------------ ---------- ----------------
OPEN         READ ONLY  PHYSICAL STANDBY

SQL>

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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

SQL>

在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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

SQL>

在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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
SQL>
在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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

SQL>

在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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

SQL>

在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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

SQL>

在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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

SQL>

在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode

warehouse

直接from active database不成功，最后还是通过先在source db上通过rman做了备份，然后把备份片拷贝到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下数据可以过来。
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

SQL>

在11gR1下只能看到READ ONLY,不能看到11gR2下的：
•READ ONLY WITH APPLY - A physical standby database is open in real-time query mode