| 2. |
For user-managed recovery of an ordinary application datafile with no backup, the database remains open in ARCHIVELOG mode. The control file records the file, all required redo exists, and there were no unrecoverable NOLOGGING changes. Which are valid steps? Assume suitable privileges and the correct container.
Please select all the correct answers.
|
| |
A.
|
Take the affected datafile offline before re-creating it. |
| |
B.
|
Copy the datafile from a backup that does not exist. |
| |
C.
|
Use ALTER DATABASE CREATE DATAFILE with an AS clause to re-create the file at an appropriate replacement location. |
| |
D.
|
Apply all required redo from file creation through the recovery endpoint before bringing the recovered file online. |