Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 14:54:41 | 查看: 1229| 回复: 0

【求助】oracle 启动不了了ORA-01092: ORACLE instance terminated. Disconnection forced

oracle 启动不了了ORA-01092: ORACLE instance terminated. Disconnection forced
redhat linux 下安装oracle9i。一直正常使用。由于服务器内存较小,今天把他用vmare迁移到新服务器的虚拟机上。结果oracle打不开了。

ORA-01092: ORACLE instance terminated. Disconnection forced错误
  


153551zhd46zt7ei8eidey.jpg

还有我原来服务器内存是1G的。新服务器的虚拟机我分配了8G内存。不知道是什么参数要调整不?
目前我原有数据库服务器还在正常运行着。可以随时导出数据来,但我不知道该怎么把它迁移过来了。
是我需要重新迁移吗还是怎么,如果需要重新迁移,请问下需要注意些什么。

当然如果能够直接解决数据库启动的问题就更好了

请教各位大大,这是什么原因,我该怎么办呢?。急急急啊。


日志如下:
Mon May 25 23:55:49 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 100663296
  large_pool_size          = 67108864
  java_pool_size           = 33554432
  control_files            = /var/data/oracle/oradata/ora8i/control01.ctl, /var/data/oracle/oradata/ora8i/control02.ctl, /var/data/oracle/oradata/ora8i/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 268435456
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = ora8i
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ora8iXDB)
  hash_join_enabled        = TRUE
  background_dump_dest     = /opt/oracle/admin/ora8i/bdump
  user_dump_dest           = /opt/oracle/admin/ora8i/udump
  core_dump_dest           = /opt/oracle/admin/ora8i/cdump
  sort_area_size           = 524288
  db_name                  = ora8i
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 239075328
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon May 25 23:55:50 2015
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon May 25 23:55:51 2015
ALTER DATABASE   MOUNT
Mon May 25 23:55:55 2015
Successful mount of redo thread 1, with mount id 302528071.
Mon May 25 23:55:55 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Mon May 25 23:56:44 2015
alter database clear logfile group 4
Mon May 25 23:56:44 2015
ORA-359 signalled during: alter database clear logfile group 4...
Mon May 25 23:57:52 2015
alter database clear unarchived logfile group 4
Mon May 25 23:57:52 2015
ORA-359 signalled during: alter database clear unarchived logfile group 4...
Tue May 26 00:00:39 2015
alter database open
Tue May 26 00:00:39 2015
Beginning crash recovery of 1 threads
Tue May 26 00:00:39 2015
Started first pass scan
Tue May 26 00:00:40 2015
Completed first pass scan
54 redo blocks read, 4 data blocks need recovery
Tue May 26 00:00:40 2015
Started recovery at
Thread 1: logseq 351, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 351 Reading mem 0
  Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo03.log
Tue May 26 00:00:40 2015
Completed redo application
Tue May 26 00:00:40 2015
Ended recovery at
Thread 1: logseq 351, block 57, scn 0.117779741
4 data blocks read, 4 data blocks written, 54 redo blocks read
Crash recovery completed successfully
Tue May 26 00:00:40 2015
Thread 1 advanced to log sequence 352
Thread 1 opened at log sequence 352
  Current log# 1 seq# 352 mem# 0: /var/data/oracle/oradata/ora8i/redo01.log
Successful open of redo thread 1.
Tue May 26 00:00:40 2015
SMON: enabling cache recovery
Tue May 26 00:00:40 2015
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.
Tue May 26 00:00:40 2015
SMON: enabling tx recovery
Tue May 26 00:00:40 2015
Database Characterset is ZHS16GBK
Tue May 26 00:00:40 2015
Errors in file /opt/oracle/admin/ora8i/udump/ora8i_ora_7044.trc:
ORA-00600: internal error code, arguments: [4194], [54], [51], [], [], [], [], []
Tue May 26 00:00:40 2015
Errors in file /opt/oracle/admin/ora8i/bdump/ora8i_smon_7036.trc:
ORA-00600: internal error code, arguments: [4194], [
33], [38], [], [], [], [], []
Tue May 26 00:00:46 2015
Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0
  Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0
  Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log
Tue May 26 00:00:46 2015
Errors in file /opt/oracle/admin/ora8i/bdump/ora8i_smon_7036.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [33], [38], [], [], [], [], []
Tue May 26 00:00:47 2015
Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0
  Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0
  Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log
Tue May 26 00:00:47 2015
Errors in file /opt/oracle/admin/ora8i/udump/ora8i_ora_7044.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [54], [51], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 7044
ORA-1092 signalled during: alter database open
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 14:54 , Processed in 0.053584 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569