Oracle数据库迁移数据的建议方法（ASM到本地硬盘，或者本地硬盘到ASM）(四)
0 NMGT_TLW_NMGYDBP *** +DATA_NMGT/nmggt/datafile/nmgt_tlw_nmgydbp.517.829862783
31 512000 NMGT_TLW_NMGKYQ *** +DATA_NMGT/nmggt/datafile/nmgt_tlw_nmgkyq.518.829863117
32 512000 NMGT_TLW_NMGOTHER *** +DATA_NMGT/nmggt/datafile/nmgt_tlw_nmgother.519.829863461
33 200 nmgt_tlw_nmgtt *** +DATA_NMGT/nmggt/datafile/nmgt_tlw_nmgtt.520.829863819
34 5120 NMGT *** +DATA_NMGT/nmggt/datafile/nmgt.521.829863821
35 5120 NMGT *** +DATA_NMGT/nmggt/datafile/nmgt.522.829863823
36 5120 NMGTHD *** +DATA_NMGT/nmggt/datafile/nmgthd.523.829863827
37 5120 NMGTHD *** +DATA_NMGT/nmggt/datafile/nmgthd.524.829863829
38 400 SDE *** +DATA_NMGT/nmggt/datafile/sde.525.829863831
39 0 SDE_TBS *** +DATA_NMGT/nmggt/datafile/sde_tbs.396.831286619
40 25 NMGT_YS_DATAMANAGER *** +DATA_NMGT/nmggt/datafile/nmgt_ys_datamanager.526.829905653
41 100 DLGIS_DRTBS *** +DATA_NMGT/nmggt/datafile/dlgis_drtbs.550.831117765
42 100 NMGWEB_DRTBS *** +DATA_NMGT/nmggt/datafile/nmgweb_drtbs.551.831117829
43 1124 NMGKYQ_DRTBS *** +DATA_NMGT/nmggt/datafile/nmgkyq_drtbs.552.831117829
44 1124 TLWELARP_DRTBS *** +DATA_NMGT/nmggt/datafile/tlwelarp_drtbs.553.831117829
45 2148 ELARPBAK_DRTBS *** +DATA_NMGT/nmggt/datafile/elarpbak_drtbs.554.831117829
46 100 DLINIT_DRTBS *** +DATA_NMGT/nmggt/datafile/dlinit_drtbs.555.831117829
47 1124 DLMIS_DRTBS *** +DATA_NMGT/nmggt/datafile/dlmis_drtbs.556.831117831
48 1124 DLSYS_DRTBS *** +DATA_NMGT/nmggt/datafile/dlsys_drtbs.557.831117831
49 100 EC_DRTBS *** +DATA_NMGT/nmggt/datafile/ec_drtbs.558.831117831
50 100 UNIFLOW_DEMO_DRTBS *** +DATA_NMGT/nmggt/datafile/uniflow_demo_drtbs.559.831117831
51 100 U2_DRM_DRTBS *** +DATA_NMGT/nmggt/datafile/u2_drm_drtbs.560.831117831
52 100 U2_DRTBS *** +DATA_NMGT/nmggt/datafile/u2_drtbs.561.831117831
53 100 FORM_DRTBS *** +DATA_NMGT/nmggt/datafile/form_drtbs.562.831117833
54 100 NEWUNISSO_DRTBS *** +DATA_NMGT/nmggt/datafile/newunisso_drtbs.563.831117833
55 1409024 SEAS_DRTBS *** +DATA_NMGT/nmggt/datafile/seas_drtbs.564.831117835
56 6244 NEUDOC_DRTBS *** +DATA_NMGT/nmggt/datafile/neudoc_drtbs.565.831117841
57 3172 UNIEAP_DRTBS *** +DATA_NMGT/nmggt/datafile/unieap_drtbs.566.831117841
58 4196 ELARP_DRTBS *** +DATA_NMGT/nmggt/datafile/elarp_drtbs.567.831117841
59 100 NMGADMIN_GTTBS *** +DATA_NMGT/nmggt/datafile/nmgadmin_gttbs.568.831119363
60 100 GTDZ_GTTBS *** +DATA_NMGT/nmggt/datafile/gtdz_gttbs.569.831119363
61 100 GTKZ_GTTBS *** +DATA_NMGT/nmggt/datafile/gtkz_gttbs.570.831119365
62 100 SDE_GTTBS *** +DATA_NMGT/nmggt/datafile/sde_gttbs.571.831119365
63 100 EGOV_GIS_GTTBS *** +DATA_NMGT/nmggt/datafile/egov_gis_gttbs.572.831119365
64 5120 DBFS_YS *** +DBFS_DG/nmggt/datafile/dbfs_ys.256.831124155
65 1024 DBFS_CQ *** +DBFS_DG/nmggt/datafile/dbfs_cq.257.831124157
66 1024 SDE_TBS2 *** +DATA_NMGT/nmggt/datafile/sde_tbs2.397.831235049
Listof Temporary Files
=======================
FileSize(MB) Tablespace Maxsize(MB)Tempfile Name
------------ -------------------- ----------- --------------------
1 32767 TEMP 32767 +DATA_NMGT/nmggt/tempfile/temp.512.829856243
RMAN>
sql 'alter tablespace sde_tbs online' ;
sqlstatement: alter tablespace sde_tbs online