oracle 断电无法启动
环境 win7 11gr2Thu 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: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
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=
Aborting crash recovery due to error 600
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5732.trc:
ORA-00600: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5732.trc:
ORA-00600: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Thu May 23 09:40:37 2013
Sweep : completed
Sweep : 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: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
*** 2013-05-23 09:39:47.546
ORA-00600: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
*** 2013-05-23 09:39:48.195
ORA-00600: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
以上是 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
页:
[1]