请教达人,9.2.0.4 for as3u9 在导入数据(大约1G大小的dmp文件)时出现死机现象,与哪些参数有关?
环境如下:普通PC机,2G内存,320GHD,as3u9,oracle按官方默认参数安装好,这前曾成功导入600M大小的dmp文件,删除数据表之后再次导入总是失败(中途停顿卡死在数据量大的那张表那里),无任何反。反复操作都是如此。
环境如下:普通PC机,2G内存,320GHD,as3u9,oracle按官方默认参数安装好,这前曾成功导入600M大小的dmp文件,删除数据表之后再次导入总是失败(中途停顿卡死在数据量大的那张表那里),无任何反。反复操作都是如此。
解决方案 »
- oracle可以在查询中更新数据吗?
- oracle导出远程服务器的数据
- 创建数据库的时候出现错误,启动 Database Control 时出错,求解
- 用友NC和浪潮myGS软件哪个更好一些??
- 大家知道oracle migration workblech 这么使用吗
- oracel中三个表的内连接语句怎么写
- 定义的序列号,能不能生成00000001-99999999
- 请教如何显示oracle9i中自定义包的源代码
- oracle 9i里有没有像SQL SERVER 2000 中的是事件探查器的功能?
- 什么情况会导致单独的oracle数据库服务器中Oracle进程使用了99%的cpu资源?
- 求oracle sql 语句
- Oracle自定义序列号生成时的并发操作问题
alert日志错误提示
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Dec 19 09:02:20 2012
/* OracleOEM */ ALTER DATABASE MOUNT
Wed Dec 19 09:02:24 2012
Successful mount of redo thread 1, with mount id 1330217500.
Wed Dec 19 09:02:24 2012
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Wed Dec 19 09:02:24 2012
/* OracleOEM */ ALTER DATABASE OPEN
Wed Dec 19 09:02:24 2012
Beginning crash recovery of 1 threads
Wed Dec 19 09:02:24 2012
Started first pass scan
Wed Dec 19 09:02:24 2012
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Wed Dec 19 09:02:24 2012
Started recovery at
Thread 1: logseq 453, block 204799, scn 0.90897103
Recovery of Online Redo Log: Thread 1 Group 2 Seq 453 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/orcl/redo02.log
Wed Dec 19 09:02:24 2012
Completed redo application
Wed Dec 19 09:02:24 2012
Ended recovery at
Thread 1: logseq 453, block 204799, scn 0.90917104
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Wed Dec 19 09:02:24 2012
LGWR: Primary database is in CLUSTER CONSISTENT mode
Wed Dec 19 09:02:24 2012
ARCH: Evaluating archive log 3 thread 1 sequence 451
ARCH: Beginning to archive log 3 thread 1 sequence 451
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/ora92/dbs/arch1_451.dbf'
ARCH: Completed archiving log 3 thread 1 sequence 451
Wed Dec 19 09:02:28 2012
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 454
Thread 1 opened at log sequence 454
Current log# 3 seq# 454 mem# 0: /opt/oracle/oradata/orcl/redo03.log
Successful open of redo thread 1.
Wed Dec 19 09:02:29 2012
SMON: enabling cache recovery
Wed Dec 19 09:02:29 2012
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Wed Dec 19 09:02:29 2012
SMON: enabling tx recovery
Wed Dec 19 09:02:29 2012
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Wed Dec 19 09:02:30 2012
SMON: Parallel transaction recovery tried
Wed Dec 19 09:04:23 2012
ARCH: Possible network disconnect with primary database
Wed Dec 19 12:55:45 2012
ORACLE Instance orcl - Can not allocate log, archival required
Wed Dec 19 12:55:45 2012
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 455
All online logs needed archiving
Current log# 3 seq# 454 mem# 0: /opt/oracle/oradata/orcl/redo03.log
Wed Dec 19 13:04:49 2012
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water = 7
Wed Dec 19 13:06:49 2012
Starting ORACLE instance (normal)
Wed Dec 19 13:10:01 2012
Active process 4561 user 'oracle' program 'oracle@localhost (QMN0)'
Active process 4976 user 'oracle' program 'oracle@localhost (TNS V1-V3)'
SHUTDOWN: waiting for logins to complete.
Wed Dec 19 13:11:21 2012
Shutting down instance (abort)不会看。
今天测试:另建了一用户和表空间,试着导入一个大小为50M左右的dmp文件,成功。
再接着,重新导入正式库文件(1G左右),进度还没达到上次导入那里就停顿了。