OCP-1Z0-053-V13.02-705题

AI权益加码!Claude Code、Cursor等20+工具免费用! 购周边限时加赠Coding Plan Lite,畅享主流AI工具!学习进阶更高效! 阅读详情

705. View Exhibit1 to examine the DATA disk group when all the disks are online.  

  

Why is the rebalancing not performed and the content of  the disk group not empty in Exhibit2?

A.Because the disk group is created with NORMAL redundancy

B.Because the disk repair time attribute is set to a nonzero value

C.Because the mirrored extents cannot be rebalanced across the other three disks

D.Because the other three disks have 60% fr ee space, the disk r ebalancing is delayed

Answer: D 

答案解析:

途中对比,发现第二文件的path没有了,题中问为什么没有重新平衡。

因为设置了DISK_REPAIR_TIME 参数,to repair the disk and bring it back online,推迟了重新平衡。

故选B。

Configuring Disk Repair Time

Specify a time period that is long enough for you to repair a disk in the disk group.

For information about disk group repair time, see "Oracle ASM Fast Mirror Resync".

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10044、


Oracle ASM Fast Mirror Resync

Restoring the redundancy of an Oracle ASM disk group after a transient disk path failure can be time consuming. This is especially true if the recovery process requires rebuilding an entire Oracle ASM failure group. Oracle ASM fast mirror resync significantly reduces the time to resynchronize a failed disk in such situations. When you replace the failed disk, Oracle ASM can quickly resynchronize the Oracle ASM disk extents.

Note:

To use this feature, the disk group compatibility attributes must be set to  11.1 or higher. For more information, refer to  "Disk Group Compatibility".

Any problems that make a failure group temporarily unavailable are considered transient failures that can be recovered by the Oracle ASM fast mirror resync feature. For example, transient failures can be caused by disk path malfunctions, such as cable failures, host bus adapter failures, controller failures, or disk power supply interruptions.

Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought back online.

By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online. The time can be specified in units of minutes (m or M) or hours (h or H). If you omit the unit, then the default unit is hours. The DISK_REPAIR_TIME disk group attribute can only be set with the ALTER DISKGROUP SQL statement.

If the attribute is not set explicitly, then the default value (3.6h) applies to disks that have been set to OFFLINE mode without an explicit DROP AFTER clause. Disks taken offline due to I/O errors do not have a DROP AFTER clause.

The default DISK_REPAIR_TIME attribute value is an estimate that should be adequate for most environments. However, ensure that the attribute value is set to the amount of time that you think is necessary in your environment to fix any transient disk error, and that you are willing to tolerate reduced data redundancy.

The elapsed time (since the disk was set to OFFLINE mode) is incremented only when the disk group containing the offline disks is mounted. The REPAIR_TIMERcolumn of V$ASM_DISK shows the amount of time left (in seconds) before an offline disk is dropped. After the specified time has elapsed, Oracle ASM drops the disk. You can override this attribute with the ALTER DISKGROUP OFFLINE DISK statement and the DROP AFTER clause.


 
OCP-V13-704 QUESTION 704 705. View Exhibit1 to examine the DATA disk group when all the disks are online. Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2? 看图一所有磁盘组在线 阅读详情

相关推荐

053-704

704. View the Exhibit and examine the data manipulation language (DML) operations that you performed  on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Que

学习记录 2994

OCP-1Z0-053-V13.02-443

443.Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.) A. SET_ATTRIBUTE_NULL B. ALTER_JOB C. ALTER_JOB_PARAMETERS D. ALTER E. SET_ATTRIBUTE Answer:

一抹曦阳-Oracle 6067

OCP-V13-708

You executed the following query: Considering that all the redo logs are available, what information can you derive from the output of the preceding query? 考虑到所有重做日志可用,什么样的信息来自于上图的查询结果? A.The time wh

jiayue's BLOG 1732

56.View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respe

56.View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively.

dwj19830118的专栏 969

OCP-1Z0-053-V13.02-538

538.Which type of database file is spread across all disks in a disk group? A. All types of files are spread across all disks in the disk group. B. Datafiles C. Redo log files D. Archived redo log

一抹曦阳-Oracle 4767

OCP-1Z0-053-V12.02-673

673.In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance a

一抹曦阳-Oracle 7197

OCP-1Z0-053-V13.02-703

703. Given below are RMAN commands to enable ba ckup optimization and set  the retention policy:   The USERS tablespace has never been backed up. Y ou take the USERS tablespace offline on Monday. V

一抹曦阳-Oracle 1万+

Oracle 补充日志(Supplemental Logging)说明

补充日志:只要是针对 UPDATE 命令的,是对重做日志记录中 变更矢量块的补充信息,增加了变更矢量记载的记录量。日志挖掘器(LogMiner)、闪回事务查询、闪回事务等都需要 补充日志的支持。尤其是 日志挖掘器如果发现未启用补充日志,就拒绝服务。也就是说补充日志主要是为UPDATE 命令服务的,补充的目的是高度还原 UPDATE 命令,避免因为update  命令造成的行迁移和行移动,让

aaron8219's Oracle&Linux Technology Blog 1万+

OCP-1Z0-053-V13.02-708

708. You executed the following query:   Considering that all the redo logs  are available, what information can you derive from the output of the preceding query? A.The time when the last flashba

一抹曦阳-Oracle 5647

OCP-1Z0-053-200-168-528

QUESTION 168 What is the default AU size of an ASM disk group? Whatis the maximum AU size in an ASM disk group? A. 100KB default, 10TB maximum B. 256KB default, 1024MB maximum C. 10MB default, 126

一抹曦阳-Oracle 2866

oracle 开启supplemental logging

开启supplemental logging conn / as sysdba --安装LOGMINER SQL> @$ORACLE_HOME/rdbms/admin/dbmslmd.sql; SQL> @$ORACLE_HOME/rdbms/admin/dbmslm.sql; SQL> @$ORACLE_HOME/rdbms/admin/dbmslms.sql;

札记 2083

OCP-1Z0-053-V12.02-240

240.You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the fo

一抹曦阳-Oracle 8100

OCP-1Z0-053-V13.02-467

467.In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default? A. VARCHAR2 B. CHAR C. NVA

一抹曦阳-Oracle 4483

Oracle OCP 11G 053(201-400)答案解析目录_20140304

Oracle OCP 11G 053(201-400)答案解析目录   201 http://blog.csdn.net/rlhua/article/details/16846383  202 http://blog.csdn.net/rlhua/article/details/16846511  203

一抹曦阳-Oracle 4万+

OCP-1Z0-053-V12.02-678

678.Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.) A.Flash recovery area must be defined B.Undo retention guarantee must be enabled. C.Database must be runn...

836811384 215

OCP-1Z0-053-V13.02-507

507.Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup fo

一抹曦阳-Oracle 6985

OCP-1Z0-053-V13.02-712新

Why does the number of blocks for the table remain the sale after the shrink operation? A.Because the table did not contain migrated or chained rows B.Because the row IDs remain the same for all row

一抹曦阳-Oracle 8219

Oracle OCP 1z0-053 2018年9月最新考过的库分享-1

1.you configured the fast recovery area for one of your database but it is now running out of space. which two could make space available in the flash recover area? A.change the RMAN archived log dele...

技术=勤奋+思考 6813

OCP-1Z0-053-V12.02-32

32.In your production database, you: -Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals Set the control file autobackup to "on" -Are mai

一抹曦阳-Oracle 1万+
上一篇: OCP-1Z0-053-V13.02-707题
下一篇: OCP-1Z0-053-V13.02-694题
Riveore
博客等级 码龄19年 1801粉丝 1432原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值