Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1168374
  • 博文数量: 178
  • 博客积分: 2776
  • 博客等级: 少校
  • 技术积分: 2809
  • 用 户 组: 普通用户
  • 注册时间: 2012-03-22 15:36
文章分类

全部博文(178)

文章存档

2014年(3)

2013年(66)

2012年(109)

分类: Oracle

2013-01-08 16:18:42

System altered.

 

SQL> startup force;

ORACLE instance started.

 

INST 2:

SQL> shutdown abort

ORACLE instance shut down.

 

=============================================================

========================alert.log============================本文转自CUUG网。

 

Reconfiguration started (old inc 4, new inc 6)

List of instances:

 1 (myinst: 1)

 Global Resource Directory frozen

 * dead instance detected - domain 0 invalid = TRUE

 Communication channels reestablished

 Master broadcasted resource hash value bitmaps

 Non-local Process blocks cleaned out

 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived

 Set master node info

 Submitted all remote-enqueue requests

 Dwn-cvts replayed, VALBLKs dubious

 All grantable enqueues granted

 Post SMON to start 1st pass IR

Instance recovery: looking for dead threads

Beginning instance recovery of 1 threads

 parallel recovery started with 2 processes                 --2 recovery slave

 Submitted all GCS remote-cache requests

 Post SMON to start 1st pass IR

 Fix write in gcs resources

Reconfiguration complete

Started redo scan

Completed redo scan

 read 88 KB redo, 82 data blocks need recovery

Started redo application at

 Thread 2: logseq 374, block 2, scn 54624376

Recovery of Online Redo Log: Thread 2 Group 4 Seq 374 Reading mem 0

  Mem# 0: +DATA/prod/onlinelog/group_4.271.747100549

  Mem# 1: +DATA/prod/onlinelog/group_4.272.747100553

Completed redo application of 0.07MB

Completed instance recovery at

 Thread 2: logseq 374, block 178, scn 54646382

 73 data blocks read, 83 data blocks written, 88 redo k-bytes read

Thread 2 advanced to log sequence 375 (thread recovery)

Redo thread 2 internally disabled at seq 375 (SMON)

ARC3: Creating local archive destination LOG_ARCHIVE_DEST_1: '/s01/arch/2_374_747100216.dbf' (thread 2 sequence 374) (PROD1)


Setting Resource Manager plan SCHEDULER[0x310B]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

ARC3: Closing local archive destination LOG_ARCHIVE_DEST_1: '/s01/arch/2_374_747100216.dbf' (PROD1)

2011-06-27 22:19:29.280000 +08:00

Archived Log entry 792 added for thread 2 sequence 374 ID 0x9790ab2 dest 1:

ARC0: Creating local archive destination LOG_ARCHIVE_DEST_1: '/s01/arch/2_375_747100216.dbf' (thread 2 sequence 375) (PROD1)

2011-06-27 22:19:30.336000 +08:00

ARC0: Archiving disabled thread 2 sequence 375

ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/s01/arch/2_375_747100216.dbf' (PROD1)

Archived Log entry 793 added for thread 2 sequence 375 ID 0x9790ab2 dest 1:

minact-scn: Master considers inst:2 dead

 

==================================================================

===========================smon trace begin=======================

阅读(4067) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~