Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 22:01:29 | 查看: 2964| 回复: 2

数据库目前运行正常,往asm磁盘组添加磁盘报错,asm、oracle实例日志中没有相关警告信息,谁能帮忙看看,谢谢~~~~~~~~~~~

export ORACLE_SID=+ASM
sqlplus /nolog
SQL>conn / as sysdba

SQL> select name,state from v$asm_diskgroup;
NAME                 STATE
-------------------- ----------------------
FRA_DG               DISMOUNTED
MPDB_DG              DISMOUNTED
SQL> ALTER DISKGROUP MPDB_DG ADD DISK '/dev/rhdisk21' REBALANCE POWER 5 WAIT;
ALTER DISKGROUP MPDB_DG ADD DISK '/dev/rhdisk21' REBALANCE POWER 5 WAIT
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15001: diskgroup "MPDB_DG" does not exist or is not mounted

SQL> ALTER DISKGROUP ALL MOUNT;
ALTER DISKGROUP ALL MOUNT
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15003: diskgroup "FRA_DG" already mounted in another lock name space

SQL> ALTER DISKGROUP MPDB_DG MOUNT FROCE;
ALTER DISKGROUP MPDB_DG MOUNT FROCE
                              *
ERROR at line 1:
ORA-00905: missing keyword

SQL> ALTER DISKGROUP MPDB_DG MOUNT;      
ALTER DISKGROUP MPDB_DG MOUNT
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15003: diskgroup "MPDB_DG" already mounted in another lock name space

bash-3.2$ export ORACLE_SID=mpdb
bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 4 13:40:44 2012
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name, state from v$asm_diskgroup;
NAME                           STATE
------------------------------ -----------
FRA_DG                         CONNECTED
MPDB_DG                        CONNECTED




oracle实例显示正常,asm实例好像不太正常

bash-3.2$ export ORACLE_SID=mpdb
bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 4 13:40:44 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name, state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
FRA_DG                         CONNECTED
MPDB_DG                        CONNECTED

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
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

回复 只看该作者 道具 举报

3#
发表于 2017-4-15 22:02:09
NOTE: cache mounting (first) group 1/0x193289A6 (MPDB_DG_EXT)
NOTE: cache recovered group 1 to fcn 0.0
Tue Sep  4 16:27:57 2012
NOTE: opening chunk 1 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Tue Sep  4 16:27:57 2012
NOTE: cache mounting group 1/0x193289A6 (MPDB_DG_EXT) succeeded
SUCCESS: diskgroup MPDB_DG_EXT was mounted
Tue Sep  4 16:27:58 2012
NOTE: recovering COD for group 1/0x193289a6 (MPDB_DG_EXT)
SUCCESS: completed COD recovery for group 1/0x193289a6 (MPDB_DG_EXT)
Tue Sep  4 16:31:16 2012
SQL> alter diskgroup MPDB_DG_EXT dismount
Tue Sep  4 16:31:16 2012
NOTE: cache dismounting group 1/0x193289A6 (MPDB_DG_EXT)
SUCCESS: diskgroup MPDB_DG_EXT was dismounted
Tue Sep  4 16:32:05 2012
SQL> drop diskgroup MPDB_DG_EXT
Tue Sep  4 16:32:37 2012
SQL> alter diskgroup MPDB_DG_EXT mount
Tue Sep  4 16:32:37 2012
NOTE: cache registered group MPDB_DG_EXT number=1 incarn=0x096289b7
Tue Sep  4 16:32:37 2012
NOTE: Hbeat: instance first (grp 1)
Tue Sep  4 16:32:41 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:32:41 2012
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache mounting (first) group 1/0x096289B7 (MPDB_DG_EXT)
NOTE: cache recovered group 1 to fcn 0.4
Tue Sep  4 16:32:41 2012
NOTE: opening chunk 1 at fcn 0.4 ABA
NOTE: seq=3 blk=2
Tue Sep  4 16:32:41 2012
NOTE: cache mounting group 1/0x096289B7 (MPDB_DG_EXT) succeeded
SUCCESS: diskgroup MPDB_DG_EXT was mounted
Tue Sep  4 16:32:43 2012
NOTE: recovering COD for group 1/0x96289b7 (MPDB_DG_EXT)
SUCCESS: completed COD recovery for group 1/0x96289b7 (MPDB_DG_EXT)
Tue Sep  4 16:32:50 2012
SQL> drop diskgroup MPDB_DG_EXT
Tue Sep  4 16:32:50 2012
NOTE: cache dismounting group 1/0x096289B7 (MPDB_DG_EXT)
NOTE: erasing header on grp 1 disk MPDB_DG_EXT_0000
SUCCESS: diskgroup MPDB_DG_EXT was dropped
Wed Sep  5 10:08:53 2012
SQL> alter diskgroup all mount
Wed Sep  5 10:08:53 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf289d0
Wed Sep  5 10:08:53 2012
NOTE: Hbeat: instance first (grp 1)
Wed Sep  5 10:08:57 2012
ERROR: PST found another heartbeat (grp 1)
Wed Sep  5 10:08:57 2012
NOTE: cache dismounting group 1/0xEDF289D0 (FRA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup FRA_DG was not mounted
Wed Sep  5 13:55:02 2012
SQL> alter diskgroup fra_dg mount
Wed Sep  5 13:55:03 2012
NOTE: cache registered group FRA_DG number=1 incarn=0xedf289e9
Wed Sep  5 13:55:03 2012
NOTE: Hbeat: instance first (grp 1)
Wed Sep  5 13:55:07 2012
ERROR: PST found another heartbeat (grp 1)
Wed Sep  5 13:55:07 2012
NOTE: cache dismounting group 1/0xEDF289E9 (FRA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup FRA_DG was not mounted



asm磁盘磁头信息已经混乱,没有备份,哪位大侠支个招???


求救。。。。。。万一宕机老板会活剐了我。。。。。啊啊啊

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 19:00 , Processed in 0.047231 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569