oracle 10g rac rman transport tablespace rman-06034
环境 aix oracle 10.2.0.4 rac 两节点,备份在带库中,现在要做表空间迁移,rman语句如下
run{
allocate channel ch00 type 'sbt_type' connect xxxxxx@orcl1;
allocate channel ch02 type 'sbt_type' connect xxxxxx@orcl2;
transport tablespace users
tablespace destination '/arch'
auxiliary destination '/arch'
until time "to_date('2012-10-12 08:00:00','yyyy-mm-dd hh24:mi:ss')";
}
日志:
RMAN> run {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' connect xxxxx@orcl1';
3> ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' connect xxxxxx@orcl2';
4> transport tablespace users
5> tablespace destination '/arch'
6> auxiliary destination '/arch'
7> until time "to_date('2012-10-12 08:00:00','yyyy-mm-dd hh24:mi:ss')";
8> }
allocated channel: ch00
channel ch00: sid=232 instance=orcl1 devtype=SBT_TAPE
run{
allocate channel ch00 type 'sbt_type' connect xxxxxx@orcl1;
allocate channel ch02 type 'sbt_type' connect xxxxxx@orcl2;
transport tablespace users
tablespace destination '/arch'
auxiliary destination '/arch'
until time "to_date('2012-10-12 08:00:00','yyyy-mm-dd hh24:mi:ss')";
}
日志:
RMAN> run {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' connect xxxxx@orcl1';
3> ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' connect xxxxxx@orcl2';
4> transport tablespace users
5> tablespace destination '/arch'
6> auxiliary destination '/arch'
7> until time "to_date('2012-10-12 08:00:00','yyyy-mm-dd hh24:mi:ss')";
8> }
allocated channel: ch00
channel ch00: sid=232 instance=orcl1 devtype=SBT_TAPE
0