Database Backup and Recovery (MOSC)

MOSC Banner

oracle 10g rac rman transport tablespace rman-06034

edited Oct 17, 2012 4:51AM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓
环境 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center