offline和drop故障组

已于 2022-02-18 15:33:23 修改
阅读量2.3k 收藏
点赞数 1
分类专栏： DBA 文章标签： 数据库
于 2022-02-16 09:22:14 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hezuijiudexiaobai/article/details/122950252
版权

实验1

fast disk resync

在磁盘处于offline的这段时间里，ASM持续跟踪需要在offline磁盘上做的修改操作。
online后ASM会将这些修改操作应用到磁盘上去。

alter diskgroup ssddg offline disks in failgroup ssd01;

在这里插入图片描述

SQL> alter diskgroup ssddg offline disks in failgroup ssd01
2022-02-15T18:23:54.939962+08:00
NOTE: DRTimer CD Create:  for disk group 2 disks:

NOTE: process _user41508_+asm2 (41508) initiating offline of disk 0.4041717961 (SSDDG_0000) with mask 0x7e in group 2 (SSDDG) without client assisting
NOTE: process _user41508_+asm2 (41508) initiating offline of disk 1.4041717960 (SSDDG_0001) with mask 0x7e in group 2 (SSDDG) without client assisting
NOTE: process _user41508_+asm2 (41508) initiating offline of disk 2.4041717959 (SSDDG_0002) with mask 0x7e in group 2 (SSDDG) without client assisting
NOTE: process _user41508_+asm2 (41508) initiating offline of disk 3.4041717958 (SSDDG_0003) with mask 0x7e in group 2 (SSDDG) without client assisting
NOTE: process _user41508_+asm2 (41508) initiating offline of disk 4.4041717957 (SSDDG_0004) with mask 0x7e in group 2 (SSDDG) without client assisting
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 0/0xf0e7b8c9, mask = 0x6a, op = clear mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 1/0xf0e7b8c8, mask = 0x6a, op = clear mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 2/0xf0e7b8c7, mask = 0x6a, op = clear mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 3/0xf0e7b8c6, mask = 0x6a, op = clear mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 4/0xf0e7b8c5, mask = 0x6a, op = clear mandatory
2022-02-15T18:23:54.948651+08:00
GMON updating disk modes for group 2 at 17 for pid 34, osid 41508
cluster guid (19c825cfae34ffefff565f5a6c5c679f) generated for PST Hbeat for instance 2
cluster guid (19c825cfae34ffefff565f5a6c5c679f) generated for PST Hbeat for instance 2
cluster guid (19c825cfae34ffefff565f5a6c5c679f) generated for PST Hbeat for instance 2
cluster guid (19c825cfae34ffefff565f5a6c5c679f) generated for PST Hbeat for instance 2
cluster guid (19c825cfae34ffefff565f5a6c5c679f) generated for PST Hbeat for instance 2
ARBA started with pid=36, OS id=2373
NOTE: starting process ARB0
Starting background process ARB0
2022-02-15T18:26:16.942743+08:00
ARB0 started with pid=44, OS id=2376
NOTE: assigning ARBA to group 2/0xda874857 (SSDDG) to compute estimates
NOTE: assigning ARB0 to group 2/0xda874857 (SSDDG) with 1 parallel I/O
2022-02-15T18:26:16.980568+08:00
NOTE: Starting resync using Staleness Registry and ATE scan for group 2
2022-02-15T18:26:23.016548+08:00
NOTE: Starting resync using Staleness Registry and ATE scan for group 2
NOTE: header on disk 0 advanced to format #2 using fcn 0.0
NOTE: F1X0 on disk 0 (fmt 2) relocated at fcn 0.57089: AU 0 -> AU 2
NOTE: F1B1 fcn on disk 9 synced at fcn 0.57089
NOTE: F1B1 fcn on disk 13 synced at fcn 0.57089
2022-02-15T18:26:25.856306+08:00
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 0/0x0, mask = 0x7f, op = assign mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 1/0x0, mask = 0x7f, op = assign mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 2/0x0, mask = 0x7f, op = assign mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 3/0x0, mask = 0x7f, op = assign mandatory
NOTE: initiating PST update: grp 2 (SSDDG), dsk = 4/0x0, mask = 0x7f, op = assign mandatory
2022-02-15T18:26:25.856761+08:00
GMON updating disk modes for group 2 at 27 for pid 44, osid 2376
2022-02-15T18:26:25.879461+08:00
NOTE: PST update grp = 2 completed successfully
NOTE: reset timers for disk: 0
NOTE: reset timers for disk: 1
NOTE: reset timers for disk: 2
NOTE: reset timers for disk: 3
NOTE: reset timers for disk: 4
NOTE: completed online of disk group 2 disks
SSDDG_0000 (0)
SSDDG_0001 (1)
SSDDG_0002 (2)
SSDDG_0003 (3)
SSDDG_0004 (4)

