which statement is true?

Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and
one of the online redo logs is missing. The missing redo log sequence, 230, is not archived
and it contained information from 10:35
A.m. onwards.
The current time is 11:00 A.m. Because of a disk crash, you executed the following
command to perform an incomplete recovery:
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESETLOGS;
With reference to this scenario, which statement is true?

Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and
one of the online redo logs is missing. The missing redo log sequence, 230, is not archived
and it contained information from 10:35
A.m. onwards.
The current time is 11:00 A.m. Because of a disk crash, you executed the following
command to perform an incomplete recovery:
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESETLOGS;
With reference to this scenario, which statement is true?

A.
RMAN recovers up to log sequence 230, but not including 230.

B.
RMAN returns an error because the log sequence number mentioned in the command
should be 229.

C.
RMAN returns an error because the log sequence number mentioned in the command
may never be missing.

D.
RMAN recovers up to and including log sequence 229 but then returns an error because
log sequence 230 is missing.



Leave a Reply 0

Your email address will not be published. Required fields are marked *