31.
Which command is not a valid RMAN incomplete recovery run block?
- A.
run { set until change 7563633; restore database; recover database; } - B.
run { set until time '06-SEP-2004 11:25:00'; restore database; recover database; } - C.
run { set until SCN 7563633; restore database; recover database; } - D.
run { set until sequence 3 thread 1; restore database; recover database; }
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The SET UNTIL CHANGE command is not used with RMAN. This command is used during a user-managed incomplete recovery. |
32.
Which of the following would be a reason for using incomplete recovery? (Choose all that apply.)
- A.Stopping the recovery at a certain redo log sequence before a database corruption point
- B.Stopping the recovery at a certain time when database corruption occurred
- C.Stopping the recovery before a bad transaction is executed
- D.Stopping the recovery only after applying all transactions
- Answer & Explanation
- Report
Answer : [A, B, C]
Explanation :
Explanation :
| Incomplete recovery is designed to be able to stop at a desired point, before introducing undesired transactions to the database. |
33.
Which incomplete recovery capability is available to RMAN or user-managed methods?
- A.SET UNTIL TIME
- B.UNTIL TIME
- C.UNTIL SCN
- D.UNTIL SEQUENCE
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The UNTIL TIME clause is available in both user-managed and RMAN-based incomplete recovery methods. |
34.
When performing incomplete recovery, which command allows you to stop the recovery process
at a random point?
- A.UNTIL SEQUENCE, when performing a user-managed recovery
- B.UNTIL SCN, when performing a RMAN-based recovery
- C.UNTIL CANCEL, when performing a RMAN-based recovery
- D.UNTIL CANCEL, when performing a user-managed recovery
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The UNTIL CANCEL command is available only in user-managed recovery. This command allows you to stop the recovery process at a random point during redo log switches. |
35.
Which command is required when performing an incomplete recovery?
- A.ALTER DATABASE OPEN RESETLOGS
- B.ALTER DATABASE OPEN NORESETLOGS
- C.UNTIL CANCEL.
- D.ALTER DATABASE OPEN
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The ALTER DATABASE OPEN RESETLOGS command is required with every incomplete recovery. This is because the redo log sequence always needs to be reset. |
|
|
||||||||||||||||||||||||||||
