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 Mode
1. 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 ‘<newlocation>’;
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;