数据库控制文件恢复后无法启动数据案例,待各路好汉相救！
早上接到信通处某领导通知要帮忙看看一个数据库,远程到服务器上(在windows安装的) sqlplus, 数据库状态为started,执行： shutdown immediate, startup 后 报错ORA-00600: ??????, ??: , , , , [], [], [], []
, 经各方了解进行过机器重启而且数据库还没有关闭, 判断控制文件已经损坏。
从备份的控制文件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'
数据库处于非归档模式
我后来又手工重建了控制文件,但错误依旧啊
页:
[1]