之前做了11gr2 fs to fs ,asm to asm 的dataguard 均成功，但在做11gr1 fs to asm 的 dataguard 时报错：
过程脚本摘录如下：
[oracle@dg1 ~]$ rman
Recovery Manager: Release 11.1.0.6.0 - Production on Sat Oct 27 03:37:45 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target sys/oracle@orcl_pd
connected to target database: ORCL (DBID=1325457331)
RMAN> connect target sys/oracle@orcl_st
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06167: already connected
RMAN> connect auxiliary sys/oracle@orcl_st
connected to auxiliary database: ORCL (not mounted)
RMAN> run
2> {
3> allocate channel prmy1 type disk;
4> allocate channel prmy2 type disk;
5> allocate channel prmy3 type disk;
6> allocate channel prmy4 type disk;
7> allocate channel prmy5 type disk;
8> allocate auxiliary channel stby1 type disk;
9> duplicate target database for standby from active database
10> spfile
11> parameter_value_convert 'orcl_pd','orcl_st'
12> set 'db_unique_name'='orcl_st'
13> set control_files='+DATA/orcl_st/control.ctl'
14> set db_create_file_dest='+DATA'
15> set db_create_online_log_dest_1='+FLASH'
16> set db_create_online_log_dest_2='+DATA'
17> set db_recovery_file_dest='+FLASH'
18> set db_recovery_file_dest_size='3G'
19> set log_archive_max_processes='5'
20> set fal_client='orcl_st'
21> set fal_server='orcl_pd'
22> set db_file_name_convert='/u01/app/oracle/oradata/orcl/','+DATA/orcl_st/'
23> set log_file_name_convert='/u01/app/oracle/oradata/orcl/','+DATA/orcl_st/','/u01/app/oracle/oradata/orcl/','+FLASH/orcl_st/'
24> set standby_file_management='AUTO'
25> set log_archive_config='dg_config=(orcl_pd,orcl_st)'
26> set log_archive_dest_2='service=orcl_pd lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl_pd';
27> sql channel prmy1 "alter system set log_archive_config=''dg_config=(orcl_pd,orcl_st)''";
28> sql channel prmy1 "alter system set log_archive_dest_2=''service=orcl_st lgwr async valid_for=(online_logfiles,primary_role)
29>
30> db_unique_name=orcl_st''";
31> sql channel prmy1 "alter system set log_archive_max_processes=5";
32> sql channel prmy1 "alter system set fal_client=orcl_pd";
33> sql channel prmy1 "alter system set fal_server=orcl_st";
34> sql channel prmy1 "alter system set db_unique_name=orcl_pd";
35> sql channel prmy1 "alter system set db_file_name_convert='+DATA/orcl_st/','/u01/app/oracle/oradata/orcl/'";
36> sql channel prmy1 "alter system set
37>
38> log_file_name_convert='+DATA/orcl_st/','/u01/app/oracle/oradata/orcl/','+FLASH/orcl_st/','/u01/app/oracle/oradata/orcl/'";
39> sql channel prmy1 "alter system set standby_file_management=AUTO";
40> sql channel prmy1 "alter system archive log current";
41> allocate auxiliary channel stby type disk;
42> sql channel stby "alter database recover managed standby database using current logfile disconnect";}
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=112 device type=DISK
allocated channel: prmy2
channel prmy2: SID=127 device type=DISK
allocated channel: prmy3
channel prmy3: SID=118 device type=DISK
allocated channel: prmy4
channel prmy4: SID=122 device type=DISK
allocated channel: prmy5
channel prmy5: SID=120 device type=DISK
allocated channel: stby1
channel stby1: SID=97 device type=DISK
Starting Duplicate Db at 27-OCT-12
contents of Memory Script:
{
backup as copy reuse
file '/u01/app/oracle/product/11.1.0//dbs/orapworcl' auxiliary format
'/u01/app/oracle/product/11.1.0/dbs/orapworcl' file
'/u01/app/oracle/product/11.1.0/dbs/spfileorcl.ora' auxiliary format
'/u01/app/oracle/product/11.1.0/dbs/spfileorcl.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.1.0/dbs/spfileorcl.ora''";
}
executing Memory Script
Starting backup at 27-OCT-12
Finished backup at 27-OCT-12
sql statement: alter system set spfile= ''/u01/app/oracle/product/11.1.0/dbs/spfileorcl.ora''
contents of Memory Script:
{
sql clone "alter system set db_unique_name =
''orcl_st'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''+DATA/orcl_st/control.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set db_create_file_dest =
''+DATA'' comment=
'''' scope=spfile";
sql clone "alter system set db_create_online_log_dest_1 =
''+FLASH'' comment=
'''' scope=spfile";
sql clone "alter system set db_create_online_log_dest_2 =
''+DATA'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest =
''+FLASH'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest_size =
3G comment=
'''' scope=spfile";
sql clone "alter system set log_archive_max_processes =
5 comment=
'''' scope=spfile";
sql clone "alter system set fal_client =
''orcl_st'' comment=
'''' scope=spfile";
sql clone "alter system set fal_server =
''orcl_pd'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''/u01/app/oracle/oradata/orcl/'', ''+DATA/orcl_st/'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''/u01/app/oracle/oradata/orcl/'', ''+DATA/orcl_st/'', ''/u01/app/oracle/oradata/orcl/'', ''+FLASH/orcl_st/'' comment=
'''' scope=spfile";
sql clone "alter system set standby_file_management =
''AUTO'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_config =
''dg_config=(orcl_pd,orcl_st)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_2 =
''service=orcl_pd lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl_pd'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script
sql statement: alter system set db_unique_name = ''orcl_st'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''+DATA/orcl_st/control.ctl'' comment= '''' scope=spfile
sql statement: alter system set db_create_file_dest = ''+DATA'' comment= '''' scope=spfile
sql statement: alter system set db_create_online_log_dest_1 = ''+FLASH'' comment= '''' scope=spfile
sql statement: alter system set db_create_online_log_dest_2 = ''+DATA'' comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest = ''+FLASH'' comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest_size = 3G comment= '''' scope=spfile
sql statement: alter system set log_archive_max_processes = 5 comment= '''' scope=spfile
sql statement: alter system set fal_client = ''orcl_st'' comment= '''' scope=spfile
sql statement: alter system set fal_server = ''orcl_pd'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''/u01/app/oracle/oradata/orcl/'', ''+DATA/orcl_st/'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''/u01/app/oracle/oradata/orcl/'', ''+DATA/orcl_st/'', ''/u01/app/oracle/oradata/orcl/'', ''+FLASH/orcl_st/'' comment= '''' scope=spfile
sql statement: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile
sql statement: alter system set log_archive_config = ''dg_config=(orcl_pd,orcl_st)'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_2 = ''service=orcl_pd lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl_pd'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 839282688 bytes
Fixed Size 2149040 bytes
Variable Size 490734928 bytes
Database Buffers 339738624 bytes
Redo Buffers 6660096 bytes
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '+DATA/orcl_st/control.ctl';
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting backup at 27-OCT-12
channel prmy1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.1.0/dbs/snapcf_orcl.f tag=TAG20121027T033933 RECID=4 STAMP=797744380
channel prmy1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 27-OCT-12
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"+DATA/orcl_st/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"+DATA/orcl_st/system01.dbf";
set newname for datafile 2 to
"+DATA/orcl_st/sysaux01.dbf";
set newname for datafile 3 to
"+DATA/orcl_st/undotbs01.dbf";
set newname for datafile 4 to
"+DATA/orcl_st/users01.dbf";
set newname for datafile 5 to
"+DATA/orcl_st/example01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"+DATA/orcl_st/system01.dbf" datafile
2 auxiliary format
"+DATA/orcl_st/sysaux01.dbf" datafile
3 auxiliary format
"+DATA/orcl_st/undotbs01.dbf" datafile
4 auxiliary format
"+DATA/orcl_st/users01.dbf" datafile
5 auxiliary format
"+DATA/orcl_st/example01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +DATA/orcl_st/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 27-OCT-12
channel prmy1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
channel prmy2: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
channel prmy3: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
channel prmy4: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
channel prmy5: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
RMAN-03009: failure of backup command on prmy1 channel at 10/27/2012 03:40:19
ORA-19504: failed to create file "+DATA/orcl_st/system01.dbf"
channel prmy1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on prmy2 channel at 10/27/2012 03:40:19
ORA-19504: failed to create file "+DATA/orcl_st/sysaux01.dbf"
channel prmy2 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on prmy3 channel at 10/27/2012 03:40:19
ORA-19504: failed to create file "+DATA/orcl_st/example01.dbf"
channel prmy3 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on prmy4 channel at 10/27/2012 03:40:19
ORA-19504: failed to create file "+DATA/orcl_st/undotbs01.dbf"
channel prmy4 disabled, job failed on it will be run on another channel
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: prmy5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/27/2012 03:40:32
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy5 channel at 10/27/2012 03:40:29
ORA-19504: failed to create file "+DATA/orcl_st/users01.dbf"
RMAN>
http://www.itpub.net/thread-1729010-1-1.html 这个帖子也是同样问题，解决方法是用10G 搭建dg 的方法。
有没有解决过这个问题的朋友 ？ 望指教。
|
|
京ICP备12024223-8号
不良信息举报电话：13718043309
转播
分享
淘帖