You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?
A.
It creates a binary backup of the control file.
B.
It updates the alert log with the location and contents of the control file
C.
It creates a file that contains SQL statements to re-create the control file.
D.
It creates a file that contains RMAN scripts to create a duplicate database.
E.
It creates a copy of the control file in the fast recovery area (FRA).
Answer:
C
User Votes:
A 1 votes
50%
B 3 votes
50%
C 4 votes
50%
D
50%
E
50%
Discussions
0/ 1000
ace03
6 months, 3 weeks ago
The ALTER DATABASE BACKUP CONTROLFILE TO TRACE command is one way to back up the control file. It produces a SQL script that you can use to re-create the database control file in case all multiplexed binary versions of the control file are lost due to a catastrophic failure.
Want to join our community?
Please log in or signup in order to use this feature
The ALTER DATABASE BACKUP CONTROLFILE TO TRACE command is one way to back up the control file. It produces a SQL script that you can use to re-create the database control file in case all multiplexed binary versions of the control file are lost due to a catastrophic failure.