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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 23:12:58 | 查看: 1222| 回复: 1
早上接到信通处某领导通知要帮忙看看一个数据库,远程到服务器上(在windows安装的) sqlplus,  数据库状态为started,
执行: shutdown immediate,  startup 后 报错ORA-00600: ??????, ??: [kccpb_sanity_check_2], [170630], [170629], [0x0], [], [], [], []
, 经各方了解进行过机器重启而且数据库还没有关闭, 判断控制文件已经损坏。
  从备份的控制文件1拷贝到数据库用的控制文件3后在重启数据库,报错system01.dbf已经损坏, recover database until cancel ...

一番折腾后数据库介质恢复, 奇怪的事情就发生了:

    alter  database open 报错 ORA-01092: ORACLE实例终止。强制断开连接
--------------------------------------------------------------------------------------------------------------------------------------------------------   
查看alter文件:
Instance shutdown complete
Mon May 23 16:52:31  2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
IMODE=BR
ILAT =97
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.5.0.
System parameters with non-default values:
  processes                = 800
  __shared_pool_size       = 96468992
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 612368384
  control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\BZDB\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 499122176
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\oracle\product\10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  _allow_error_simulation  = TRUE
  _allow_resetlogs_corruption= FALSE
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=bzdbXDB)
  shared_servers           = 0
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\BZDB\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\BZDB\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\BZDB\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\BZDB\CDUMP
  db_name                  = bzdb
  open_cursors             = 300
  pga_aggregate_target     = 203423744
PMON started with pid=2, OS id=5816
PSP0 started with pid=3, OS id=4144
MMAN started with pid=4, OS id=5780
DBW0 started with pid=5, OS id=5408
LGWR started with pid=6, OS id=2668
CKPT started with pid=7, OS id=5072
SMON started with pid=8, OS id=4196
RECO started with pid=9, OS id=5740
CJQ0 started with pid=10, OS id=4356
MMON started with pid=11, OS id=1444
Mon May 23 16:52:31  2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4892
Mon May 23 16:52:31  2011
Warning: Shared server clients will not be able to connect because SHARED_SERVERS is 0
Mon May 23 16:52:32  2011
ALTER DATABASE   MOUNT
Mon May 23 16:52:36  2011
Setting recovery target incarnation to 9
Mon May 23 16:52:36  2011
Successful mount of redo thread 1, with mount id 1280563664
Mon May 23 16:52:36  2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Mon May 23 16:52:37  2011
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Mon May 23 16:52:42  2011
ALTER DATABASE RECOVER  database  
Media Recovery Start
parallel recovery started with 2 processes
Mon May 23 16:52:42  2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 18 Reading mem 0
  Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\BZDB\REDO03.LOG
Completed: ALTER DATABASE RECOVER  database  
Mon May 23 16:52:56  2011
alter database open resetlogs
Mon May 23 16:52:56  2011
ORA-1139 signalled during: alter database open resetlogs...
Mon May 23 16:53:06  2011
alter database open
Mon May 23 16:53:06  2011
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Mon May 23 16:53:06  2011
Started redo scan
Mon May 23 16:53:06  2011
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Mon May 23 16:53:06  2011
Started redo application at
Thread 1: logseq 18, block 2, scn 818426766
Mon May 23 16:53:06  2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 18 Reading mem 0
  Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\BZDB\REDO03.LOG
Mon May 23 16:53:06  2011
Completed redo application
Mon May 23 16:53:06  2011
Completed crash recovery at
Thread 1: logseq 18, block 3, scn 818446768
0 data blocks read, 0 data blocks written, 1 redo blocks read
Mon May 23 16:53:06  2011
Thread 1 advanced to log sequence 19 (thread open)
Thread 1 opened at log sequence 19
  Current log# 1 seq# 19 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\BZDB\REDO01.LOG
Successful open of redo thread 1
Mon May 23 16:53:06  2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 23 16:53:06  2011
SMON: enabling cache recovery
Mon May 23 16:53:06  2011
Errors in file d:\oracle\product\10.2.0\admin\bzdb\udump\bzdb_ora_5008.trc:
ORA-00704: 引导程序进程失败
ORA-39700: 必须用 UPGRADE 选项打开数据库

Mon May 23 16:53:06  2011
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 5008
ORA-1092 signalled during: alter database open...
--------------------------------------------------------------------------------------------------------------------------------------------------------


  我执行: startup upgrade还是报错: 报错 ORA-01092: ORACLE实例终止


进行完介质恢复成功后alter database open 也报ORA-01092: ORACLE实例终止。强制断开连接,
执行startup也报错,  到底是什么原因不能open数据库呢? 怎样去排查和解决,各位puber帮帮忙吧   


以下是参数文件的内容:

bzdb.__db_cache_size=499122176
bzdb.__java_pool_size=4194304
bzdb.__large_pool_size=4194304
bzdb.__shared_pool_size=96468992
bzdb.__streams_pool_size=0
*._allow_error_simulation=TRUE
*._allow_resetlogs_corruption=FALSE
*.audit_file_dest='D:\oracle\product\10.2.0/admin/bzdb/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/bzdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\product\10.2.0\oradata\bzdb\control03.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/bzdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='bzdb'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=bzdbXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=800
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.shared_servers=0
*.undo_management='manual'
*.undo_tablespace='UNDOTBS01.DBF'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/bzdb/udump'
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
2#
发表于 2017-4-12 23:13:58

数据库处于非归档模式

我后来又手工重建了控制文件,但错误依旧啊

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-12-20 16:25 , Processed in 0.044871 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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