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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 18:46:04 | 查看: 1246| 回复: 0

*******************************************************************************
[YOU HAVE NEW MAIL]
omdrms10:/>su - oracle
omdrms10:/home/oracle>sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Tue May 21 11:55:37 2013

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2586808888 bytes
Fixed Size                   746040 bytes
Variable Size            1006632960 bytes
Database Buffers         1577058304 bytes
Redo Buffers                2371584 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>


alert.log 中对应日志
Tue May 21 11:57:14 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
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                = 550
  sessions                 = 610
  timed_statistics         = TRUE
  shared_pool_size         = 385875968
  sga_max_size             = 2586808888
  large_pool_size          = 67108864
  java_pool_size           = 16777216
  nls_date_format          = DD-MON-RR
  control_files            = /RMSUAT/CHINACS/system/control01.ctl, /RMSUAT/CHINACS/system/control02.ctl
  db_block_size            = 8192
  db_cache_size            = 1577058304
  compatible               = 9.2.0
  log_archive_start        = FALSE
  log_archive_dest_1       = LOCATION=/RMSUAT/CHINACS/archive
  log_archive_dest_state_1 = ENABLE
  log_archive_format       = %t_%s.dbf
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS
  max_enabled_roles        = 120
  remote_os_authent        = TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = CHINACS
  job_queue_processes      = 3
  background_dump_dest     = /RMSUAT/CHINACS/admin/bdump
  user_dump_dest           = /RMSUAT/CHINACS/admin/udump
  core_dump_dest           = /RMSUAT/CHINACS/admin/cdump
  sort_area_size           = 524288
  db_name                  = CHINACS
  open_cursors             = 300
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
Tue May 21 11:57:15 2013
ALTER DATABASE   MOUNT
Tue May 21 11:57:19 2013
Successful mount of redo thread 1, with mount id 3177414875.
Tue May 21 11:57:19 2013
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Tue May 21 11:57:19 2013
ALTER DATABASE OPEN
Tue May 21 11:57:19 2013
Beginning crash recovery of 1 threads
Tue May 21 11:57:19 2013
Started first pass scan
Tue May 21 11:57:20 2013
Completed first pass scan
48 redo blocks read, 5 data blocks need recovery
Tue May 21 11:57:20 2013
Started recovery at
Thread 1: logseq 4, block 2, scn 1603.3732743047
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0 errs 0: /RMSUAT/CHINACS/system/redo4.log
Tue May 21 11:57:20 2013
Completed redo application
Tue May 21 11:57:20 2013
Ended recovery at
Thread 1: logseq 4, block 50, scn 1603.3732763088
5 data blocks read, 5 data blocks written, 48 redo blocks read
Crash recovery completed successfully
Tue May 21 11:57:20 2013
Thread 1 advanced to log sequence 5
Thread 1 opened at log sequence 5
  Current log# 5 seq# 5 mem# 0: /RMSUAT/CHINACS/system/redo5.log
Successful open of redo thread 1.
Tue May 21 11:57:20 2013
SMON: enabling cache recovery
Tue May 21 11:57:20 2013
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 21 11:57:20 2013
SMON: enabling tx recovery
Tue May 21 11:57:21 2013
Database Characterset is UTF8
Tue May 21 11:57:21 2013
Errors in file /RMSUAT/CHINACS/admin/udump/chinacs_ora_4309068.trc:
ORA-00600: internal error code, arguments: [4194], [4], [4], [], [], [], [], []
Recovery of Online Redo Log: Thread 1 Group 5 Seq 5 Reading mem 0
  Mem# 0 errs 0: /RMSUAT/CHINACS/system/redo5.log
Recovery of Online Redo Log: Thread 1 Group 5 Seq 5 Reading mem 0
  Mem# 0 errs 0: /RMSUAT/CHINACS/system/redo5.log
Tue May 21 11:57:21 2013
Errors in file /RMSUAT/CHINACS/admin/udump/chinacs_ora_4309068.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [4], [4], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_dbw0_4452400.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_pmon_4031054.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_lgwr_4468776.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_dbw1_3506976.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_ckpt_3502912.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_smon_4010504.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-12801: error signaled in parallel query server P001
ORA-30317: Internal
Instance terminated by USER, pid = 4309068
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-6-15 18:29 , Processed in 0.045304 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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