53 Which statement about using RMAN stored scripts is true? A. To create and execute an RMA

最新推荐文章于 2021-04-04 10:37:22 发布

原创最新推荐文章于 2021-04-04 10:37:22 发布 · 673 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

OCP 053 专栏收录该内容

86 篇文章

订阅专栏

本文详细介绍了RMAN（Recovery Manager）存储脚本的正确使用方式，指出创建及执行RMAN存储脚本必须使用恢复目录，并解释了为什么不能在控制文件中使用这些脚本。同时，澄清了一些关于脚本执行过程中的常见误解。

QUESTION 53
Which statement about using RMAN stored scripts is true?
A. To create and execute an RMAN stored script, you must use a recovery catalog.
B. When executing a stored script and a command fails, the remainder of the script is executed, and a
message is written to the alert log file.
C. RMAN stored scripts can always be executed against any target database that is registered in the
recovery catalog.
D. When you execute a stored script, it always executes using the persistent channel settings previously

set with the CONFIGURE command.

Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
Explanation:
To create and execute an RMAN stored script, you must use a recovery catalog because RMAN stored
scripts are stored in the recovery catalog. You cannot use RMAN stored scripts if you are using the control
file for your RMAN repository.
The option that states when executing a stored script and a command fails, the remainder of the script is
executed, and a message is written to the alert log file is incorrect. If you are executing a stored RMAN
script and one of the commands in the script fails, the other subsequent commands in the script are not
executed because a stored RMAN script is created within a RUN block.

The option that states RMAN stored scripts can always be executed against any target database that is
registered in the recovery catalog is incorrect. RMAN stored scripts can be created as local scripts or as
global scripts. Local scripts can only be executed against the target database to which you are connected
when you create the script. To create a global script that can be executed against any target database
registered in the recovery catalog, you must include the GLOBAL keyword when you create the script.
The option that states when you execute a stored script, it always executes using the persistent channel
settings set with the CONFIGURE command is incorrect. You can override any persistent channel settings
by including an ALLOCATE CHANNEL command in the RUN block before executing the script.