- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
2#
发表于 2017-4-15 22:01:46
10g没有sysasm
alert_+ASM.log 信息:
Tue Apr 10 04:05:46 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/10.2.0/asm/dbs/arch
Autotune of undo retention is turned off.
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:
large_pool_size = 12582912
instance_type = asm
remote_login_passwordfile= SHARED
background_dump_dest = /u01/app/oracle/admin/+ASM/bdump
user_dump_dest = /u01/app/oracle/admin/+ASM/udump
core_dump_dest = /u01/app/oracle/admin/+ASM/cdump
asm_diskgroups = MPDB_DG, FRA_DG
PMON started with pid=2, OS id=303540
PSP0 started with pid=3, OS id=463302
MMAN started with pid=4, OS id=356488
DBW0 started with pid=5, OS id=430214
LGWR started with pid=6, OS id=229818
CKPT started with pid=7, OS id=409788
SMON started with pid=8, OS id=471306
RBAL started with pid=9, OS id=315558
GMON started with pid=10, OS id=340198
Tue Apr 10 04:05:47 2012
SQL> ALTER DISKGROUP ALL MOUNT
Tue Apr 10 04:05:47 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf56e88
NOTE: cache registered group MPDB_DG number=2 incarn=0xee456e89
Tue Apr 10 04:05:48 2012
NOTE: Hbeat: instance first (grp 1)
Tue Apr 10 04:05:48 2012
NOTE: Hbeat: instance first (grp 2)
Tue Apr 10 04:05:52 2012
NOTE: start heartbeating (grp 1)
NOTE: cache opening disk 0 of grp 1: FRA_DG_0000 path:/dev/rhdisk10
Tue Apr 10 04:05:52 2012
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: FRA_DG_0001 path:/dev/rhdisk11
NOTE: F1X0 found on disk 1 fcn 0.0
NOTE: cache mounting (first) group 1/0xEDF56E88 (FRA_DG)
NOTE: cache recovered group 1 to fcn 0.35151
Tue Apr 10 04:05:52 2012
NOTE: opening chunk 1 at fcn 0.35151 ABA
NOTE: seq=128 blk=8189
Tue Apr 10 04:05:52 2012
NOTE: cache mounting group 1/0xEDF56E88 (FRA_DG) succeeded
SUCCESS: diskgroup FRA_DG was mounted
Tue Apr 10 04:05:52 2012
NOTE: start heartbeating (grp 2)
NOTE: cache opening disk 0 of grp 2: MPDB_DG_0000 path:/dev/rhdisk19
Tue Apr 10 04:05:52 2012
NOTE: F1X0 found on disk 0 fcn 0.17049
NOTE: cache opening disk 1 of grp 2: MPDB_DG_0001 path:/dev/rhdisk2
NOTE: cache mounting (first) group 2/0xEE456E89 (MPDB_DG)
NOTE: cache recovered group 2 to fcn 0.3049335
Tue Apr 10 04:05:52 2012
NOTE: opening chunk 1 at fcn 0.3049335 ABA
NOTE: seq=187 blk=10711
Tue Apr 10 04:05:52 2012
NOTE: cache mounting group 2/0xEE456E89 (MPDB_DG) succeeded
SUCCESS: diskgroup MPDB_DG was mounted
Starting background process ASMB
Tue Apr 10 04:05:53 2012
NOTE: recovering COD for group 1/0xedf56e88 (FRA_DG)
SUCCESS: completed COD recovery for group 1/0xedf56e88 (FRA_DG)
NOTE: recovering COD for group 2/0xee456e89 (MPDB_DG)
SUCCESS: completed COD recovery for group 2/0xee456e89 (MPDB_DG)
ASMB started with pid=12, OS id=307376
Tue Apr 10 04:06:14 2012
Starting ORACLE instance (normal)
Tue Apr 10 04:09:12 2012
NOTE: ASMB process exiting due to lack of ASM file activity
Wed Apr 25 13:28:59 2012
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Autotune of undo retention is turned off.
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.4.0.
System parameters with non-default values:
large_pool_size = 12582912
instance_type = asm
remote_login_passwordfile= SHARED
background_dump_dest = /u01/app/oracle/admin/+ASM/bdump
user_dump_dest = /u01/app/oracle/admin/+ASM/udump
core_dump_dest = /u01/app/oracle/admin/+ASM/cdump
asm_diskgroups = FRA_DG
PMON started with pid=2, OS id=868716
PSP0 started with pid=3, OS id=987308
MMAN started with pid=4, OS id=864604
DBW0 started with pid=5, OS id=860500
LGWR started with pid=6, OS id=983228
CKPT started with pid=7, OS id=958652
SMON started with pid=8, OS id=893264
RBAL started with pid=9, OS id=856400
GMON started with pid=10, OS id=852306
Wed Apr 25 13:29:00 2012
SQL> ALTER DISKGROUP ALL MOUNT
Wed Apr 25 13:29:00 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf288c3
Wed Apr 25 13:29:00 2012
NOTE: Hbeat: instance first (grp 1)
Wed Apr 25 13:29:05 2012
ERROR: PST found another heartbeat (grp 1)
Wed Apr 25 13:29:05 2012
NOTE: cache dismounting group 1/0xEDF288C3 (FRA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup FRA_DG was not mounted
Mon Sep 3 18:00:11 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK
'/dev/rhdisk21'
REBALANCE POWER 5 WAIT
Mon Sep 3 18:01:19 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK
'/dev/rhdisk21'
REBALANCE POWER 5 WAIT
Mon Sep 3 18:12:52 2012
alter database mount
Mon Sep 3 18:12:52 2012
ORA-15000 signalled during: alter database mount...
Mon Sep 3 18:12:58 2012
Starting ORACLE instance (normal)
Mon Sep 3 18:18:21 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK
'/dev/rhdisk21'
REBALANCE POWER 5 WAIT
Tue Sep 4 09:09:21 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK
'/dev/rhdisk21'
REBALANCE POWER 5 WAIT
Tue Sep 4 09:36:21 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK
'/dev/rhdisk21'
REBALANCE POWER 5 WAIT
Tue Sep 4 09:56:06 2012
SQL> ALTER DISKGROUP ALL MOUNT
Tue Sep 4 09:56:07 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf28942
Tue Sep 4 09:56:08 2012
NOTE: Hbeat: instance first (grp 1)
Tue Sep 4 09:56:12 2012
ERROR: PST found another heartbeat (grp 1)
Tue Sep 4 09:56:12 2012
NOTE: cache dismounting group 1/0xEDF28942 (FRA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup FRA_DG was not mounted
Tue Sep 4 10:46:30 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK '/dev/rhdisk21' REBALANCE POWER 5 WAIT
Tue Sep 4 10:47:18 2012
SQL> ALTER DISKGROUP MPDB_DG drop DISK '/dev/rhdisk21'
Tue Sep 4 10:49:33 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK '/dev/rhdisk21' REBALANCE POWER 5 WAIT
Tue Sep 4 10:50:24 2012
SQL> ALTER DISKGROUP ALL MOUNT
Tue Sep 4 10:50:24 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf28958
Tue Sep 4 10:50:24 2012
NOTE: Hbeat: instance first (grp 1)
Tue Sep 4 10:50:29 2012
ERROR: PST found another heartbeat (grp 1)
Tue Sep 4 10:50:29 2012
NOTE: cache dismounting group 1/0xEDF28958 (FRA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup FRA_DG was not mounted
Tue Sep 4 10:51:45 2012
SQL> ALTER DISKGROUP MPDB_DG MOUNT
Tue Sep 4 10:51:45 2012
NOTE: cache registered group MPDB_DG number=2 incarn=0xee42895c
Tue Sep 4 10:51:45 2012
NOTE: Hbeat: instance first (grp 2)
Tue Sep 4 10:51:50 2012
ERROR: PST found another heartbeat (grp 2)
Tue Sep 4 10:51:50 2012
NOTE: cache dismounting group 2/0xEE42895C (MPDB_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup MPDB_DG was not mounted
Tue Sep 4 14:13:46 2012
SQL> ALTER DISKGROUP MPDB_DG ADD DISK '/dev/rhdisk21' REBALANCE POWER 5 WAIT
Tue Sep 4 15:37:26 2012
SQL> alter diskgroup all mount
Tue Sep 4 15:37:26 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf2898b
Tue Sep 4 15:37:26 2012
NOTE: Hbeat: instance first (grp 1)
Tue Sep 4 15:37:30 2012
ERROR: PST found another heartbeat (grp 1)
Tue Sep 4 15:37:30 2012
NOTE: cache dismounting group 1/0xEDF2898B (FRA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup FRA_DG was not mounted
Tue Sep 4 16:04:34 2012
SQL> alter diskgroup all mount
Tue Sep 4 16:04:34 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf28995
Tue Sep 4 16:04:35 2012
NOTE: Hbeat: instance first (grp 1)
Tue Sep 4 16:04:39 2012
ERROR: PST found another heartbeat (grp 1)
Tue Sep 4 16:04:39 2012
NOTE: cache dismounting group 1/0xEDF28995 (FRA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup FRA_DG was not mounted
Tue Sep 4 16:25:28 2012
SQL> create diskgroup MPDB_DG_EXT External redundancy disk '/dev/rhdisk21'
Tue Sep 4 16:27:50 2012
NOTE: initializing header on grp 1 disk MPDB_DG_EXT_0000
Tue Sep 4 16:27:50 2012
NOTE: PST update: grp = 1
Tue Sep 4 16:27:50 2012
NOTE: group MPDB_DG_EXT: initial PST locations: disk 0000 (PST copy 0)
Tue Sep 4 16:27:50 2012
NOTE: cache registered group MPDB_DG_EXT number=1 incarn=0x0932899f
NOTE: cache opening disk 0 of grp 1: MPDB_DG_EXT_0000 path:/dev/rhdisk21
NOTE: cache creating group 1/0x0932899F (MPDB_DG_EXT)
NOTE: cache mounting group 1/0x0932899F (MPDB_DG_EXT) succeeded
NOTE: allocating F1X0 on grp 1 disk MPDB_DG_EXT_0000
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting group 1/0x0932899F (MPDB_DG_EXT)
SUCCESS: diskgroup MPDB_DG_EXT was created
NOTE: cache registered group MPDB_DG_EXT number=1 incarn=0x193289a6
Tue Sep 4 16:27:53 2012
NOTE: Hbeat: instance first (grp 1)
Tue Sep 4 16:27:57 2012
NOTE: start heartbeating (grp 1)
NOTE: cache opening disk 0 of grp 1: MPDB_DG_EXT_0000 path:/dev/rhdisk21
Tue Sep 4 16:27:57 2012
NOTE: F1X0 found on disk 0 fcn 0.0
|
|