Which four actions are possible during an Online Data file Move operation?

Which four actions are possible during an Online Data file Move operation?

Which four actions are possible during an Online Data file Move operation?

A.
Creating and dropping tables in the data file being moved

B.
Performing file shrink of the data file being moved

C.
Querying tables in the data file being moved

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

E.
Flashing back the database

F.
Executing DML statements on objects stored in the data file 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)



Leave a Reply 5

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


Daniel

Daniel

It is now possible to online move a Datafile while Managed Recovery is running

legos21

legos21

ACDF

http://www.barada.co.uk/knowledge-base/new-online-movecapabilities/
Moving Data Files ONLINE
Oracle 12c introduces the capability to move data file ONLINE, this means that DML, DDL and backups can be in operation whilst the file is moved. ADO uses this capability to implement storage tiering.
The operation is NOT compatible with:
OFFLINE data files.
Concurrent FLASHBACK DATABASE operations.
Concurrent media recovery.
Data File RESIZE (shrink) operations.
It WILL work for
DDL and DML.
Block media recovery.
TABLESPACE made READ ONLY or READ WRITE.
Data File RESIZE (extension).
Online Backups.