You observe that your senior database administrator is executing the following command using Recovery Manager (RMAN) in order to perform an incomplete recovery of the database:

RMAN> RUN { ALLOCATE CHANNEL c1 TYPE DISK; SET UNTIL SEQUENCE 134 THREAD 1; RESTORE DATABASE; RECOVER DATABASE; } The current sequence number is 189 and your database is running in ARCHIVELOG mode. What could be the objective of specifying the SET UNTIL SEQUENCE option in the RUN block of RMAN? Oracle 1Z0-032 Exam

Question

You observe that your senior database administrator is executing the following command using Recovery Manager (RMAN) in order to perform an incomplete recovery of the database:

RMAN> RUN { ALLOCATE CHANNEL c1 TYPE DISK; SET UNTIL SEQUENCE 134 THREAD 1; RESTORE DATABASE; RECOVER DATABASE; } The current sequence number is 189 and your database is running in ARCHIVELOG mode. What could be the objective of specifying the SET UNTIL SEQUENCE option in the RUN block of RMAN? Oracle 1Z0-032 Exam

Accepted Answer

D. to restore the database completely from the last available backup taken prior to the sequence 134, and then

Answer

A. to restore and recover the database from the sequence number specified until the current sequence number

Answer

B. to reset the current sequence number for the database, and then to start restore and recovery processes

Answer

C. to restore the database till the sequence number specified, and then recover the database until the current

You observe that your senior database administrator is executing the following command using Recovery Manager (RMAN) in order to perform an incomplete recovery of the database: RMAN> RUN { ALLOCATE…

Question

Options

How the community answered

Community Discussion