OCP-1Z0-053-V12 02-134题

向右看齐 2022-03-21 05:28 98阅读 0赞

134.You are managing an Oracle Database 11g database. You want to take a backup on tape drives of

the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To

accomplish the backup, you issued the following RMAN command:

RMAN>BACKUP

SECTION SIZE 300M

TABLESPACE users;

What configuration should be effected to accomplish faster and optimized backups by using the above

command?

A. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.

B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

C. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.

D. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB.

Answer: D

答案解析：

参考：[http://docs.oracle.com/cd/E11882\_01/backup.112/e10643/rcmsynta007.htm\#RCMRF90025][http_docs.oracle.com_cd_E11882_01_backup.112_e10643_rcmsynta007.htm_RCMRF90025]

根据Note: You cannot use `SECTION SIZE` with `MAXPIECESIZE` or with `INCREMENTAL LEVEL 1`.这句话，说明D错误

根据RMAN channels can process each step independently and in parallel，应该选择C，可以并行备份。

<table title="Semantics for backupOperand Subclause"> 
 <tbody> 
  <tr> 
   <td align="left"><code>SECTION&nbsp;SIZE</code>&nbsp;<code><a href="http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#i1017291" rel="nofollow">sizeSpec</a></code></td> 
   <td align="left"><a rel="nofollow"></a><a rel="nofollow"></a><a rel="nofollow"></a><a rel="nofollow"></a><a rel="nofollow"></a>Specifies&nbsp;the size of each backup section produced during a data file backup.<p>By setting this parameter, RMAN can create a&nbsp;multisection backup. In a multisection backup, RMAN creates a backup piece that contains one&nbsp;file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size.&nbsp;You can create a multisection backup for a data file, but not a data file copy.</p><p>File sections enable RMAN to create multiple steps for the backup of a single large data file.&nbsp;RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection&nbsp;backup set.</p><p>If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value&nbsp;that results in exactly 256 sections.</p><p>Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job.</p><p>Note:&nbsp;You cannot use&nbsp;<code>SECTION SIZE</code>&nbsp;with&nbsp;<code>MAXPIECESIZE</code>&nbsp;or with&nbsp;<code>INCREMENTAL LEVEL 1</code>.</p></td> 
  </tr> 
 </tbody> 
</table>

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

[http_docs.oracle.com_cd_E11882_01_backup.112_e10643_rcmsynta007.htm_RCMRF90025]: http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF90025
[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485