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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 18:47:17 | 查看: 1266| 回复: 0
环境 win7  11gr2

Thu May 23 09:38:30 2013
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 3
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu May 23 09:38:35 2013
Stopping background process VKTM:
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu May 23 09:38:37 2013
Instance shutdown complete
Thu May 23 09:39:29 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 808M
  control_files            = "D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
  control_files            = "D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\app\Administrator\flash_recovery_area"
  db_recovery_file_dest_size= 3912M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  local_listener           = "LISTENER_ORCL"
  audit_file_dest          = "D:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  diagnostic_dest          = "D:\APP\ADMINISTRATOR"
Thu May 23 09:39:30 2013
PMON started with pid=2, OS id=22032
Thu May 23 09:39:30 2013
VKTM started with pid=3, OS id=6100 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu May 23 09:39:30 2013
GEN0 started with pid=4, OS id=22404
Thu May 23 09:39:30 2013
DIAG started with pid=5, OS id=16852
Thu May 23 09:39:30 2013
DBRM started with pid=6, OS id=6228
Thu May 23 09:39:30 2013
PSP0 started with pid=7, OS id=9196
Thu May 23 09:39:30 2013
DIA0 started with pid=8, OS id=9400
Thu May 23 09:39:30 2013
MMAN started with pid=9, OS id=20760
Thu May 23 09:39:30 2013
DBW0 started with pid=10, OS id=18540
Thu May 23 09:39:30 2013
LGWR started with pid=11, OS id=19836
Thu May 23 09:39:30 2013
CKPT started with pid=12, OS id=9524
Thu May 23 09:39:30 2013
SMON started with pid=13, OS id=20728
Thu May 23 09:39:30 2013
RECO started with pid=14, OS id=17572
Thu May 23 09:39:30 2013
MMON started with pid=15, OS id=6644
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu May 23 09:39:30 2013
MMNL started with pid=16, OS id=12472
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\app\Administrator
Thu May 23 09:39:30 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 1343944786
Database mounted in Exclusive Mode
Lost write protection disabled
Thu May 23 09:39:41 2013
Completed: ALTER DATABASE   MOUNT
Thu May 23 09:39:41 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Completed redo scan
read 42 KB redo, 0 data blocks need recovery
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5732.trc  (incident=115372):
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [688], [19976], [19986], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_115372\orcl_ora_5732_i115372.trc
Thu May 23 09:39:46 2013
Trace dumping is performing id=[cdmp_20130523093946]
Aborting crash recovery due to error 600
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5732.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [688], [19976], [19986], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5732.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [688], [19976], [19986], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Thu May 23 09:40:37 2013
Sweep [inc][115372]: completed
Sweep [inc2][115372]: completed


以上为alter_orcl.log

Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5732.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1  
CPU                 : 2 - type 8664, 2 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:931M/4061M, Ph+PgF:1848M/8120M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 20
Windows thread id: 5732, image: ORACLE.EXE (SHAD)


*** 2013-05-23 09:39:43.208
*** SESSION ID9.5) 2013-05-23 09:39:43.208
*** CLIENT ID) 2013-05-23 09:39:43.208
*** SERVICE NAME) 2013-05-23 09:39:43.208
*** MODULE NAMEsqlplus.exe) 2013-05-23 09:39:43.208
*** ACTION NAME) 2013-05-23 09:39:43.208

Successfully allocated 2 recovery slaves
Using 66 overflow buffers per recovery slave

*** 2013-05-23 09:39:45.102
Thread 1 checkpoint: logseq 688, block 2, scn 16276569
  cache-low rba: logseq 688, block 19892
    on-disk rba: logseq 688, block 19986, scn 16282142
  start recovery at logseq 688, block 19892, scn 0

*** 2013-05-23 09:39:45.625
Started writing zeroblks thread 1 seq 688 blocks 19976-19983

*** 2013-05-23 09:39:45.774
Completed writing zeroblks thread 1 seq 688

*** 2013-05-23 09:39:45.922
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 42Kb in 0.76s => 0.05 Mb/sec
Longest record: 9Kb, moves: 0/128 (0%)
Change moves: 3/92 (3%), moved: 0Mb
Longest LWN: 10Kb, moves: 0/47 (0%), moved: 0Mb
Last redo scn: 0x0000.00f8721b (16282139)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
WARNING! Crash recovery of thread 1 seq 688 is
ending at redo block 19976 but should not have ended before
redo block 19986
Incident 115372 created, dump file: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_115372\orcl_ora_5732_i115372.trc
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [688], [19976], [19986], [], [], [], [], [], [], []


*** 2013-05-23 09:39:47.546
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [688], [19976], [19986], [], [], [], [], [], [], []

*** 2013-05-23 09:39:48.195
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [688], [19976], [19986], [], [], [], [], [], [], []


以上是 orcl_ora_5732.trc



SQL> select * from v$logfile
  2  ;

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
-------------------------------------------------

IS_
---
         3         ONLINE
D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
NO

         2         ONLINE
D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
NO

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
-------------------------------------------------

IS_
---

         1         ONLINE
D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
NO


SQL> startup mount
ORACLE 例程已经启动。

Total System Global Area  843456512 bytes
Fixed Size                  2180424 bytes
Variable Size             624954040 bytes
Database Buffers          209715200 bytes
Redo Buffers                6606848 bytes
数据库装载完毕。
SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01139: RESETLOGS 选项仅在不完全数据库恢复后有效

SQL> recover database using backup controlfile until cancel;
ORA-00279: 更改 16302140 (在 04/22/2013 10:19:03 生成) 对于线程 1 是必需的
ORA-00289: 建议:
D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_05_23\O1_MF_1_688_

%U_.ARC
ORA-00280: 更改 16302140 (用于线程 1) 在序列 #688 中


指定日志: {<RET>=suggested | filename | AUTO | CANCEL}


谢谢大家,我的问题解决了,是这样操作的
1.startup mount;
2.alter database open resetlogs;
3.recover database using backup controlfile until cancel ;
输入cancel
提示:介质修复完成
4.shutdown immediate
5.startup
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-12-29 20:56 , Processed in 0.049084 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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