oracle 11g数据泵备份恢复.doc

ORACLE 11G数据泵备份恢复文档修改记录修改人修改时间修改内容2012-10-24生成初始报告目录ORACLE 11G数据泵备份恢复11.原库准备工作21.1检查原库字符集21.2 检查源库表空间信息21.3 检查源系统用户及权限31.4 导出前检查及准备31.5 expdp 按用户导出41.6 传输备份数据52.新库导入工作及检查52.1安装数据库软件52.2 DBCA建实例52.3 建立表空间142.4 创建role（不需要创建用户）282.5 导入数据30停止job30同时禁用自动统计分析31完成后启用jobs312.6 检查数据库对象312.7 修改数据库为归档模式322.8 数据库参数修改322.9 修改用户密码322.10 检查对象321. 原库准备工作1.1检查原库字符集查询oracle server端的字符集有很多种方法可以查出oracle server端的字符集，比较直观的查询方法是以下这种:SQL select userenv(language) from dual;USERENV(LANGUAGE)-SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280查询oracle client端的字符集在windows平台下，就是注册表里面相应OracleHome的NLS_LANG。还可以在dos窗口里面自己设置，比如: set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280这样就只影响这个窗口里面的环境变量。如果检查的结果发现server端与client端字符集不一致，请统一修改为同server端相同的字符集。select * from nls_database_parametersLanguage：指定服务器消息的语言，影响提示信息是中文还是英文Territory：指定服务器的日期和数字格式，Charset： 指定字符集。如:AMERICAN _ AMERICA. ZHS16GBK从NLS_LANG的组成我们可以看出，真正影响数据库字符集的其实是第三部分。所以两个数据库之间的字符集只要第三部分一样就可以相互导入导出数据，前面影响的只是提示信息是中文还是英文。1.2 检查源库表空间信息SQL select TABLESPACE_NAME from dba_tablespaces;TABLESPACE_NAME-SYSTEMUNDOTBS1SYSAUXTEMPUSERSDATA_HOST_ADATA_IAS_ADIARYDATA2003DIARYDATA2004DIARYDATA2005DIARYDATA2006LESPACE_NAMEDIARYDATA2008DIARYDATA2007DRSYSFACT2003FACT2004FACT2005FACT2006FACT2007INDX_HOST_AINDX_IAS_ANEWRBS1.3 检查源系统用户及权限create user 用户名 IDENTIFIED BY 密码GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA,CONNECT,RESOURCE,CREATE SESSION TO 用户名字查看用户（不属于system表空间），以及schema下有所表的信息SQL select username,user_id,password from dba_users where DEFAULT_TABLESPACESYSTEM;select count(table_name) from dba_tables where owner=HOST;1.4 导出前检查及准备1.4.1 断session、停job停止应用服务器,检查数据库有无其他session连接set linesize 300col machine format a30select count(*),machine,username from gv$session group by machine,username order by machine;alter system set job_queue_processes=0 scope=both sid=*;确认有无jobs运行select job from dba_jobs_running; alter system set job_queue_processes=150 scope=both sid=*; 此布在导出完成后执行1.4.2 建导出目录创建目录su -oraclemkdir -p /home/data_space/expsqlplus / as sysdbaSQL select count(*) from v$session where username=SETTLE;预期0SQL create or replace directory dmp_dir as /home/data_space/exp;SQL grant read,write on directory dmp_dir to public;1.5 expdp 按用户导出使用直接导出模式 direct=y exp 比传统模式导出快一倍 oracle提供2种模式导出表数据，传统模式CONVENTIONAL PATH和直接模式DIRECT PATH，有direct指定。set nls_lang=AMERICAN_AMERICA.AL32UTF8创建目录su -oraclemkdir -p /home/data_space/expsqlplus / as sysdbaSQL select count(*) from v$session where username=SETTLE;预期0SQL create or replace directory dmp_dir as /home/data_space/exp;SQL grant read,write on directory dmp_dir to public;expdp zhengly/8605683 directory=dmp_dir dumpfile=BAM_MDS_%U.dmp logfile=BAM_MDS.log parallel=10 SCHEMAS=BAM_MDSexpdp zhengly/8605683 directory=dmp_dir dumpfile=BAM_ORABAM_%U.dmp logfile=BAM_ORABAM.log parallel=10 SCHEMAS=BAM_ORABAMexpdp zhengly/8605683 directory=dmp_dir dumpfile=BAM_ORASDPM_%U.dmp logfile=BAM_ORASDPM.log parallel=10 SCHEMAS=BAM_ORASDPMexpdp zhengly/8605683 directory=dmp_dir dumpfile=BAM_SOAINFRA_%U.dmp logfile=BAM_SOAINFRA.log parallel=10 SCHEMAS=BAM_SOAINFRAexpdp zhengly/8605683 directory=dmp_dir dumpfile=EAIUSER_%U.dmp logfile=EAIUSER.log parallel=10 SCHEMAS=EAIUSERexpdp zhengly/8605683 directory=dmp_dir dumpfile=EXPCMI_%U.dmp logfile=EXPCMI.log parallel=10 SCHEMAS=EXPCMIexpdp zhengly/8605683 directory=dmp_dir dumpfile=EXPEDW_%U.dmp logfile=EXPEDW.log parallel=10 SCHEMAS=EXPEDWexpdp zhengly/8605683 directory=dmp_dir dumpfile=EXPESTORE_%U.dmp logfile=EXPESTORE.log parallel=10 SCHEMAS=EXPESTOREexpdp zhengly/8605683 directory=dmp_dir dumpfile=EXPHCSP_%U.dmp logfile=EXPHCSP.log parallel=10 SCHEMAS=EXPHCSPexpdp zhengly/8605683 directory=dmp_dir dumpfile=EXPLED_%U.dmp logfile=EXPLED.log parallel=10 SCHEMAS=EXPLEDexpdp zhengly/8605683 directory=dmp_dir dumpfile=GUESTCP_%U.dmp logfile=GUESTCP.log parallel=10 SCHEMAS=GUESTCPexpdp zhengly/8605683 directory=dmp_dir dumpfile=GUESTCST_%U.dmp logfile=GUESTCST.log parallel=10 SCHEMAS=GUESTCSTexpdp zhengly/8605683 directory=dmp_dir dumpfile=HP_DBSPI_%U.dmp logfile=HP_DBSPI.log parallel=10 SCHEMAS=HP_DBSPIexpdp zhengly/8605683 directory=dmp_dir dumpfile=LDAPUSER_%U.dmp logfile=LDAPUSER.log parallel=10 SCHEMAS=LDAPUSERexpdp zhengly/8605683 directory=dmp_dir dumpfile=MGMT_VIEW_%U.dmp logfile=MGMT_VIEW.log parallel=10 SCHEMAS=MGMT_VIEWexpdp zhengly/8605683 directory=dmp_dir dumpfile=SADMIN_%U.dmp logfile=SADMIN.log parallel=10 SCHEMAS=SADMINexpdp zhengly/8605683 directory=dmp_dir dumpfile=SIEBEL_%U.dmp logfile=SIEBEL.log parallel=10 SCHEMAS=SIEBELexpdp zhengly/8605683 directory=dmp_dir dumpfile=SSA_%U.dmp logfile=SSA.log parallel=10 SCHEMAS=SSAexpdp zhengly/8605683 directory=dmp_dir dumpfile=UCMDIC_%U.dmp logfile=UCMDIC.log parallel=10 SCHEMAS=UCMDICexpdp zhengly/8605683 directory=dmp_dir dumpfile=UCMDSP_%U.dmp logfile=UCMDSP.log parallel=10 SCHEMAS=UCMDSPexpdp zhengly/8605683 directory=dmp_dir dumpfile=UCMEXT_%U.dmp logfile=UCMEXT.log parallel=10 SCHEMAS=UCMEXTexpdp zhengly/8605683 directory=dmp_dir dumpfile=UCMTRS_%U.dmp logfile=UCMTRS.log parallel=10 SCHEMAS=UCMTRS一般情况要把exp时的字符集设成目标数据库的字符集。然后imp 到目标数据库1.6 传输备份数据拷贝数据到目标系统导入前，挂载nfs文件系统mount 10.135.29.131:/export/Data_SPACE/SPACE /home/data_space2. 新库导入工作及检查2.1安装数据库软件安装11g软件2.2 DBCA建实例dbca 注意选择与源库相应的字符集SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280select * from nls_database_parameters 查看字符集select userenv(language) from dual;数据文件目录指定为/oracle/product/11.2.0/ucm/datafile统一密码oracle2.3 建立表空间 根据源库应用表空间名称及大小，规划11g表空间、生成创建表空间脚本：CREATE TABLESPACE AUDTBS DATAFILE /oracle/product/11.2.0/ucm/datafile/audtbs01.dbf SIZE 8192M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/audtbs.1643.768389863 SIZE 2048M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE DATA01 DATAFILE /oracle/product/11.2.0/ucm/datafile/data01.521.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.511.761332089 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.510.761332089 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.523.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.517.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.529.761332093 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.527.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.518.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.560.761332787 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.565.761332827 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.593.761333161 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.589.761333117 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.587.761333097 SIZE 3512M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.577.761332947 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.566.761332849 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.567.761332865 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.596.761333187 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.597.761333191 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.591.761333143 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.578.761332967 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.568.761332865 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.576.761332947 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.600.761333225 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.598.761333193 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.595.761333177 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.579.761332971 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.594.761333173 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.590.761333141 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.604.761333245 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.603.761333237 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.606.761333313 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.584.761333031 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.599.761333223 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.605.761333311 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.608.761333335 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.610.761333371 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.612.761333387 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.585.761333071 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.602.761333229 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.607.761333325 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.614.761333409 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.611.761333385 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.620.761333545 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.601.761333227 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.609.761333341 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.613.761333391 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.621.761333547 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.616.761333455 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.628.761333689 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.622.761333583 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.618.761333503 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.615.761333409 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.1644.768389939 SIZE 2512M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.1645.768389951 SIZE 2512M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.1646.768389963 SIZE 2512M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data01.1647.768390007 SIZE 2512M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE DATA02 DATAFILE /oracle/product/11.2.0/ucm/datafile/data02.516.761332089 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.528.761332093 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.525.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.530.761332093 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.539.761332431 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.524.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.522.761332091 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.532.761332133 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.629.761333711 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.617.761333487 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.637.761333885 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.630.761333723 SIZE 4096M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data02.623.761333589 SIZE 4096M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE DATA03 DATAFILE /oracle/product/11.2.0/ucm/datafile/data03.531.761332129 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.552.761332689 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.548.761332595 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.534.761332273 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.533.761332153 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.551.761332647 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.538.761332345 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.556.761332723 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.625.761333655 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.646.761333947 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.642.761333929 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.641.761333921 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.631.761333743 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.624.761333623 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.626.761333685 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.650.761333963 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.644.761333939 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.645.761333943 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.634.761333787 SIZE 1024M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data03.627.761333685 SIZE 1024M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE DATA04 DATAFILE /oracle/product/11.2.0/ucm/datafile/data04.486.761332077 SIZE 2800M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data04.485.761332077 SIZE 2800M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data04.488.761332079 SIZE 2800M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data04.487.761332077 SIZE 2800M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data04.490.761332081 SIZE 2800M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data04.489.761332081 SIZE 2800M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data04.493.761332081 SIZE 2800M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/data04.492.761332081 SIZE 2800M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE EAIBAM_IAS_ORASDPM DATAFILE /oracle/product/11.2.0/ucm/datafile/eaibam_ias_orasdpm.1742.771779567 SIZE 128M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TEMPORARY TABLESPACE EAIBAM_IAS_TEMP TEMPFILE /oracle/product/11.2.0/ucm/datafile/eaibam_ias_temp.1743.771779623 SIZE 8192M AUTOEXTEND OFFTABLESPACE GROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;CREATE TABLESPACE EAIBAM_MDS DATAFILE /oracle/product/11.2.0/ucm/datafile/eaibam_mds.1739.771779417 SIZE 1024M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE EAIBAM_ORABAM DATAFILE /oracle/product/11.2.0/ucm/datafile/eaibam_orabam.1741.771779539 SIZE 512M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE EAIBAM_SOAINFRA DATAFILE /oracle/product/11.2.0/ucm/datafile/eaibam_soainfra.1740.771779463 SIZE 1024M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE TABLESPACE EAILOG DATAFILE /oracle/product/11.2.0/ucm/datafile/eailog.586.789427207 SIZE 30720M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog.278.793494025 SIZE 22000M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog.284.793754507 SIZE 20000M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog.1541.794913745 SIZE 12000M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog.1567.794931791 SIZE 8192M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog.360.794970121 SIZE 5120M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog7 SIZE 30720M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog6 SIZE 30000M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog5 SIZE 30720M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog4 SIZE 30720M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog3 SIZE 30720M AUTOEXTEND OFF, /oracle/product/11.2.0/ucm/datafile/eailog2 SIZE 30720