nerdexam
Oracle

1Z0-032 · Question #17

You are using Recovery Manager (RMAN) to back up your database at regular intervals. The database is running in ARCHIVELOG mode. On Monday morning, you find that the media that contains the…

The correct answer is A. use the RMAN SET NEWNAME command. See the full explanation below for the reasoning.

Question

You are using Recovery Manager (RMAN) to back up your database at regular intervals. The database is running in ARCHIVELOG mode. On Monday morning, you find that the media that contains the users.dbf data file, which belongs to the USERS tablespace, is corrupted and users are unable to access the USERS tablespace. After investigating further, you decide to restore the data file to a new location. Which option would you use to relocate the data file before restoring the data file to the new location?

Options

  • Ause the RMAN SET NEWNAME command
  • Buse the RMAN RESTORE TABLESPACE command
  • Cuse the Transportable Tablespace option of Oracle Export and Import utility
  • Duse the ALTER DATABASE RENAME FILE command for the data file users.dbf

How the community answered

(54 responses)
  • A
    72% (39)
  • B
    7% (4)
  • C
    6% (3)
  • D
    15% (8)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice