ORACLE 11G 数据泵备份恢复

bsgao 贡献于2014-08-07

作者 00011904  创建于2011-11-24 16:22:00   修改者User  修改于2012-11-08 14:31:00字数45285

文档摘要:ORACLE 11G 数据泵备份恢复
关键词:

ORACLE 11G数据泵备份恢复 文档修改记录 修改人 修改时间 修改内容 2012-10-24 生成初始报告 目录 ORACLE 11G数据泵备份恢复 1 1. 原库准备工作 2 1.1检查原库字符集 2 1.2 检查源库表空间信息 2 1.3 检查源系统用户及权限 3 1.4 导出前检查及准备 3 1.5 expdp 按用户导出 4 1.6 传输备份数据 5 2. 新库导入工作及检查 5 2.1安装数据库软件 5 2.2 DBCA建实例 5 2.3 建立表空间 14 2.4 创建role(不需要创建用户) 28 2.5 导入数据 30 停止job 30 同时禁用自动统计分析 31 完成后启用jobs 31 2.6 检查数据库对象 31 2.7 修改数据库为归档模式 32 2.8 数据库参数修改 32 2.9 修改用户密码 32 2.10 检查对象 32 1. 原库准备工作 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_parameters Language:指定服务器消息的语言,影响提示信息是中文还是英文 Territory:指定服务器的日期和数字格式, Charset: 指定字符集。 如:AMERICAN _ AMERICA. ZHS16GBK 从NLS_LANG的组成我们可以看出,真正影响数据库字符集的其实是第三部分。 所以两个数据库之间的字符集只要第三部分一样就可以相互导入导出数据,前面影响的只是提示信息是中文还是英文。 1.2 检查源库表空间信息 SQL> select TABLESPACE_NAME from dba_tablespaces; TABLESPACE_NAME ------------------------------------------------------------ SYSTEM UNDOTBS1 SYSAUX TEMP USERS DATA_HOST_A DATA_IAS_A DIARYDATA2003 DIARYDATA2004 DIARYDATA2005 DIARYDATA2006 LESPACE_NAME DIARYDATA2008 DIARYDATA2007 DRSYS FACT2003 FACT2004 FACT2005 FACT2006 FACT2007 INDX_HOST_A INDX_IAS_A NEWRBS 1.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_TABLESPACE<>'SYSTEM'; select count(table_name) from dba_tables where owner='HOST'; 1.4 导出前检查及准备 1.4.1 断session、停job 停止应用服务器,检查数据库有无其他session连接 set linesize 300 col machine format a30 select 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 -oracle mkdir -p /home/data_space/exp sqlplus / as sysdba SQL> select count(*) from v$session where username='SETTLE'; 预期0 SQL> 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 -oracle mkdir -p /home/data_space/exp sqlplus / as sysdba SQL> select count(*) from v$session where username='SETTLE'; 预期0 SQL> 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_MDS expdp zhengly/8605683 directory=dmp_dir dumpfile=BAM_ORABAM_%U.dmp logfile=BAM_ORABAM.log parallel=10 SCHEMAS=BAM_ORABAM expdp zhengly/8605683 directory=dmp_dir dumpfile=BAM_ORASDPM_%U.dmp logfile=BAM_ORASDPM.log parallel=10 SCHEMAS=BAM_ORASDPM expdp zhengly/8605683 directory=dmp_dir dumpfile=BAM_SOAINFRA_%U.dmp logfile=BAM_SOAINFRA.log parallel=10 SCHEMAS=BAM_SOAINFRA expdp zhengly/8605683 directory=dmp_dir dumpfile=EAIUSER_%U.dmp logfile=EAIUSER.log parallel=10 SCHEMAS=EAIUSER expdp zhengly/8605683 directory=dmp_dir dumpfile=EXPCMI_%U.dmp logfile=EXPCMI.log parallel=10 SCHEMAS=EXPCMI expdp zhengly/8605683 directory=dmp_dir dumpfile=EXPEDW_%U.dmp logfile=EXPEDW.log parallel=10 SCHEMAS=EXPEDW expdp zhengly/8605683 directory=dmp_dir dumpfile=EXPESTORE_%U.dmp logfile=EXPESTORE.log parallel=10 SCHEMAS=EXPESTORE expdp zhengly/8605683 directory=dmp_dir dumpfile=EXPHCSP_%U.dmp logfile=EXPHCSP.log parallel=10 SCHEMAS=EXPHCSP expdp zhengly/8605683 directory=dmp_dir dumpfile=EXPLED_%U.dmp logfile=EXPLED.log parallel=10 SCHEMAS=EXPLED expdp zhengly/8605683 directory=dmp_dir dumpfile=GUESTCP_%U.dmp logfile=GUESTCP.log parallel=10 SCHEMAS=GUESTCP expdp zhengly/8605683 directory=dmp_dir dumpfile=GUESTCST_%U.dmp logfile=GUESTCST.log parallel=10 SCHEMAS=GUESTCST expdp zhengly/8605683 directory=dmp_dir dumpfile=HP_DBSPI_%U.dmp logfile=HP_DBSPI.log parallel=10 SCHEMAS=HP_DBSPI expdp zhengly/8605683 directory=dmp_dir dumpfile=LDAPUSER_%U.dmp logfile=LDAPUSER.log parallel=10 SCHEMAS=LDAPUSER expdp zhengly/8605683 directory=dmp_dir dumpfile=MGMT_VIEW_%U.dmp logfile=MGMT_VIEW.log parallel=10 SCHEMAS=MGMT_VIEW expdp zhengly/8605683 directory=dmp_dir dumpfile=SADMIN_%U.dmp logfile=SADMIN.log parallel=10 SCHEMAS=SADMIN expdp zhengly/8605683 directory=dmp_dir dumpfile=SIEBEL_%U.dmp logfile=SIEBEL.log parallel=10 SCHEMAS=SIEBEL expdp zhengly/8605683 directory=dmp_dir dumpfile=SSA_%U.dmp logfile=SSA.log parallel=10 SCHEMAS=SSA expdp zhengly/8605683 directory=dmp_dir dumpfile=UCMDIC_%U.dmp logfile=UCMDIC.log parallel=10 SCHEMAS=UCMDIC expdp zhengly/8605683 directory=dmp_dir dumpfile=UCMDSP_%U.dmp logfile=UCMDSP.log parallel=10 SCHEMAS=UCMDSP expdp zhengly/8605683 directory=dmp_dir dumpfile=UCMEXT_%U.dmp logfile=UCMEXT.log parallel=10 SCHEMAS=UCMEXT expdp 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_space 2. 新库导入工作及检查 2.1安装数据库软件 安装11g软件 2.2 DBCA建实例 dbca 注意选择与源库相应的字符集SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280 select * from nls_database_parameters 查看字符集 select userenv('language') from dual; 数据文件目录指定为/oracle/product/11.2.0/ucm/datafile 统一密码oracle 2.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 OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK 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 OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK 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 OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK 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 OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK 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 OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE EAIBAM_IAS_ORASDPM DATAFILE '/oracle/product/11.2.0/ucm/datafile/eaibam_ias_orasdpm.1742.771779567' SIZE 128M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TEMPORARY TABLESPACE EAIBAM_IAS_TEMP TEMPFILE '/oracle/product/11.2.0/ucm/datafile/eaibam_ias_temp.1743.771779623' SIZE 8192M AUTOEXTEND OFF TABLESPACE 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 OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE EAIBAM_ORABAM DATAFILE '/oracle/product/11.2.0/ucm/datafile/eaibam_orabam.1741.771779539' SIZE 512M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE EAIBAM_SOAINFRA DATAFILE '/oracle/product/11.2.0/ucm/datafile/eaibam_soainfra.1740.771779463' SIZE 1024M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK 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 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog1' SIZE 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog' SIZE 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.1775.772410537' SIZE 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.1776.772410563' SIZE 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.1806.772649435' SIZE 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.1838.772722057' SIZE 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.1839.772722079' SIZE 26000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.389.787090389' SIZE 30720M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.378.787161393' SIZE 29000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.307.787241605' SIZE 29000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.386.787278135' SIZE 29000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.420.787278157' SIZE 27000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.351.787538677' SIZE 30000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/eailog.380.787538707' SIZE 30000M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE HP_DBSPI DATAFILE '/oracle/product/11.2.0/ucm/datafile/hp_dbspi01.dbf' SIZE 500M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE INDX01 DATAFILE '/oracle/product/11.2.0/ucm/datafile/indx01.537.761332325' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.557.761332739' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.549.761332595' SIZE 2800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.572.761332903' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.633.761333767' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.666.761334055' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.651.761333965' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.649.761333959' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.635.761333813' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.636.761333851' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.638.761333887' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.669.761334059' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.654.761334021' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.728.761334181' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.643.761333931' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.639.761333919' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.640.761333921' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.731.761334225' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.696.761334085' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.733.761334229' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.652.761333975' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.647.761333957' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.648.761333959' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.737.761334249' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.729.761334201' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.738.761334265' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.655.761334023' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.715.761334107' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.653.761333989' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.741.761334307' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.734.761334233' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.739.761334267' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.672.761334061' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.727.761334179' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.726.761334165' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.745.761334355' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.740.761334297' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.757.761334463' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.695.761334085' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.730.761334207' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.732.761334225' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.751.761334395' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.750.761334377' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.763.761334543' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.735.761334235' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.736.761334245' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.742.761334325' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.754.761334431' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.756.761334459' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.769.761334619' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.743.761334329' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.746.761334361' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.744.761334343' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.765.761334571' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.758.761334477' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.772.761334631' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.749.761334375' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.747.761334371' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.748.761334371' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.767.761334587' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.762.761334531' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.777.761334671' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.752.761334401' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.759.761334525' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.760.761334525' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.780.761334685' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.768.761334615' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.782.761334699' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.753.761334429' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.764.761334555' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.770.761334619' SIZE 900M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.783.761334705' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.774.761334661' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.796.761334847' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.755.761334447' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.766.761334583' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.776.761334669' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.791.761334779' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.778.761334673' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.803.761334887' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.761.761334527' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.771.761334629' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.779.761334679' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.794.761334815' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.786.761334733' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.807.761334957' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.773.761334639' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.775.761334667' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.781.761334689' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.799.761334855' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.793.761334811' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.812.761335007' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.785.761334729' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.787.761334743' SIZE 900M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.784.761334721' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.800.761334857' SIZE 800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.801.761334863' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.818.761335051' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.792.761334779' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.790.761334777' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.788.761334759' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.806.761334941' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.802.761334881' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.819.761335057' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.795.761334827' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.798.761334855' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.789.761334767' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx01.810.761334979' SIZE 1024M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE INDX02 DATAFILE '/oracle/product/11.2.0/ucm/datafile/indx02.563.761332815' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.544.761332491' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.541.761332463' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.573.761332907' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.805.761334921' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.827.761335153' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.797.761334847' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.808.761334967' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.809.761334971' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.824.761335091' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.817.761335039' SIZE 3000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.830.761335155' SIZE 3000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.804.761334911' SIZE 3000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.814.761335021' SIZE 3000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.815.761335025' SIZE 1518M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.829.761335155' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.822.761335081' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.845.761335311' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.811.761334979' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.816.761335025' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.820.761335059' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.834.761335175' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.826.761335151' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.847.761335375' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx02.813.761335011' SIZE 1512M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE INDX03 DATAFILE '/oracle/product/11.2.0/ucm/datafile/indx03.555.761332721' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.580.761332971' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.569.761332869' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.547.761332581' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.821.761335079' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.825.761335091' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.838.761335239' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.837.761335209' SIZE 2800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.850.761335391' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx03.823.761335085' SIZE 2512M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE INDX04 DATAFILE '/oracle/product/11.2.0/ucm/datafile/indx04.550.761332597' SIZE 3012M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.581.761332989' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.582.761332991' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.583.761333023' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.828.761335153' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.832.761335157' SIZE 4000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.842.761335271' SIZE 4000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.840.761335245' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.851.761335407' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.831.761335155' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.835.761335185' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.833.761335157' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.846.761335321' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.841.761335263' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.852.761335423' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.839.761335243' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.844.761335307' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.836.761335189' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.849.761335377' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.843.761335299' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.853.761335497' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.848.761335375' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.854.761335517' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.856.761335523' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.857.761335559' SIZE 2048M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.865.761336001' SIZE 3000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.873.761336119' SIZE 3000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.859.761335893' SIZE 2000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.860.761335895' SIZE 2000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.858.761335875' SIZE 2000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.868.761336039' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.866.761336017' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.878.761336141' SIZE 3128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.862.761335945' SIZE 3512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.863.761335961' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.861.761335923' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.869.761336055' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.871.761336083' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.894.761336267' SIZE 5120M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.867.761336037' SIZE 3512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.864.761336001' SIZE 3000M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.870.761336073' SIZE 2700M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.877.761336133' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.872.761336115' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.896.761336289' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.874.761336129' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.876.761336131' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/indx04.875.761336129' SIZE 2512M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE TBS_DIC DATAFILE '/oracle/product/11.2.0/ucm/datafile/tbs_dic.506.761332089' SIZE 2128M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE TBS_DSP DATAFILE '/oracle/product/11.2.0/ucm/datafile/tbs_dsp.512.761332089' SIZE 521M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_dsp.508.761332089' SIZE 512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_dsp.519.761332091' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_dsp.515.761332089' SIZE 100M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_dsp.888.761336233' SIZE 128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_dsp.895.761336285' SIZE 100M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_dsp.897.761336339' SIZE 100M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE TBS_EXT DATAFILE '/oracle/product/11.2.0/ucm/datafile/tbs_ext.497.761332087' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_ext.496.761332085' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_ext.505.761332089' SIZE 1512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_ext.502.761332087' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_ext.902.761336461' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_ext.892.761336261' SIZE 1024M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE TBS_IDX DATAFILE '/oracle/product/11.2.0/ucm/datafile/tbs_idx.507.761332089' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_idx.520.761332091' SIZE 2128M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_idx.513.761332089' SIZE 1700M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_idx.526.761332091' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_idx.1391.762948947' SIZE 1512M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TEMPORARY TABLESPACE TBS_TEMP TEMPFILE '/oracle/product/11.2.0/ucm/datafile/tbs_temp.1213.761391297' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_temp.1212.761391297' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_temp.1211.761391293' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_temp.1210.761391293' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_temp.1664.768493073' SIZE 4096M AUTOEXTEND OFF TABLESPACE GROUP TEMPTBSGROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; CREATE TABLESPACE TBS_TRS DATAFILE '/oracle/product/11.2.0/ucm/datafile/tbs_trs.514.761332089' SIZE 2800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_trs.509.761332089' SIZE 2800M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_trs.501.761332087' SIZE 2600M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/tbs_trs.500.761332087' SIZE 3128M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TEMPORARY TABLESPACE UCMTEMP TEMPFILE '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1217.761391303' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1216.761391301' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1215.761391301' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1214.761391299' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1662.768486521' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1665.768494509' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1666.768494519' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1667.768494521' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1668.768496761' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/ucmtemp.1669.768496767' SIZE 4096M AUTOEXTEND OFF TABLESPACE GROUP TEMPTBSGROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/oracle/product/11.2.0/ucm/datafile/undotbs1.499.761332087' SIZE 2512M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs1.883.761336193' SIZE 1024M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs1.893.761336265' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs1.889.761336235' SIZE 100M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs1.900.761336415' SIZE 100M AUTOEXTEND OFF ONLINE RETENTION NOGUARANTEE BLOCKSIZE 8K FLASHBACK ON; CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/oracle/product/11.2.0/ucm/datafile/undotbs2.504.761332087' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs2.887.761336221' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs2.899.761336411' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs2.885.761336201' SIZE 4096M AUTOEXTEND OFF, '/oracle/product/11.2.0/ucm/datafile/undotbs2.891.761336237' SIZE 4096M AUTOEXTEND OFF ONLINE RETENTION NOGUARANTEE BLOCKSIZE 8K FLASHBACK ON; CREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/oracle/product/11.2.0/ucm/datafile/undotbs3.1' SIZE 100M AUTOEXTEND OFF ONLINE RETENTION NOGUARANTEE BLOCKSIZE 8K FLASHBACK ON; CREATE UNDO TABLESPACE UNDOTBS4 DATAFILE '/oracle/product/11.2.0/ucm/datafile/undotbs4.1' SIZE 100M AUTOEXTEND OFF ONLINE RETENTION NOGUARANTEE BLOCKSIZE 8K FLASHBACK ON; 2.4 创建role(不需要创建用户) 在impdp导入时,可能会遇到报错,有些role角色需要单独创建 CREATE ROLE TBLO_ROLE NOT IDENTIFIED; GRANT CREATE TYPE TO TBLO_ROLE; GRANT CREATE VIEW TO TBLO_ROLE; GRANT CREATE TABLE TO TBLO_ROLE; GRANT ALTER SESSION TO TBLO_ROLE; GRANT QUERY REWRITE TO TBLO_ROLE; GRANT CREATE CLUSTER TO TBLO_ROLE; GRANT CREATE SESSION TO TBLO_ROLE; GRANT CREATE SYNONYM TO TBLO_ROLE; GRANT CREATE TRIGGER TO TBLO_ROLE; GRANT CREATE OPERATOR TO TBLO_ROLE; GRANT CREATE SEQUENCE TO TBLO_ROLE; GRANT CREATE DIMENSION TO TBLO_ROLE; GRANT CREATE INDEXTYPE TO TBLO_ROLE; GRANT CREATE PROCEDURE TO TBLO_ROLE; GRANT ON COMMIT REFRESH TO TBLO_ROLE; GRANT CREATE DATABASE LINK TO TBLO_ROLE; GRANT CREATE MATERIALIZED VIEW TO TBLO_ROLE; GRANT TBLO_ROLE TO SIEBEL; GRANT TBLO_ROLE TO SYS WITH ADMIN OPTION; CREATE ROLE WM_ADMIN_ROLE NOT IDENTIFIED; GRANT SELECT ON WMSYS.AQ$WM$EVENT_QUEUE_TABLE TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.AQ$WM$EVENT_QUEUE_TABLE_R TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.AQ$WM$EVENT_QUEUE_TABLE_S TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_REMOVED_WORKSPACES TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_WM_SYS_PRIVS TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_WM_VERSIONED_TABLES TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_WM_VT_ERRORS TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_WORKSPACES TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_WORKSPACE_PRIVS TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_WORKSPACE_SAVEPOINTS TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.DBA_WORKSPACE_SESSIONS TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.WM_COMPRESSIBLE_TABLES TO WM_ADMIN_ROLE; GRANT SELECT ON WMSYS.WM_COMPRESS_BATCH_SIZES TO WM_ADMIN_ROLE; GRANT WM_ADMIN_ROLE TO DBA; GRANT WM_ADMIN_ROLE TO WMSYS WITH ADMIN OPTION; CREATE ROLE SSE_ROLE NOT IDENTIFIED; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_ACCNT_PROD TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_ACC_PROD_GK TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_CON_PROFILE TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_CRM_JOB_CTR TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_CRM_JOB_DEF TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_CUST_LABEL TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_CUST_REQ TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_ORG_GROUP TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.CX_REP_PROFILE TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.EIM_ACCDTL_TNT TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.EIM_ACCNTROUTE TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.EIM_ACCNT_CUT TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.EIM_ACCNT_DTL TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.EIM_ACCNT_ISS TO SSE_ROLE; GRANT DELETE, INSERT, SELECT, UPDATE ON SIEBEL.EIM_ACCNT_PROF TO SSE_ROLE; 等role都重新创建 2.5 导入数据 导入前,在目标系统创建导入dump目录 创建目录 su -oracle mkdir -p /home/data_space/exp sqlplus / as sysdba SQL> select count(*) from v$session where username='***'; 预期0 SQL> create or replace directory impdp_dir as '/home/data_space/exp'; SQL> grant read,write on directory impdp_dir to public; 停止job alter system set job_queue_processes=0 scope=both sid='*'; 确认有无jobs运行 select job from dba_jobs_running; 进行数据导入 impdp zhengly/8605683 directory=impdp_dir dumpfile=BAM_MDS_%U.dmp logfile=BAM_MDS1.log parallel=10 SCHEMAS=BAM_MDS impdp zhengly/8605683 directory=impdp_dir dumpfile=BAM_ORABAM_%U.dmp logfile=BAM_ORABAM1.log parallel=10 SCHEMAS=BAM_ORABAM impdp zhengly/8605683 directory=impdp_dir dumpfile=BAM_ORASDPM_%U.dmp logfile=BAM_ORASDPM1.log parallel=10 SCHEMAS=BAM_ORASDPM impdp zhengly/8605683 directory=impdp_dir dumpfile=BAM_SOAINFRA_%U.dmp logfile=BAM_SOAINFRA1.log parallel=10 SCHEMAS=BAM_SOAINFRA impdp zhengly/8605683 directory=impdp_dir dumpfile=EAIUSER_%U.dmp logfile=EAIUSER1.log parallel=10 SCHEMAS=EAIUSER impdp zhengly/8605683 directory=impdp_dir dumpfile=EXPCMI_%U.dmp logfile=EXPCMI1.log parallel=10 SCHEMAS=EXPCMI impdp zhengly/8605683 directory=impdp_dir dumpfile=EXPEDW_%U.dmp logfile=EXPEDW1.log parallel=10 SCHEMAS=EXPEDW impdp zhengly/8605683 directory=impdp_dir dumpfile=EXPESTORE_%U.dmp logfile=EXPESTORE1.log parallel=10 SCHEMAS=EXPESTORE impdp zhengly/8605683 directory=impdp_dir dumpfile=EXPHCSP_%U.dmp logfile=EXPHCSP1.log parallel=10 SCHEMAS=EXPHCSP impdp zhengly/8605683 directory=impdp_dir dumpfile=EXPLED_%U.dmp logfile=EXPLED1.log parallel=10 SCHEMAS=EXPLED impdp zhengly/8605683 directory=impdp_dir dumpfile=GUESTCP_%U.dmp logfile=GUESTCP1.log parallel=10 SCHEMAS=GUESTCP impdp zhengly/8605683 directory=impdp_dir dumpfile=GUESTCST_%U.dmp logfile=GUESTCST1.log parallel=10 SCHEMAS=GUESTCST impdp zhengly/8605683 directory=impdp_dir dumpfile=HP_DBSPI_%U.dmp logfile=HP_DBSPI1.log parallel=10 SCHEMAS=HP_DBSPI impdp zhengly/8605683 directory=impdp_dir dumpfile=LDAPUSER_%U.dmp logfile=LDAPUSER1.log parallel=10 SCHEMAS=LDAPUSER impdp zhengly/8605683 directory=impdp_dir dumpfile=MGMT_VIEW_%U.dmp logfile=MGMT_VIEW1.log parallel=10 SCHEMAS=MGMT_VIEW impdp zhengly/8605683 directory=impdp_dir dumpfile=SADMIN_%U.dmp logfile=SADMIN1.log parallel=10 SCHEMAS=SADMIN impdp zhengly/8605683 directory=impdp_dir dumpfile=SIEBEL_%U.dmp logfile=SIEBEL1.log parallel=10 SCHEMAS=SIEBEL impdp zhengly/8605683 directory=impdp_dir dumpfile=SSA_%U.dmp logfile=SSA1.log parallel=10 SCHEMAS=SSA impdp zhengly/8605683 directory=impdp_dir dumpfile=UCMDIC_%U.dmp logfile=UCMDIC1.log parallel=10 SCHEMAS=UCMDIC impdp zhengly/8605683 directory=impdp_dir dumpfile=UCMDSP_%U.dmp logfile=UCMDSP1.log parallel=10 SCHEMAS=UCMDSP impdp zhengly/8605683 directory=impdp_dir dumpfile=UCMEXT_%U.dmp logfile=UCMEXT1.log parallel=10 SCHEMAS=UCMEXT impdp zhengly/8605683 directory=impdp_dir dumpfile=UCMTRS_%U.dmp logfile=UCMTRS1.log parallel=10 SCHEMAS=UCMTRS 同时禁用自动统计分析 SQL> select ENABLED,AUTO_DROP,RESTARTABLE,STATE from dba_scheduler_jobs where job_name='GATHER_STATS_JOB'; ENABL AUTO_ RESTA STATE ----- ----- ----- --------------- TRUE FALSE TRUE SCHEDULED SQL> exec dbms_scheduler.disable( 'GATHER_STATS_JOB' ); PL/SQL procedure successfully completed. SQL> select ENABLED,AUTO_DROP,RESTARTABLE,STATE from dba_scheduler_jobs where job_name='GATHER_STATS_JOB'; ENABL AUTO_ RESTA STATE ----- ----- ----- --------------- FALSE FALSE TRUE DISABLED 完成后启用jobs alter system set job_queue_processes=150 scope=both sid='*'; 完成后启用自动统计分析 exec dbms_scheduler.enable( 'GATHER_STATS_JOB' ); 2.6 检查数据库对象 select object_name,owner from dba_objects where status<>'VALID'; @?/rdbms/admin/utlrp select object_name,owner from dba_objects where status<>'VALID'; utlrp.sql脚本可以在数据库运行的状态下执行以编译、数据库中的invalid对象 oracle建议在对数据库进行迁移、升级、降级后都运行一遍utlrp.sql以编译无效对象。 2.7 修改数据库为归档模式 alter systtem set log_archive_dest_1=’location=/oracle/orcl/oraarch’ scope=spfile; shutdownimmediate alter database archivelog alter database open 2.8 数据库参数修改 修改如下的参数与原先的数据库保持一致: Sga_target Pga_target Undo Job 2.9 修改用户密码 alter user system identified by values 'F7B46C5C0DC552DA'; 2.10 检查对象 Bjh02用户对象: 授予权限 tables: 462 views : 4 其中1个失效 同义词: 0 functions: 49 procedures: 255 packages: 132 触发器: 83 失效对象: 181 jobs: 21 其中1个失效 indexs: 638 constrains:1418 sequences: 454 type : 11 recycle bin: 13 bjhcms用户对象 tables: 34 view 7 sequences: 34 constrains: 133 index 33

下载文档到电脑,查找使用更方便

文档的实际排版效果,会与网站的显示效果略有不同!!

需要 8 金币 [ 分享文档获得金币 ] 0 人已下载

下载文档