What is the purpose of the until change option of the restore command?
A.
It allows you to select the SCN that you want to restore to.
B.
It allows you to select the log sequence number you want to restore to.
C.
It allows you to select the timestamp you want to restore to.
D.
It allows you to manually stop the restore at any time as online redo logs are applied.
E.
None of the above.
Explanation:
The keyword of CHANGE means to point to the system change number (SCN).
There is no UNTIL CHANGE option in rman for RESTORE command (only SCN, SEQUENCE and TIME):
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsubcl018.htm#BABEDABD
RMAN> restore datafile 8 until change 6589374;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “change”: expecting one of: “scn, sequence, time”
RMAN-01007: at line 1 column 26 file: standard input
@dbr, several points
Please note that the version of oracle examened in the sxam IZO-053 is 11.2.0.1 as stated here
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
and not the version of Oracle refered to by the documentation that you supply.
Therefore please refer to the documentation found in
https://docs.oracle.com/cd/E11882_01/index.htm
This documentation is as of version 11.2.0.4 but it is the closest to 11.2.0.1 as can be found on an official website.
As can be seen in
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osrecvry.htm#BRADV90034
“until change” does in fact exist.
“until change” is in fact INCLUSIVE of the SCN used in the command.
Therefore answer A is correct
As with all UNTILs “UNTIL CHANGE” is in fact NONINCLUSIVE (in this case of the SCN used).
However answer A is still correct.
Also “UNTIL CHANGE” is an SQL/Plus command and not an RMAN command.
Also I would like revise the documentation version information I made earlier with …
Please note that the version of oracle exam-ed in IZO-053 is 11.2.0.1 as stated here …
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
Therefore please refer to the 11.2.0.1 documentation found in …
http://oracle.su/docs/11g/nav/portal_booklist.htm