- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-14 18:22:18
|
查看: 1337 |
回复: 1
各位好,测试库坏了,需要请教各位:
1、Windows上安装的oracle 10.2 ,非归档模式
2、听别人说的重做过一次控制文件
3、startup;
报错ORA-01113 文件1需要介质恢复,ORA-01110 数据文件1'system01.dbf'
然后我做了RECOVER DATABASE
4、然后我alter database open
报错ORA-01092 实例终止,强制断开连接。
5、以下是警告文件内容:
Wed Jun 26 16:30:35 2013
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Wed Jun 26 16:30:35 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
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.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 268435456
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILECUSTOMER.ORA
sga_target = 5100273664
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 4781506560
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_resetlogs_corruption= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS2
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=customerXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\CDUMP
db_name = customer
open_cursors = 300
pga_aggregate_target = 1696595968
PMON started with pid=2, OS id=4164
PSP0 started with pid=3, OS id=4108
MMAN started with pid=4, OS id=5352
DBW0 started with pid=5, OS id=5020
LGWR started with pid=6, OS id=5180
CKPT started with pid=7, OS id=4700
SMON started with pid=8, OS id=4684
RECO started with pid=9, OS id=5576
CJQ0 started with pid=10, OS id=5100
MMON started with pid=11, OS id=5588
MMNL started with pid=12, OS id=6072
Wed Jun 26 16:30:36 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jun 26 16:30:36 2013
ALTER DATABASE MOUNT
Wed Jun 26 16:30:40 2013
Setting recovery target incarnation to 11
Wed Jun 26 16:30:40 2013
Successful mount of redo thread 1, with mount id 222883372
Wed Jun 26 16:30:40 2013
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Jun 26 16:30:40 2013
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Wed Jun 26 16:32:29 2013
ALTER DATABASE RECOVER database
Wed Jun 26 16:32:29 2013
Media Recovery Start
parallel recovery started with 7 processes
Wed Jun 26 16:32:30 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\REDO03.LOG
Completed: ALTER DATABASE RECOVER database
Wed Jun 26 16:33:09 2013
alter database open
Wed Jun 26 16:33:09 2013
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Wed Jun 26 16:33:10 2013
Started redo scan
Wed Jun 26 16:33:10 2013
Completed redo scan
3 redo blocks read, 0 data blocks need recovery
Wed Jun 26 16:33:10 2013
Started redo application at
Thread 1: logseq 3, block 2, scn 232409476795
Wed Jun 26 16:33:10 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\REDO03.LOG
Wed Jun 26 16:33:10 2013
Completed redo application
Wed Jun 26 16:33:10 2013
Completed crash recovery at
Thread 1: logseq 3, block 5, scn 232409496800
0 data blocks read, 0 data blocks written, 3 redo blocks read
Wed Jun 26 16:33:11 2013
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=23, OS id=5668
Wed Jun 26 16:33:11 2013
ARC0: Archival started
ARC1 started with pid=24, OS id=4268
Wed Jun 26 16:33:11 2013
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 4
Thread 1 opened at log sequence 4
Wed Jun 26 16:33:11 2013
ARC0: STARTING ARCH PROCESSES
Wed Jun 26 16:33:11 2013
Current log# 2 seq# 4 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\REDO02.LOG
Wed Jun 26 16:33:11 2013
ARC1: Becoming the 'no FAL' ARCH
Wed Jun 26 16:33:11 2013
Successful open of redo thread 1
Wed Jun 26 16:33:11 2013
ARC1: Becoming the 'no SRL' ARCH
Wed Jun 26 16:33:11 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jun 26 16:33:11 2013
ARC2: Archival started
ARC2 started with pid=25, OS id=5368
Wed Jun 26 16:33:11 2013
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Wed Jun 26 16:33:11 2013
SMON: enabling cache recovery
Wed Jun 26 16:33:11 2013
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\udump\customer_ora_4500.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08103: 对象不再存在
Wed Jun 26 16:33:12 2013
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_psp0_4108.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_lgwr_5180.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_pmon_4164.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_dbw0_5020.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_ckpt_4700.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:13 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_reco_5576.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:13 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_smon_4684.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:14 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_mman_5352.trc:
ORA-00604: error occurred at recursive SQL level
Instance terminated by USER, pid = 4500
ORA-1092 signalled during: alter database open...
------------------------------
有报错也不知道是什么问题,怎么解决,求各位帮助!有追问我会补充,谢谢! |
|