oracle partly available,回滚段状态为PARTLY AVAILABLE,该如何处理?

Sun Oct 16 12:06:47 2005

alter database mount

Sun Oct 16 12:06:47 2005

ORA-00202: controlfile: '/data/data02/oradata/neva2dev/control01.ctl'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Sun Oct 16 12:06:50 2005

ORA-205 signalled during: alter database mount

...

Sun Oct 16 12:07:03 2005

Shutting down instance: further logons disabled

Shutting down instance (immediate)

License high water mark = 3

Sun Oct 16 12:07:04 2005

ALTER DATABASE CLOSE NORMAL

ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...

ARCH: Archiving is disabled

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archiving is disabled

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Sun Oct 16 12:07:11 2005

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.1.0.

System parameters with non-default values:

processes                = 150

timed_statistics         = TRUE

shared_pool_size         = 50331648

large_pool_size          = 8388608

java_pool_size           = 33554432

control_files            = /data/data02/oradata/neva2dev/control01.ctl, /data/

data02/oradata/neva2dev/control02.ctl

db_block_size            = 8192

db_cache_size            = 25165824

compatible               = 9.2.0.0.0

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

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = /opt/oracle/admin/neva2dev/bdump

user_dump_dest           = /opt/oracle/admin/neva2dev/udump

core_dump_dest           = /opt/oracle/admin/neva2dev/cdump

sort_area_size           = 524288

db_name                  = neva2dev

open_cursors             = 300

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 268435456

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

Sun Oct 16 12:07:11 2005

ALTER DATABASE   MOUNT

Sun Oct 16 12:07:11 2005

ORA-00202: controlfile: '/data/data02/oradata/neva2dev/control01.ctl'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Sun Oct 16 12:07:11 2005

ORA-205 signalled during: ALTER DATABASE   MOUNT...

Sun Oct 16 12:24:19 2005

Shutting down instance: further logons disabled

Shutting down instance (immediate)

License high water mark = 3

Sun Oct 16 12:24:19 2005

ALTER DATABASE CLOSE NORMAL

ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...

ARCH: Archiving is disabled

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archiving is disabled

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Sun Oct 16 12:41:00 2005

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.1.0.

System parameters with non-default values:

processes                = 150

timed_statistics         = TRUE

shared_pool_size         = 50331648

large_pool_size          = 8388608

java_pool_size           = 33554432

control_files            = /data/data02/oradata/neva2dev/control01.ctl, /data/

data02/oradata/neva2dev/control02.ctl

db_block_size            = 8192

db_cache_size            = 25165824

compatible               = 9.2.0.0.0

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

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = /opt/oracle/admin/neva2dev/bdump

user_dump_dest           = /opt/oracle/admin/neva2dev/udump

core_dump_dest           = /opt/oracle/admin/neva2dev/cdump

sort_area_size           = 524288

db_name                  = neva2dev

open_cursors             = 300

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 268435456

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

Sun Oct 16 12:41:01 2005

ALTER DATABASE   MOUNT

Sun Oct 16 12:41:05 2005

Successful mount of redo thread 1, with mount id 3328332125.

Sun Oct 16 12:41:05 2005

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE   MOUNT

Sun Oct 16 12:41:05 2005

ALTER DATABASE OPEN

Sun Oct 16 12:41:05 2005

Beginning crash recovery of 1 threads

Sun Oct 16 12:41:05 2005

Started first pass scan

Sun Oct 16 12:41:09 2005

Completed first pass scan

293334 redo blocks read, 1327 data blocks need recovery

Sun Oct 16 12:41:09 2005

Started recovery at

Thread 1: logseq 1081, block 2, scn 0.164178338

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

Mem# 0 errs 0: /data/data02/oradata/neva2dev/redo0101.log

Recovery of Online Redo Log: Thread 1 Group 2 Seq 1082 Reading mem 0

Mem# 0 errs 0: /data/data02/oradata/neva2dev/redo0201.log

Sun Oct 16 12:41:24 2005

Ended recovery at

Thread 1: logseq 1082, block 88539, scn 0.164524474

1327 data blocks read, 1327 data blocks written, 293334 redo blocks read

Crash recovery completed successfully

Sun Oct 16 12:41:24 2005

Thread 1 advanced to log sequence 1083

Thread 1 opened at log sequence 1083

Current log# 3 seq# 1083 mem# 0: /data/data02/oradata/neva2dev/redo0301.log

Successful open of redo thread 1.

Sun Oct 16 12:41:24 2005

SMON: enabling cache recovery

Sun Oct 16 12:41:25 2005

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Sun Oct 16 12:41:25 2005

SMON: enabling tx recovery

Sun Oct 16 12:41:25 2005

Database Characterset is ZHS16GBK

Sun Oct 16 12:41:25 2005

SMON: about to recover undo segment 23

SMON: mark undo segment 23 as available

SMON: about to recover undo segment 27

SMON: mark undo segment 27 as available

SMON: about to recover undo segment 42

SMON: mark undo segment 42 as available

SMON: about to recover undo segment 44

SMON: mark undo segment 44 as available

SMON: about to recover undo segment 50

SMON: mark undo segment 50 as available

SMON: about to recover undo segment 55

SMON: mark undo segment 55 as available

SMON: about to recover undo segment 69

SMON: mark undo segment 69 as available

SMON: about to recover undo segment 23

SMON: mark undo segment 23 as available

SMON: about to recover undo segment 27

SMON: mark undo segment 27 as available

SMON: about to recover undo segment 42

SMON: mark undo segment 42 as available

SMON: about to recover undo segment 44

SMON: mark undo segment 44 as available

SMON: about to recover undo segment 50

SMON: mark undo segment 50 as available

SMON: about to recover undo segment 55

SMON: mark undo segment 55 as available

SMON: about to recover undo segment 69

SMON: mark undo segment 69 as available

Sun Oct 16 12:41:27 2005

replication_dependency_tracking turned off (no async multimaster replication fou

nd)

Completed: ALTER DATABASE OPEN

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值