Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?
(Choose all that apply.)
A.
Database datafiles
B.
Control files
C.
Archived redo logs
D.
Online redo logs
E.
Flashback logs
Explanation:
Recovering a Database in NOARCHIVELOG Mode1. Restore all the data files and control files
2. (optional) if the media failure is not fixed, you need to modify the control file to the new location of data files
and redo log files.
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RENAME FILE ‘<damaged file, datafile, redo log>’ TO ‘<new
location>’;
3. SQL> RECOVER DATABASE UNTIL CANCEL Because online redo logs are never backed up, you cannot
restore them with the data files and control files. To enable the database to reset the online redo logs, you must
first mimic incomplete recovery:
4. SQL> ALTER DATABASE OPEN RESETLOGS;