实战:Oracle10.2.0.4异机迁移并升级到Oracle 11.2.0.4(四)

2015-01-21 12:18:09 · 作者: · 浏览: 31
#####备份源库:
[oracle@ora1 bak]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Dec 12 16:09:47 2014

Copyright (c) 1982, 2007, Oracle.? All rights reserved.

connected to target database: ORCL (DBID=1393903281)

RMAN> backup full database format '/home/oracle/bak/full_orcl_%U';

Starting backup at 12-DEC-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=146 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/home/oracle/oradata/orcl/system02.dbf
input datafile fno=00008 name=/home/oracle/oradata/orcl/sysaux02.dbf
input datafile fno=00001 name=/home/oracle/oradata/orcl/system01.dbf
input datafile fno=00007 name=/home/oracle/oradata/orcl/undotbs02.dbf
input datafile fno=00003 name=/home/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/home/oracle/oradata/orcl/example01.dbf
input datafile fno=00009 name=/home/oracle/oradata/orcl/ex.dbf
input datafile fno=00002 name=/home/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 12-DEC-14
channel ORA_DISK_1: finished piece 1 at 12-DEC-14
piece handle=/home/oracle/bak/full_orcl_01pq07r8_1_1 tag=TAG20141212T161015 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:47
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 12-DEC-14
channel ORA_DISK_1: finished piece 1 at 12-DEC-14
piece handle=/home/oracle/bak/full_orcl_02pq07sn_1_1 tag=TAG20141212T161015 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 12-DEC-14

RMAN> exit


Recovery Manager complete.

[oracle@ora1 ~]$ rman target /



Recovery Manager: Release 10.2.0.4.0 - Production on Fri Dec 12 17:25:22 2014

Copyright (c) 1982, 2007, Oracle.? All rights reserved.


connected to target database: ORCL (DBID=1393903281)

RMAN>
RMAN>
RMAN>
RMAN>? list backup of database;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key? Type LV Size? ? ? Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1? ? ? Full? ? 593.46M? ? DISK? ? ? ? 00:00:38? ? 12-DEC-14? ? ?
? ? ? ? BP Key: 1? Status: AVAILABLE? Compressed: NO? Tag: TAG20141212T161015
? ? ? ? Piece Name: /home/oracle/bak/full_orcl_01pq07r8_1_1
? List of Datafiles in backup set 1
? File LV Type Ckp SCN? ? Ckp Time? Name
? ---- -- ---- ---------- --------- ----
? 1? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/system01.dbf
? 2? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/undotbs01.dbf
? 3? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/sysaux01.dbf
? 4? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/users01.dbf
? 5? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/example01.dbf
? 6? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/system02.dbf
? 7? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/undotbs02.dbf
? 8? ? ? Full 645792? ? 12-DEC-14 /home/oracle/oradata/orcl/sysaux02.dbf
? 9? ? ? Full 645792? ? 12-DEC-14 /home/