2022-02-15T18:26:25.949483+08:00
NOTE: stopping process ARBA
NOTE: stopping process ARB0
NOTE: Starting expel slave for group 2/0xda874857 (SSDDG)
2022-02-15T18:26:25.970349+08:00
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=2
2022-02-15T18:26:25.997227+08:00
NOTE: membership refresh pending for group 2/0xda874857 (SSDDG)
2022-02-15T18:26:25.998629+08:00
GMON querying group 2 at 28 for pid 26, osid 28875
2022-02-15T18:26:26.018513+08:00
SUCCESS: refreshed membership for 2/0xda874857 (SSDDG)
2022-02-15T18:26:28.983565+08:00
SUCCESS: rebalance completed for group 2/0xda874857 (SSDDG)
NOTE: Attempting voting file refresh on diskgroup SSDDG
NOTE: Refresh completed on diskgroup SSDDG. No voting file found.

在这里插入图片描述

asmcmd online -G ssddg -a

alter diskgroup ssddg online all;

实验2

在这里插入图片描述

----------------------------------------------------------------------------Fri Feb 18 14:17:28 2022
SQL> alter diskgroup ssddg2 offline disks in failgroup qone1 
NOTE: DRTimer CD Create:  for disk group 3 disks:
 0
 2
 4
NOTE: process _user31366_+asm2 (31366) initiating offline of disk 0.3915997526 (SSDDG2_0000) with mask 0x7e in group 3
NOTE: process _user31366_+asm2 (31366) initiating offline of disk 2.3915997529 (SSDDG2_0002) with mask 0x7e in group 3
NOTE: process _user31366_+asm2 (31366) initiating offline of disk 4.3915997530 (SSDDG2_0004) with mask 0x7e in group 3
NOTE: initiating PST update: grp = 3, dsk = 0/0xe9696156, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 3, dsk = 2/0xe9696159, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 3, dsk = 4/0xe969615a, mask = 0x6a, op = clear
Fri Feb 18 14:17:28 2022
GMON updating disk modes for group 3 at 58 for pid 29, osid 31366
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: PST update grp = 3 completed successfully 
NOTE: initiating PST update: grp = 3, dsk = 0/0xe9696156, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 3, dsk = 2/0xe9696159, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 3, dsk = 4/0xe969615a, mask = 0x7e, op = clear
GMON updating disk modes for group 3 at 59 for pid 29, osid 31366
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: cache closing disk 0 of grp 3: SSDDG2_0000
NOTE: cache closing disk 2 of grp 3: SSDDG2_0002
NOTE: cache closing disk 4 of grp 3: SSDDG2_0004
NOTE: PST update grp = 3 completed successfully 
NOTE: DRTimer CD Destroy: for diskgroup 3
SUCCESS: alter diskgroup ssddg2 offline disks in failgroup qone1
-----------------------------------------------------------------Fri Feb 18 14:18:01 2022
SQL> alter diskgroup ssddg2 online disks in failgroup qone1 
Fri Feb 18 14:18:01 2022
NOTE: initiating online disk group 3 disks
SSDDG2_0000 (0) 
SSDDG2_0002 (2) 
SSDDG2_0004 (4) 
NOTE: process _s000_+asm2 (1099) initiating offline of disk 0.3915997526 (SSDDG2_0000) with mask 0x7e in group 3
NOTE: process _s000_+asm2 (1099) initiating offline of disk 2.3915997529 (SSDDG2_0002) with mask 0x7e in group 3
NOTE: process _s000_+asm2 (1099) initiating offline of disk 4.3915997530 (SSDDG2_0004) with mask 0x7e in group 3
NOTE: sending set offline flag message 3458690843 to 3 disk(s) in group 3
Fri Feb 18 14:18:01 2022
WARNING: Disk SSDDG2_0000 in mode 0x1 is now being offlined
WARNING: Disk SSDDG2_0002 in mode 0x1 is now being offlined
WARNING: Disk SSDDG2_0004 in mode 0x1 is now being offlined
NOTE: initiating PST update: grp = 3, dsk = 0/0xe9696156, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 3, dsk = 2/0xe9696159, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 3, dsk = 4/0xe969615a, mask = 0x6a, op = clear
GMON updating disk modes for group 3 at 60 for pid 34, osid 1099
NOTE: cache closing disk 0 of grp 3: (not open) SSDDG2_0000
NOTE: cache closing disk 2 of grp 3: (not open) SSDDG2_0002
NOTE: cache closing disk 4 of grp 3: (not open) SSDDG2_0004
NOTE: PST update grp = 3 completed successfully 
NOTE: initiating PST update: grp = 3, dsk = 0/0xe9696156, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 3, dsk = 2/0xe9696159, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 3, dsk = 4/0xe969615a, mask = 0x7e, op = clear
GMON updating disk modes for group 3 at 61 for pid 34, osid 1099
NOTE: cache closing disk 0 of grp 3: (not open) SSDDG2_0000
NOTE: cache closing disk 2 of grp 3: (not open) SSDDG2_0002
NOTE: cache closing disk 4 of grp 3: (not open) SSDDG2_0004
NOTE: PST update grp = 3 completed successfully 
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=3
NOTE: F1X0 copy 1 relocating from 0:2 to 0:4294967294 for diskgroup 3 (SSDDG2)
NOTE: initiating PST update: grp = 3, dsk = 0/0x0, mask = 0x11, op = assign
NOTE: initiating PST update: grp = 3, dsk = 2/0x0, mask = 0x11, op = assign
NOTE: initiating PST update: grp = 3, dsk = 4/0x0, mask = 0x11, op = assign
GMON updating disk modes for group 3 at 62 for pid 34, osid 1099
NOTE: cache closing disk 0 of grp 3: (not open) SSDDG2_0000
NOTE: cache closing disk 2 of grp 3: (not open) SSDDG2_0002
NOTE: cache closing disk 4 of grp 3: (not open) SSDDG2_0004
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: PST update grp = 3 completed successfully 
NOTE: requesting all-instance disk validation for group=3
Fri Feb 18 14:18:02 2022
NOTE: disk validation pending for group 3/0x85a9d211 (SSDDG2)
NOTE: Found /dev/qdata/mpath-s01.3267.01.redo for disk SSDDG2_0002
WARNING: ignoring disk  in deep discovery
NOTE: Found /dev/qdata/mpath-s01.3266.01.P1B00S07 for disk SSDDG2_0004
WARNING: ignoring disk  in deep discovery
NOTE: Found /dev/qdata/mpath-s01.3265.01.P1B00S06 for disk SSDDG2_0000
WARNING: ignoring disk  in deep discovery
SUCCESS: validated disks for 3/0x85a9d211 (SSDDG2)
GMON querying group 3 at 63 for pid 34, osid 1099
NOTE: initiating PST update: grp = 3, dsk = 0/0x0, mask = 0x19, op = assign
NOTE: initiating PST update: grp = 3, dsk = 2/0x0, mask = 0x19, op = assign
NOTE: initiating PST update: grp = 3, dsk = 4/0x0, mask = 0x19, op = assign
GMON updating disk modes for group 3 at 64 for pid 34, osid 1099
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: group SSDDG2: updated PST location: disk 0000 (PST copy 1)
NOTE: PST update grp = 3 completed successfully 
NOTE: membership refresh pending for group 3/0x85a9d211 (SSDDG2)
GMON querying group 3 at 65 for pid 18, osid 9872
NOTE: cache opening disk 0 of grp 3: SSDDG2_0000 path:/dev/qdata/mpath-s01.3265.01.P1B00S06
NOTE: cache opening disk 2 of grp 3: SSDDG2_0002 path:/dev/qdata/mpath-s01.3267.01.redo
NOTE: cache opening disk 4 of grp 3: SSDDG2_0004 path:/dev/qdata/mpath-s01.3266.01.P1B00S07
SUCCESS: refreshed membership for 3/0x85a9d211 (SSDDG2)
NOTE: initiating PST update: grp = 3, dsk = 0/0x0, mask = 0x5d, op = assign
SUCCESS: alter diskgroup ssddg2 online disks in failgroup qone1
NOTE: initiating PST update: grp = 3, dsk = 2/0x0, mask = 0x5d, op = assign
NOTE: initiating PST update: grp = 3, dsk = 4/0x0, mask = 0x5d, op = assign
GMON updating disk modes for group 3 at 66 for pid 34, osid 1099
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: group SSDDG2: updated PST location: disk 0000 (PST copy 1)
NOTE: PST update grp = 3 completed successfully 
NOTE: Attempting voting file refresh on diskgroup SSDDG2
NOTE: Refresh completed on diskgroup SSDDG2. No voting file found.
Fri Feb 18 14:18:17 2022
NOTE: initiating PST update: grp = 3, dsk = 0/0x0, mask = 0x7d, op = assign
NOTE: initiating PST update: grp = 3, dsk = 2/0x0, mask = 0x7d, op = assign
NOTE: initiating PST update: grp = 3, dsk = 4/0x0, mask = 0x7d, op = assign
Fri Feb 18 14:18:17 2022
GMON updating disk modes for group 3 at 67 for pid 34, osid 1099
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: group SSDDG2: updated PST location: disk 0000 (PST copy 1)
NOTE: PST update grp = 3 completed successfully 
Fri Feb 18 14:18:17 2022
NOTE: Voting File refresh pending for group 3/0x85a9d211 (SSDDG2)
NOTE: F1X0 copy 1 relocating from 0:4294967294 to 0:2 for diskgroup 3 (SSDDG2)
NOTE: initiating PST update: grp = 3, dsk = 0/0x0, mask = 0x7f, op = assign
NOTE: initiating PST update: grp = 3, dsk = 2/0x0, mask = 0x7f, op = assign
NOTE: initiating PST update: grp = 3, dsk = 4/0x0, mask = 0x7f, op = assign
GMON updating disk modes for group 3 at 68 for pid 34, osid 1099
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: group SSDDG2: updated PST location: disk 0000 (PST copy 1)
NOTE: PST update grp = 3 completed successfully 
NOTE: reset timers for disk: 0
NOTE: reset timers for disk: 2
NOTE: reset timers for disk: 4
NOTE: completed online of disk group 3 disks
SSDDG2_0000 (0) 
SSDDG2_0002 (2) 
SSDDG2_0004 (4) 
NOTE: Attempting voting file refresh on diskgroup SSDDG2
NOTE: Refresh completed on diskgroup SSDDG2. No voting file found.
------------------------------------------------------------------
----------------------------------------------------------------Fri Feb 18 14:37:30 2022
NOTE: ASM did background COD recovery for group 3/0x85a9d211 (SSDDG2)
NOTE: starting rebalance of group 3/0x85a9d211 (SSDDG2) at power 1024
Starting background process ARB0
Fri Feb 18 14:37:30 2022
ARB0 started with pid=29, OS id=5870 
NOTE: assigning ARB0 to group 3/0x85a9d211 (SSDDG2) with 1024 parallel I/Os
cellip.ora not found.
WARNING: Extent map changed during relocation for file 257
WARNING: Extent map changed during relocation for file 257
WARNING: Extent map changed during relocation for file 257
WARNING: Extent map changed during relocation for file 257
WARNING: Extent map changed during relocation for file 257
Fri Feb 18 14:37:45 2022
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=3
Fri Feb 18 14:37:48 2022
NOTE: membership refresh pending for group 3/0x85a9d211 (SSDDG2)
Fri Feb 18 14:37:51 2022
GMON querying group 3 at 69 for pid 18, osid 9872
SUCCESS: refreshed membership for 3/0x85a9d211 (SSDDG2)
NOTE: Attempting voting file refresh on diskgroup SSDDG2
NOTE: Refresh completed on diskgroup SSDDG2. No voting file found.
Fri Feb 18 14:39:41 2022
NOTE: stopping process ARB0
SUCCESS: rebalance completed for group 3/0x85a9d211 (SSDDG2)


