Oracle DUPLICATE复制数据库(四)
dba
SQL>STARTUP www.2cto.com
连接目标数据库是否存在可用备份：
C:\>rman target sys/lyn@orcl catalog rman/rman@catalog
Recovery Manager: Release 10.2.0.3.0 - Production on Thu Aug 9 11:37:04 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1304585157)
connected to recovery catalog database
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
457 Full 185.74M DISK 00:00:55 11-JUN-12
BP Key: 461 Status: AVAILABLE Compressed: YES Tag: TAG20120611T13464
3
Piece Name: F:\BACKUP_3GND96A4_1_1
List of Datafiles in backup set 457
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF www.2cto.com
2 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS2.DBF
3 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
4 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
5 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
6 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORADATA1.DBF
7 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORADATA2.DBF
8 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM02.DBF
9 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\MYIDX01.DBF
10 Full 5145206 11-JUN-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF www.2cto.com
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
959 Full 1.07G DISK 00:01:18 02-AUG-12
BP Key: 975 Status: AVAILABLE Compressed: NO Tag: TAG20120802T151438
Piece Name: F:\BACKUP_3NNHL3AV_1_1
List of Datafiles in backup set 959
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 8716227 02-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
961 Full 96.00K DISK 00:00:00 02-AUG-12
BP Key: 976 Status: AVAILABLE Compressed: NO Tag: TAG20120802T151734
Piece Name: F:\BACKUP_3PNHL3GE_1_1
List of Datafiles in backup set 961
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
13 Full 8716370 02-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORADATA3.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1323 Full 3.10G DISK 00:06:50 08-AUG-12
BP Key: 1327 Status: AVAILABLE Compressed: NO Tag: TAG20120808T12132
3
Piece Name: F:\BACKUP_4BNI4IV3_1_1
List of Datafiles in backup set 1323
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
2 Ful