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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 15:34:07 | 查看: 1816| 回复: 0

数据库启动后,出错。SQL> startup
ORACLE instance started.
        Total System Global Area 4275781632 bytes
Fixed Size                  2145048 bytes
Variable Size            2600469736 bytes
Database Buffers         1660944384 bytes
Redo Buffers               12222464 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 14942262
Session ID: 1655 Serial number: 5

查看日志文件,如下:
Completed redo application
Completed crash recovery at
Thread 1: logseq 11, block 3, scn 13981938126766
0 data blocks read, 0 data blocks written, 1 redo blocks read
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
  Current log# 3 seq# 12 mem# 0: /oracle/app/oracle/oradata/wmtst/data/redo3a.log
  Current log# 3 seq# 12 mem# 1: /oracle/app/oracle/oradata/wmtst/data/redo3b.log
Successful open of redo thread 1
SMON: enabling cache recovery
Errors in file /oracle/app/oracle/oradata/wmtst/diag/diag/rdbms/wmtst/wmtst/trace/wmtst_ora_14942262.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Error 704 happened during db open, shutting down database
USER (ospid: 14942262): terminating the instance due to error 704
Instance terminated by USER, pid = 14942262
ORA-1092 signalled during: ALTER DATABASE OPEN...
ORA-1092 : opiodr aborting process unknown ospid (14942262_1)
Sun Feb 08 02:17:55 2015
ORA-1092 : opitsk aborting process

查看wmtst_ora_14942262.trc,内容如下:

Trace file /oracle/app/oracle/oradata/wmtst/diag/diag/rdbms/wmtst/wmtst/trace/wmtst_ora_14942262.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app/oracle/product/11.1.0/db_1
System name:    AIX
Node name:      test
Release:        1
Version:        6
Machine:        00CADFD64C00
Instance name: wmtst
Redo thread mounted by this instance: 1
Oracle process number: 16
Unix process pid: 14942262, image: oracle@test (TNS V1-V3)

*** 2015-02-08 02:17:52.924
*** SESSION ID1655.5) 2015-02-08 02:17:52.924
*** CLIENT ID) 2015-02-08 02:17:52.924
*** SERVICE NAME) 2015-02-08 02:17:52.924
*** MODULE NAMEsqlplus@test (TNS V1-V3)) 2015-02-08 02:17:52.924
*** ACTION NAME) 2015-02-08 02:17:52.924
        Successfully allocated 3 recovery slaves
Using 93 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 11, block 2, scn 13981938106764
  start recovery at logseq 11, block 2, scn 13981938106764
        *** 2015-02-08 02:17:52.997
Started resilvering redo thread 1 seq 11: blocks 2-2
        *** 2015-02-08 02:17:53.007
Completed resilvering redo thread 1 seq 11
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 1024Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 0Kb in 0.07s => 0.01 Mb/sec
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0cb7.6c74418d (13981938106765)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0


请各位大侠看看如何解决?



Errors in file /oracle/app/oracle/oradata/wmtst/diag/diag/rdbms/wmtst/wmtst/trace/wmtst_ora_14942262.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Error 704 happened during db open, shutting down database
USER (ospid: 14942262): terminating the instance due to error 704
Instance terminated by USER, pid = 14942262
ORA-1092 signalled during: ALTER DATABASE OPEN...
ORA-1092 : opiodr aborting process unknown ospid (14942262_1)
Sun Feb 08 02:17:55 2015
ORA-1092 : opitsk aborting process



下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-12-20 16:28 , Processed in 0.049916 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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