Which four actions are possible during an Online Datafile Move operation?

A.
Creating and dropping tables in the datafile being moved

B.
Performing file shrink of the data file being moved

C.
Querying tables in the datafile being moved

D.
Performing Block Media Recovery for a data block in the datafile being moved

E.
Flashing back the database

F.
Executing DML statements on objects stored in the datafile being moved

Explanation:
You can now move On line Datafile without hove to stop Monoged Recovery and manually
copy and rename Files. This can even be used to move Datafiles from or to ASM.
– New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active
Data Guard Mode (opened READ ONLY and Managed Recovery is running):
It is now possible to online move a Datafile while Managed Recovery is running, ie. the
Physical Standby Database is in Active Data Guard Mode. You con use this Command to
move the Datafile
– A flashback operation does not relocate a moved data file to its previous location. If you
move a data file online from one location to another and later flash back the database to a

point in time before the move, then the Data file remains in the new location, but the
contents of the Data file ore changed to the contents at the time specified in the flashback.
Oracle0 Database Administrator’s Guide 12c Release 1 (12.1)

Show Hint

← Previous question

Next question →

Anthony

ACDF

feedback

please explain why, this kind of answer is useless

Anthony

Feedback,

Useless is you, because you do not seek the answer or do any tests ?

Anyway follows the explanation for you be happy

ACDF

How say tamil and Joe..

Block Media Recovery can be done while the data file was moved…and Media Recovery is not possible.

“The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile’s underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature.”

http://muhammad-asif-dba.blogspot.com.br/2013/11/oracle-12c-database-online-move-datafile.html

Feedback

Thank you for the answer,

I do give answers but the answers I give are explained or at least a reference to where your answer is based on.
This is what everyone should do..