oracle控制文件不一致,控制文件的信息和数据文件不一致是什么原因

alter.log 信息如下

create tablespace test datafile 'd:\test' 10M

Completed: create tablespace test datafile 'd:\test'

Wed Jun 30 22:08:42 2010

alter database backup controlfile to 'd:\ctlctl'

Wed Jun 30 22:08:43 2010

Completed: alter database backup controlfile to 'd:\ctlctl'

Wed Jun 30 22:09:13 2010

drop tablespace test

Wed Jun 30 22:09:14 2010

Completed: drop tablespace test

Wed Jun 30 22:10:01 2010

Shutting down instance (abort)

License high water mark = 2

Instance terminated by USER, pid = 2584

Wed Jun 30 22:10:16 2010

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

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       = 113246208

__large_pool_size        = 4194304

__java_pool_size         = 4194304

__streams_pool_size      = 0

sga_target               = 289406976

control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\CONTROL03.CTL

db_block_size            = 8192

__db_cache_size          = 163577856

compatible               = 10.2.0.1.0

log_archive_dest_1       = location=E:\oracle\product\10.2.0\archive_log_test

db_file_multiblock_read_count= 16

db_recovery_file_dest    = E:\oracle\product\10.2.0/flash_recovery_area

db_recovery_file_dest_size= 2147483648

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain                =

dispatchers              = (PROTOCOL=TCP) (SERVICE=testXDB)

job_queue_processes      = 10

audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\ADMIN\TEST\ADUMP

background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\ADMIN\TEST\BDUMP

user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\ADMIN\TEST\UDUMP

core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\ADMIN\TEST\CDUMP

db_name                  = test

open_cursors             = 300

pga_aggregate_target     = 95420416

PMON started with pid=2, OS id=2892

PSP0 started with pid=3, OS id=608

MMAN started with pid=4, OS id=3904

DBW0 started with pid=5, OS id=180

LGWR started with pid=6, OS id=1076

CKPT started with pid=7, OS id=2512

SMON started with pid=8, OS id=1696

RECO started with pid=9, OS id=3360

CJQ0 started with pid=10, OS id=1864

MMON started with pid=11, OS id=3716

Wed Jun 30 22:10:17 2010

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Wed Jun 30 22:10:17 2010

starting up 1 shared server(s) ...

Wed Jun 30 22:10:17 2010

ALTER DATABASE   MOUNT

MMNL started with pid=12, OS id=1840

Wed Jun 30 22:10:21 2010

Setting recovery target incarnation to 1

Wed Jun 30 22:10:21 2010

Successful mount of redo thread 1, with mount id 2021223497

Wed Jun 30 22:10:21 2010

Database mounted in Exclusive Mode

Completed: ALTER DATABASE   MOUNT

Wed Jun 30 22:10:22 2010

ALTER DATABASE OPEN

Wed Jun 30 22:10:22 2010

Beginning crash recovery of 1 threads

Wed Jun 30 22:10:22 2010

Started redo scan

Wed Jun 30 22:10:23 2010

Completed redo scan

185 redo blocks read, 64 data blocks need recovery

Wed Jun 30 22:10:23 2010

Started redo application at

Thread 1: logseq 16, block 3

Wed Jun 30 22:10:23 2010

Recovery of Online Redo Log: Thread 1 Group 3 Seq 16 Reading mem 0

Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\REDO03.LOG

Wed Jun 30 22:10:24 2010

Completed redo application

Wed Jun 30 22:10:24 2010

Completed crash recovery at

Thread 1: logseq 16, block 188, scn 786324

64 data blocks read, 64 data blocks written, 185 redo blocks read

Wed Jun 30 22:10:25 2010

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=15, OS id=1220

Wed Jun 30 22:10:25 2010

ARC0: Archival started

Wed Jun 30 22:10:25 2010

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

Thread 1 advanced to log sequence 17

Thread 1 opened at log sequence 17

Current log# 1 seq# 17 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\REDO01.LOG

Successful open of redo thread 1

Wed Jun 30 22:10:25 2010

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Wed Jun 30 22:10:25 2010

ARC0: STARTING ARCH PROCESSES

Wed Jun 30 22:10:25 2010

SMON: enabling cache recovery

Wed Jun 30 22:10:25 2010

ARC2: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

ARC1 started with pid=17, OS id=3404

Wed Jun 30 22:10:26 2010

ARC1: Becoming the heartbeat ARCH

ARC2 started with pid=18, OS id=968

Wed Jun 30 22:10:28 2010

Successfully onlined Undo Tablespace 1.

Wed Jun 30 22:10:28 2010

SMON: enabling tx recovery

Wed Jun 30 22:10:28 2010

*********************************************************************

WARNING: The following temporary tablespaces contain no files.

This condition can occur when a backup controlfile has

been restored.  It may be necessary to add files to these

tablespaces.  That can be done using the SQL statement:

ALTER TABLESPACE ADD TEMPFILE

Alternatively, if these temporary tablespaces are no longer

needed, then they can be dropped.

Empty temporary tablespace: TEMP

*********************************************************************

Database Characterset is ZHS16GBK

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=19, OS id=1928

Wed Jun 30 22:10:37 2010

Completed: ALTER DATABASE OPEN

Wed Jun 30 22:10:38 2010

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 30 22:15:27 2010

Shutting down archive processes

Wed Jun 30 22:15:32 2010

ARCH shutting down

ARC2: Archival stopped

Wed Jun 30 22:16:58 2010

create tablespace test datafile 'd:\test2.dbf'

Wed Jun 30 22:16:58 2010

ORA-1119 signalled during: create tablespace test datafile 'd:\test2.dbf'...

Wed Jun 30 22:17:06 2010

create tablespace test datafile 'd:\test2.dbf' size 10M

Wed Jun 30 22:17:06 2010

Errors in file e:\oracle\product\10.2.0\admin\test\udump\test_ora_2676.trc:

ORA-00600: 内部错误代码, 参数: [25013], [0], [8], [TEST], [TEST], [6], [6], []