alter diskgroup ssddg2 drop disks in failgroup qone1;

问题1：空间不够
在这里插入图片描述
问题2：不满足冗余度，normal至少两个故障组
在这里插入图片描述

------------------------------------------------------------Fri Feb 18 15:19:24 2022
SQL> alter diskgroup ssddg2 drop disks in failgroup qone1 
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=3
Fri Feb 18 15:19:25 2022
NOTE: membership refresh pending for group 3/0x85a9d211 (SSDDG2)
Fri Feb 18 15:19:28 2022
GMON querying group 3 at 71 for pid 18, osid 9872
SUCCESS: refreshed membership for 3/0x85a9d211 (SSDDG2)
ORA-15067: command or option incompatible with diskgroup redundancy
ERROR: alter diskgroup ssddg2 drop disks in failgroup qone1
NOTE: Attempting voting file refresh on diskgroup SSDDG2
NOTE: Refresh completed on diskgroup SSDDG2. No voting file found.
------------------------------------------------------------

问题3：加force删
在这里插入图片描述

------------------------------------------------------------Fri Feb 18 15:25:34 2022
SQL> alter diskgroup ssddg2 drop disks in failgroup qone1 force 
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=3
NOTE: process _user29525_+asm2 (29525) initiating offline of disk 0.3915997526 (SSDDG2_0000) with mask 0x7e in group 3
NOTE: process _user29525_+asm2 (29525) initiating offline of disk 2.3915997529 (SSDDG2_0002) with mask 0x7e in group 3
NOTE: process _user29525_+asm2 (29525) initiating offline of disk 4.3915997530 (SSDDG2_0004) with mask 0x7e in group 3
NOTE: initiating PST update: grp = 3, dsk = 0/0xe9696156, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 3, dsk = 2/0xe9696159, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 3, dsk = 4/0xe969615a, mask = 0x6a, op = clear
Fri Feb 18 15:25:34 2022
GMON updating disk modes for group 3 at 73 for pid 29, osid 29525
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: PST update grp = 3 completed successfully 
NOTE: initiating PST update: grp = 3, dsk = 0/0xe9696156, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 3, dsk = 2/0xe9696159, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 3, dsk = 4/0xe969615a, mask = 0x7e, op = clear
GMON updating disk modes for group 3 at 74 for pid 29, osid 29525
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: cache closing disk 0 of grp 3: SSDDG2_0000
NOTE: cache closing disk 2 of grp 3: SSDDG2_0002
NOTE: cache closing disk 4 of grp 3: SSDDG2_0004
NOTE: PST update grp = 3 completed successfully 
GMON updating for reconfiguration, group 3 at 75 for pid 29, osid 29525
NOTE: cache closing disk 0 of grp 3: (not open) SSDDG2_0000
NOTE: cache closing disk 2 of grp 3: (not open) SSDDG2_0002
NOTE: cache closing disk 4 of grp 3: (not open) SSDDG2_0004
NOTE: group SSDDG2: updated PST location: disk 0001 (PST copy 0)
NOTE: group 3 PST updated.
Fri Feb 18 15:25:34 2022
NOTE: membership refresh pending for group 3/0x85a9d211 (SSDDG2)
GMON querying group 3 at 76 for pid 18, osid 9872
NOTE: cache closing disk 0 of grp 3: (not open) _DROPPED_0000_SSDDG2
NOTE: cache closing disk 2 of grp 3: (not open) _DROPPED_0002_SSDDG2
NOTE: cache closing disk 4 of grp 3: (not open) _DROPPED_0004_SSDDG2
SUCCESS: refreshed membership for 3/0x85a9d211 (SSDDG2)
SUCCESS: alter diskgroup ssddg2 drop disks in failgroup qone1 force
NOTE: starting rebalance of group 3/0x85a9d211 (SSDDG2) at power 512
Starting background process ARB0
Fri Feb 18 15:25:37 2022
ARB0 started with pid=33, OS id=31058 
NOTE: assigning ARB0 to group 3/0x85a9d211 (SSDDG2) with 512 parallel I/Os
cellip.ora not found.
NOTE: F1X0 copy 1 relocating from 0:2 to 1:2 for diskgroup 3 (SSDDG2)
NOTE: F1X0 copy 2 relocating from 1:2 to 0:2 for diskgroup 3 (SSDDG2)
NOTE: Rebalance has restored redundancy for any existing control file or redo log in disk group SSDDG2
NOTE: Attempting voting file refresh on diskgroup SSDDG2
NOTE: Refresh completed on diskgroup SSDDG2. No voting file found.
NOTE: stopping process ARB0
SUCCESS: rebalance completed for group 3/0x85a9d211 (SSDDG2)
喝醉酒的小白
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Orcle 12c 新特性---新增参数FAILGROUP_REPAIR_TIME
Expec-乐的博客
06-15 712
1 说明 已经有的一个参数是DISK_REPAIR_TIME(默认是3.6h)，表示磁盘offline时间超过规定的时间，那么Oracle会自动把该磁盘给drop掉，那么就需要手动再添加到磁盘组中。12c中又新增了一个参数FAILGROUP_REPAIR_TIME(默认值24h)，同样表示：如果一个FAILGROUP OFFLINE超过规定时间，那么也会被DROP掉。 对这个参数的引入，还是很...
非归档模式下恢复利用offline drop命令误删除的数据文件
weixin_34168880的博客
02-23 232
众所周知，非归档模式下，联机日志并不归档。可能大多数的网友一直以来都会有这样的模糊认识。数据库作recover时，只能利用归档日志和current redo log联机日志。实际上所有的联机日志都是可以用的。此文介绍在非档模式下,恢复利用offline drop命令误删除的数据文件。offline drop命令相当于把一个数据文件至于离线状态，并且需要恢复或再也不使用此数据文件了。所在，在OS级别...
OFFLINE DROP
07-06 138
文档：1 OFFLINE Specify OFFLINE to take the datafile offline. If the database is open, you must perform. media rec...
offline drop和offline
citeng1329的博客
10-25 185
归档模式下的offline drop和offline offline drop演示 归档模式下的offline 演示 ...
藏记offline和offline drop
05-24 231
、对一个datafile执行offline或offline drop本质上是一回事，但对一个datafile执行offline只能在归档模式下；而对一个datafile执行offline drop则既可以在归档模式也可以在非归档...
offline drop 和offline区别
weixin_34318272的博客
10-25 466
归档模式下的offline drop和offlineoffline drop演示归档模式下的offline 演示可以看到在归档模式下，offline drop和offline的效果是一样的，都是将数据文件至于recover状态，如果需要online则先进行recover，之后数据文件状态会变为fline状态，dba可以手动online。切换数据库到非归档模式用test0...
数据库在归档模式下处理回滚段故障
03-04
- 删除损坏的回滚段，使用`ALTER ROLLBACK SEGMENT OFFLINE DROP`命令。 - 删除回滚表空间，使用`DROP TABLESPACE INCLUDING CONTENTS`命令。 - 创建新的回滚表空间和回滚段。这涉及到`CREATE ROLLBACK SEGMENT`...
专题资料（2021-2022年）7 表空间和数据文件管理.ppt
10-08
在Oracle数据库管理系统中，表空间...总的来说，表空间和数据文件的管理是Oracle数据库管理的关键部分，涉及数据存储、性能优化和故障恢复。通过熟练掌握这些概念和操作，DBA能够更有效地管理和维护数据库的健康运行。
【最新编排】ORACLE数据库命令大全速查.doc
05-05
- **增加重做日志组**（Adding Online Redo Log Groups）：通过`ALTER DATABASE ADD LOGFILE GROUP`命令，可以在数据库中添加新的日志组，提高并发性和可靠性。 - **增加重做日志文件**（Adding Online Redo Log...
实验数据库的创建与管理.doc
02-27
在SQL Server Management Studio (SSMS)中，数据库的创建、管理、备份和恢复是数据库管理员的基本操作。...在实际操作中，数据库管理员还需要关注性能优化、安全设置、索引管理和故障恢复等方面的知识。
ODU在ORACLE数据库中的应用.pdf
10-09
3. 其他特点：ODU 支持 Oracle 所有版本，同时支持 ASM 磁盘数据恢复，支持 Truncate、drop 等操作后的数据恢复，具有恢复速度快、运行稳定和使用简单等优点。 ODU 的配置 1. 控制文件的配置：ODU 的配置文件为 ...
通过一个案例知道了了offline drop
jzzw的博客
02-19 666
情况描述：         朋友的测试环境，程序调用的时候提示ORA-00376:file 6 cannot be read at this time;                  我先用shutdown abort停库，然后startup时候提示ORA-01157: cannot identify/lock data file 6 - see DBWR trace file        ...
oracle数据库offline,谁来解释下offline drop
weixin_30369405的博客
04-02 450
问题是这样的SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - ProdPL/SQL Release 10.2.0.5.0 - ...
非归档数据文件offline drop处理
zuixinnet的专栏
12-10 980
1、模拟数据文件offline drop； alter database  datafile 5 offline drop; 2、手工切换检查点，使检查点更新。 alter system checkpoint; 3、将redo中的日志覆盖。 alter system switch logfile; --切换几次 4、查看检查点情况。 select file#,to_char(CHEC
对一个datafile执行offline和offline drop的区别
08-11 519
From: http://dbsnake.com/2010/11/offline-offline-drop-diff.html   1、对一个datafile执行offline或offline drop本质上是一回事，但对一个datafile执行offline只能在归档模
OFFLINE和DROP数据文件的理解
cjh81378066的博客
05-06 1072
Offline仅是脱机操作，并不涉及删除，就算是offline for drop\offline drop也仅仅是脱机，和alter database datafile ‘XX’ offline一起 表空...
alter database offline 与 alter database offline drop效果比对
qq_45678201的博客
11-18 746
如果datafile数据文件被误删除，导致数据库不能正常open，这时，就需要把该数据文件先offline，或者恢复该数据文件。 SQL> alter database open; alter database open * ERROR at line 1: ORA-01157: 无法标识/锁定数据文件 3 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 3: '/app/oradata/datafile/TEST02.dbf' SQL> alter database data
ASM故障组offline
喝醉酒的小白
09-07 2346
select name, failgroup, group_number from v$asm_disk order by failgroup; alter diskgroup 磁盘组 offline disks in failgroup 故障组; alter diskgroup 磁盘组 online disks in failgroup 故障组;
oracle修改磁盘组名称,管理Oracle ASM磁盘组系列3--修改磁盘组
weixin_42372573的博客
04-04 808
1说明在数据库online状态下，可以通过ALTER DISKGROUP语句来修改磁盘组，也可以通过ASMCA，和ASMCMD chdg的命令来修改磁盘组。https://www.cndba.cn/Expect-le/article/2624https://www.cndba.cn/Expect-le/article/2624通过ALTAER DISKGROUP命令来修改磁盘组，默认情况下直到操作...
offline mapping和online mapping
最新发布
05-27
Offline mapping和online mapping都是地图应用中常用的术语。 Offline mapping指的是离线地图，即用户可以事先下载地图数据到本地设备，然后在没有网络连接的情况下使用地图应用进行导航或查找地点等操作。 Online...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值