linux启动数据库orl,rman将linux平台数据库迁移到window平台数据库

RMAN> run{

2> allocate channel c1 type disk;

3> allocate channel c2 type disk;

4> set newname for datafile 1 to 'D:apporadataorclsystem01.dbf';

5> set newname for datafile 2 to 'D:apporadataorclsysaux01.dbf';

6> set newname for datafile 3 to 'D:apporadataorclundotbs01.dbf';

7> set newname for datafile 4 to 'D:apporadataorclusers01.dbf';

8> set newname for datafile 5 to 'D:apporadataorclhissaas_data01.dbf';

9> set newname for datafile 6 to 'D:apporadataorclhissaas_data02.dbf';

10> set newname for datafile 7 to 'D:apporadataorclsaas_data01.dbf';

11> restore database;

12> switch datafile all;

13> release channel c1;

14> release channel c2;

15> }

allocated channel: c1

channel c1: SID=192 device type=DISK

allocated channel: c2

channel c2: SID=5 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 05-1月 -13

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00001 to D:apporadataorclsystem01.dbf

channel c1: restoring datafile 00002 to D:apporadataorclsysaux01.dbf

channel c1: restoring datafile 00003 to D:apporadataorclundotbs01.dbf

channel c1: restoring datafile 00004 to D:apporadataorclusers01.dbf

channel c1: restoring datafile 00005 to D:apporadataorclhissaas_data01.dbf

channel c1: restoring datafile 00006 to D:apporadataorclhissaas_data02.dbf

channel c1: restoring datafile 00007 to D:apporadataorclsaas_data01.dbf

channel c1: reading from backup piece /rmanbackup/201212302unu6mab_1_1

channel c1: errors found reading piece handle=/rmanbackup/201212302unu6mab_1_1

channel c1: failover to piece handle=D:201212302UNU6MAB_1_1 tag=TAG20121230T223803

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:09:56

Finished restore at 05-1月 -13

datafile 1 switched to datafile copy

input datafile copy RECID=8 STAMP=803908655 file name=D:APPORADATAORCLSYSTEM01.DBF

datafile 2 switched to datafile copy

input datafile copy RECID=9 STAMP=803908656 file name=D:APPORADATAORCLSYSAUX01.DBF

datafile 3 switched to datafile copy

input datafile copy RECID=10 STAMP=803908656 file name=D:APPORADATAORCLUNDOTBS01.DBF

datafile 4 switched to datafile copy

input datafile copy RECID=11 STAMP=803908656 file name=D:APPORADATAORCLUSERS01.DBF

datafile 5 switched to datafile copy

input datafile copy RECID=12 STAMP=803908657 file name=D:APPORADATAORCLHISSAAS_DATA01.DBF

datafile 6 switched to datafile copy

input datafile copy RECID=13 STAMP=803908657 file name=D:APPORADATAORCLHISSAAS_DATA02.DBF

datafile 7 switched to datafile copy

input datafile copy RECID=14 STAMP=803908658 file name=D:APPORADATAORCLSAAS_DATA01.DBF

released channel: c1

released channel: c2