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 *