直接通过duplicate target database for standby from active database
是搭建不成功的。
直接通过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机器上,也就是所有的口令文件只能使用这一个了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1059595/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1059595/