Given the script
create script db_backup_datafile_script
{backup datafile and 1, and2 plus archivelog delete input;}
What is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}
A.
The script will fail since you instructed RMAN to back up only one datafile rather than two.
B.
The script will successfully back up datafile 3 without error.
C.
The script will fail since it uses a substitution variable which is not supported.
D.
The execute script command will prompt for the value of and2 since it’s not included in
the command.
E.
The script will fail because you cannot use the plus archivelog command when backing up
database datafiles.
create script db_backup_datafile_script
{backup datafile &1, &2 plus archivelog delete input;}
RMAN> RUN { EXECUTE SCRIPT db_backup_datafile_script USING 2; }
Enter value for 2:
USING :
Specifies one or more values for use in substitution variables in a stored script.
@andreas, thank you for your clarification