1Z0-032 · Question #101
You plan to perform a backup of the control file in your database. Which two statements regarding the control file backup are true? (Choose two.)
The correct answer is A. You can back up the control file to a binary file. D. You can back up the control file by generating a script that can be used to re-create the control file. See the full explanation below for the reasoning.
Question
You plan to perform a backup of the control file in your database. Which two statements regarding the control file backup are true? (Choose two.)
Options
- AYou can back up the control file to a binary file.
- BYou must bring the database to the NOMOUNT state to perform the control file backup.
- CYou must store all types of control file backups in the location defined by USER_DUMP_DEST.
- DYou can back up the control file by generating a script that can be used to re-create the control file.
How the community answered
(56 responses)- A80% (45)
- B7% (4)
- C13% (7)
Community Discussion
3
Carlos M.Jun 24, 2026A and D are correct. You can back up the control file to a binary copy using ALTER DATABASE BACKUP CONTROLFILE TO '/path/file.bkp', and you can also dump a creation script with ALTER DATABASE BACKUP CONTROLFILE TO TRACE, which gives you a SQL script to recreate it. B is wrong because the database can stay open (OPEN or MOUNT), and C is wrong because the binary backup goes wherever you point it, not to USER_DUMP_DEST (the trace file goes to DIAGNOSTIC_DEST now anyway).
Viktor S.Jun 9, 2026Good question to know cold because the control file is what Oracle uses to understand the physical structure of your database, so if you lose it without a backup you are in serious pain. What do you think the difference is between backing up to a binary file versus generating a script, and when would you actually reach for one over the other on a real system?
Dragan P.Jun 10, 2026Binary gets you back faster in RMAN because it is a true image copy you can restore directly, but the trace script is the one you actually want when the database has gone so sideways that RMAN itself cannot connect, since you can hand-edit the CREATE CONTROLFILE statement to reflect whatever datafiles you actually still have on disk.