you need to perform for the query successfully?

A database is running in ARCHIVELOG mode and regular backups are performed. A user
receives the following
Error message:

Which is the recommended sequence of operations you need to perform for the query
successfully?

A database is running in ARCHIVELOG mode and regular backups are performed. A user
receives the following
Error message:

Which is the recommended sequence of operations you need to perform for the query
successfully?

A.
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the
tablespace.

B.
Take the affected datafile offline (if not already offline), restore the damaged image of the
datafile, and then bring it online.

C.
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile
and then open the database with resetlogs.

D.
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile
and recover the tablespace, and then put the database in normal operational mode.

Explanation:
It supposed to none of answer is correct.



Leave a Reply 1

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


Cương Thi Tiên Sinh

Cương Thi Tiên Sinh

Lost a noncritical datafile => why does it need to resetlogs?