Oracle数据库迁移数据的建议方法(ASM到本地硬盘,或者本地硬盘到ASM)(三)
11.2.0.3/dbhome_1/dbs/sde_tbs
outputfile name=+DATA_NMGT/nmggt/datafile/sde_tbs.396.831286619tag=TAG20131112T085659 RECID=1 STAMP=831286620
channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finishedbackup at 12-NOV-13
StartingControl File and SPFILE Autobackup at 12-NOV-13
piecehandle=+RECO_NMGT/nmggt/autobackup/2013_11_12/s_831286620.537.831286621comment=NONE
FinishedControl File and SPFILE Autobackup at 12-NOV-13
RMAN>switch datafile 39 to copy ;
datafile39 switched to datafile copy"+DATA_NMGT/nmggt/datafile/sde_tbs.396.831286619"
RMAN>report schema ;
Reportof database schema for database with db_unique_name NMGGT
Listof Permanent Datafiles
===========================
FileSize(MB) Tablespace RB segsDatafile Name
------------ -------------------- ------- ------------------------
1 16384 SYSTEM *** +DATA_NMGT/nmggt/datafile/system.515.829856217
2 16384 SYSAUX *** +DATA_NMGT/nmggt/datafile/sysaux.514.829856227
3 16384 UNDOTBS1 *** +DATA_NMGT/nmggt/datafile/undotbs1.513.829856235
4 16384 UNDOTBS2 *** +DATA_NMGT/nmggt/datafile/undotbs2.511.829856251
5 1024 USERS *** +DATA_NMGT/nmggt/datafile/users.510.829856259
6 10 NMGT_YS_DHXMGL *** +DATA_NMGT/nmggt/datafile/nmgt_ys_dhxmgl.498.829858495
7 10 NMGT_YS_DZGZCD *** +DATA_NMGT/nmggt/datafile/nmgt_ys_dzgzcd.497.829858495
8 10 NMGT_YS_DZHJJDZGY *** +DATA_NMGT/nmggt/datafile/nmgt_ys_dzhjjdzgy.415.829858495
9 10 NMGT_YS_TKQCR *** +DATA_NMGT/nmggt/datafile/nmgt_ys_tkqcr.414.829858497
10 190 NMGT_YS_NMKZ *** +DATA_NMGT/nmggt/datafile/nmgt_ys_nmkz.463.829858497
11 1000 NMGT_YS_TDZZXM ***
+DATA_NMGT/nmggt/datafile/nmgt_ys_tdzzxm.461.829858497
12 10 NMGT_YS_DZZLHJGL *** +DATA_NMGT/nmggt/datafile/nmgt_ys_dzzlhjgl.460.829858497
13 10 NMGT_YS_KYQJKGL *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kyqjkgl.450.829858497
14 10 NMGT_YS_KYQDA *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kyqda.449.829858497
15 50 NMGT_YS_YQKQXX *** +DATA_NMGT/nmggt/datafile/nmgt_ys_yqkqxx.448.829858499
16 10 NMGT_YS_KYQSDHC *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kyqsdhc.447.829858499
17 10 NMGT_YS_KCZYCLPSBA *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kczyclpsba.446.829858499
18 10600 NMGT_YS_KCZYZTGH *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kczyztgh.445.829858499
19 15 NMGT_YS_JJZXXMJBXX *** +DATA_NMGT/nmggt/datafile/nmgt_ys_jjzxxmjbxx.444.829858499
20 10 NMGT_YS_XZFY *** +DATA_NMGT/nmggt/datafile/nmgt_ys_xzfy.443.829858499
21 50 NMGT_YS_KYQNJ *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kyqnj.442.829858499
22 61 NMGT_YS_KCZYCLDJTJ *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kczycldjtj.441.829858501
23 26 NMGT_YS_KCZYCLKJ *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kczyclkj.440.829858501
24 330 NMGT_YS_KYQSZFA *** +DATA_NMGT/nmggt/datafile/nmgt_ys_kyqszfa.457.829858501
25 204800 NMGT_XAJDBT *** +DATA_NMGT/nmggt/datafile/nmgt_xajdbt.456.829858501
26 4096000 NMGT_BJCQ *** +DATA_NMGT/nmggt/datafile/nmgt_bjcq.424.829858613
27 153600 NMGT_SHSY *** +DATA_NMGT/nmggt/datafile/nmgt_shsy.417.829862455
28 100 NMGT_TLW_GISCONFIG *** +DATA_NMGT/nmggt/datafile/nmgt_tlw_gisconfig.416.829862541
29 409600 NMGT_TLW_NMGYDYS *** +DATA_NMGT/nmggt/datafile/nmgt_tlw_nmgydys.516.829862541
30 51200