- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
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' |
|