Listen Software’s How To: Control File Backups

Control File Backups

[Editor’s note: the two code examples here are intended to each be written on one line; they’ve been line-wrapped here for formatting purposes.]

Backup a Binary Version of the Control File

ALTER DATABASE 
      BACKUP CONTROLFILE TO 'd:orantcontrol_backup'

Backup a Text Version of the Control File

ALTER DATABASE 
      BACKUP CONTROLFILE TO TRACE;

David Nishimoto
For Listen Software

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles