oracle 11g 错误版本惹的祸
**背景说明**:
一客户在 Windows server 2016 上,一时匆忙,没找到oracle 11g 64位的安装包,就任性安装了一个手头上的版本:oracle 11.2.0.1 32位。开始使用impdp 导入原EAS 数据正常导入成功,dmp文件大概47G。后来转生产环境后,做每天的定时expdp备份时,不曾想,悲剧发生了。
**现象描述:**
expdp 按schema导出,备份的批处理文件如下:
del /f /s /q d:\easbak
@echo off
set ORACLE_SID=orcl
set NLS_LANG=AMERICAN_AMERICA.UTF8
set rq=%date:~0,4%%date:~5,2%%date:~8,2%
if %TIME:~0,2% leq 9 (set tm=0%TIME:~1,1%%TIME:~3,2%)else set tm=%time:~0,2%%time:~3,2%
set rqtm=%rq%%tm%
expdp system/Password directory=backdir dumpfile=eascloud%rqtm%.dmp logfile=eascloud%rqtm%.log schemas=eascloud
**报错信息**
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_05": system/******** directory=easbak dumpfile=eascloud202106260927.dmp logfile=eascloud202106260927.log schemas=eascloud
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 43.68 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 2016 bytes (kxs-heap-w,kghsseg : kokeismo)
ORA-06512: at "SYS.KUPW$WORKER", line 1712
ORA-06512: at line 2
Job "SYSTEM"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 09:33:47
**处理过程**
先是网上找方法,可是任凭我1. 增大undo表空间:
SQL> alter system set undo_retention=7200;
SQL> alter database datafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF' resize 5g;
2. 设置隐藏参数:
对11.2.0.4 以及以下版本数据库: _use_realfree_heap=TRUE _realfree_heap_pagesize_hint=262144
3. 调整内存参数:
SQL> alter system set memory_target=0 scope=spfile;
SQL> alter system set memory_max_target=0 scope=spfile;
SQL> alter system reset memory_max_target scope=spfile;
SQL> alter system set sga_target=1G scope=spfile;
SQL> alter system set pga_aggregate_target=2G scope=spfile;
报错依旧。
先导出个元数据吧:expdp 加上content=METADATA_ONLY 也是报同样的错误。
怎么办呢? 只能用exp试试了。OMG!
exp system/Password file=D:\easbak\eascloud%rqtm%.dmp log=D:\easbak\eascloud%rqtm%.log owner=eascloud buffer=80960000
虽然有一堆warning,但是好歹能导出40+G的数据了,跟impdp时的数据差不多了。再仔细一看,只有有数据的大概几百张表,记录数为0 的表没有导出,这样应用肯定是run不起来啊。
网上找了下,大概意思是没有将未分配extend的表导出来。只好手工分配一下extend:
set pagesize 8000
set linesize 500
set wrap off
spool eascloudalloc.txt
select 'alter table '||table_name ||' allocate extent;' from dba_tables where owner='EASCLOUD' and table_name not like 'VT%';
spool off
conn eascloud/password
@eascloudalloc.txt
然后再进行exp导出,明天看看,期待有好的结果吧!
oracle 11g 错误版本惹的祸
**背景说明**:一客户在 Windows server 2016 上,一时匆忙,没找到oracle 11g 64位的安装包,就任性安装了一个手头上的版本:oracle...
点击下载文档
本文2024-09-16 22:37:54发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-49352.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章