马上注册,结交更多数据大咖,获取更多知识干货,轻松玩转大数据
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
各位大神:
我的Oracle 数据库,磁盘空间满了, 我清理了一下,数据库无法open。
下面是具体报错,急救急救!!!!
SQL> startup
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>
日志:
Mon Sep 8 01:56:58 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 83886080
large_pool_size = 16777216
java_pool_size = 83886080
control_files = /data/oracle/oradata/wzxxgk/control01.ctl, /data/oracle/oradata/wzxxgk/control02.ctl, /data/oracle/oradata/wzxxgk/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = location=/data/oracle/product/9.2/dbs/arch
log_archive_format = %%oracle_sid%%_%t_%s.arc
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = wzxxgk
dispatchers = (PROTOCOL=TCP) (SERVICE=wzxxgkXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /data/oracle/admin/wzxxgk/bdump
user_dump_dest = /data/oracle/admin/wzxxgk/udump
core_dump_dest = /data/oracle/admin/wzxxgk/cdump
sort_area_size = 524288
db_name = wzxxgk
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Mon Sep 8 01:56:59 2014
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
Mon Sep 8 01:56:59 2014
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Sep 8 01:56:59 2014
ARC1: Archival started
ARC1: Thread not mounted
Mon Sep 8 01:56:59 2014
ARC0: Thread not mounted
Mon Sep 8 01:56:59 2014
ALTER DATABASE MOUNT
Mon Sep 8 01:57:03 2014
Successful mount of redo thread 1, with mount id 3589926827.
Mon Sep 8 01:57:03 2014
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Sep 8 01:57:03 2014
ALTER DATABASE OPEN
Mon Sep 8 01:57:03 2014
Beginning crash recovery of 1 threads
Mon Sep 8 01:57:03 2014
Started first pass scan
Mon Sep 8 01:57:03 2014
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Mon Sep 8 01:57:03 2014
Started recovery at
Thread 1: logseq 22232, block 2, scn 1.2079733803
Recovery of Online Redo Log: Thread 1 Group 1 Seq 22232 Reading mem 0
Mem# 0 errs 0: /data/oracle/oradata/wzxxgk/redo01.log
Mon Sep 8 01:57:03 2014
Completed redo application
Mon Sep 8 01:57:03 2014
Ended recovery at
Thread 1: logseq 22232, block 3, scn 1.2079753804
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Mon Sep 8 01:57:03 2014
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 22233
Thread 1 opened at log sequence 22233
Current log# 3 seq# 22233 mem# 0: /data/oracle/oradata/wzxxgk/redo03.log
Successful open of redo thread 1.
Mon Sep 8 01:57:03 2014
SMON: enabling cache recovery
Mon Sep 8 01:57:03 2014
ARC0: Evaluating archive log 1 thread 1 sequence 22232
ARC0: Beginning to archive log 1 thread 1 sequence 22232
Creating archive destination LOG_ARCHIVE_DEST_1: '/data/oracle/product/9.2/dbs/arch1racle_sid%_1_22232.arc'
ARC0: Completed archiving log 1 thread 1 sequence 22232
Mon Sep 8 01:57:03 2014
Errors in file /data/oracle/admin/wzxxgk/udump/wzxxgk_ora_25905.trc:
ORA-00600: internal error code, arguments: [4042], [6], [], [], [], [], [], []
Mon Sep 8 01:57:04 2014
Errors in file /data/oracle/admin/wzxxgk/udump/wzxxgk_ora_25905.trc:
ORA-00600: internal error code, arguments: [4042], [6], [], [], [], [], [], []
Mon Sep 8 01:57:04 2014
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 25905
ORA-1092 signalled during: ALTER DATABASE OPEN...
楼主热帖