you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)

Which files will you need to perform a full recovery of a database backed up in
NOARCHIVELOG mode? (Choose all that apply.)

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 ‘<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;

Show Hint

Leave a Reply 2

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

M2

M2

I rather think that the answer is AB.
Why should I need the online redo logs for the recovery of a database in NOARCHIVELOG? Theoretically it is possible, that the redo logs are still not overwritten after the last backup. Then I can indeed perform complete recovery with them. But that situation should be very special, very rare.

Reply

k

k

for a full recovery you will also need the redo logs

Reply