Name

ALTER DATABASE BACKUP CONTROLFILE

Synopsis

ALTER DATABASE BACKUP CONTROLFILE TO filename | TO TRACE

SQL*Plus command. Creates a backup of the current control file for the database.

Keywords

to_filename

Specifies the location of a copy of the current control file.

TO TRACE

Causes the information in the control file to be written as SQL statements to a file in the database’s trace directory. You can use this information to re-create the control file with the CREATE CONTROLFILE command.

Get Oracle in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.