Which statement about using RMAN stored scripts is true?

Which statement about using RMAN stored scripts is true?

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.

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *