Which statement about Online Move Data file is true?

Question

Options

• AMoving a data file online prevents DML operations on segments stored in the data file.
• BFlashing back a database to a point in time before a data file had been renamed online retains the
• CMoving a data file online can be performed if the data file is in OFFLINE mode.
• DMoving a data file online cannot be performed if the data file is under BEGIN BACKUP.

• A
  8% (3)
• B
  77% (30)
• C
  3% (1)
• D
  13% (5)

Explanation

Online Data File Move and Online Partition Move Oracle Database 12c has the ability to move a data file while users are accessing its data, via command ALTER DATABASE MOVE DATAFILE. This capability maintains data availability during maintenance operations. This capability is useful to move infrequently accessed datafiles to lower-cost storage. Another example of use is to move a database from non-ASM to ASM You can rename online or offline data files to either change their names or relocate them. When you rename or relocate online data files, the pointers to the data files, as recorded in the database control file, are changed. The files are also physically renamed or relocated at the operating system level. You might rename or relocate online data files because you want to allow users to access the data files when you perform one of the following tasks: - Move the data files from one type of storage to another - Move data files that are accessed infrequently to lower cost storage - Make a tablespace read-only and move its data files to write-once storage - Move a database into Oracle Automatic Storage Management (Oracle ASM) - The ALTER DATABASE MOVE DATAFILE statement raises an error if the specified data file is - If you are using a standby database, then you can perform an online move data file operation independently on the primary and on the standby (either physical or logical). The standby is not affected when a data file is moved on the primary, and vice versa. See Oracle Data Guard Concepts and Administration for more information. - 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 are changed to the contents at the time specified in the flashback. See Oracle Database Backup and Recovery User's Guide for more information about flashback database operations. - When you relocate a data file on the Windows platform, the original data file might be retained in the old location, even when the KEEP option is omitted. In this case, the database only uses the data file in the new location when the statement completes successfully. You can delete the old data file manually after the operation completes if necessary.

No community discussion yet for this question.