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.
Answer: A
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsubcl019.htm#i1000331
Purpose
Use the untilClause
subclause to specify an upper limit by time, SCN, restore point or log sequence number for various RMAN operations.
Syntax Element | Description |
---|---|
UNTIL SCN integer | Specifies an SCN as an upper, noninclusive limit. RMAN selects only files that it can use to restore or recover up to but not including the specified SCN(seeExample 4-38). For example, |
UNTIL SEQUENCE integer | Specifies a redo log sequence number and thread as an upper, noninclusive limit. RMAN selects only files that it can use to restore or recover up to but not including the specified sequence number. For example, |
THREAD integer | Specifies the number of the redo thread. |
UNTIL TIME ' date_string ' | Specifies a time as an upper, noninclusive limit (see Example 4-39). RMAN selects only files that it can use to restore and recover up to but not including the specified time. For example, When specifying dates in RMAN commands, the date string must be either:
Following are examples of typical date settings in RMAN commands: BACKUP ARCHIVELOG FROM TIME 'SYSDATE-31' UNTIL TIME 'SYSDATE-14'; RESTORE DATABASE UNTIL TIME "TO_DATE('09/20/06','MM/DD/YY')"; Note: The granularity of time-based recovery is dependent on time stamps in the redo log. For example, suppose that you specify the following command: RECOVER DATABASE UNTIL TIME '2007-07-26 17:45:00'; If no redo was written with a time stamp of |