Listen Software's How To: Control File Backups

Monday Feb 11th 2002 by David Nishimoto
Share:

A couple examples of how to create a backup of the control file, which can be used during a hot backup recovery.

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:\orant\control_backup'

Backup a Text Version of the Control File

ALTER DATABASE 
      BACKUP CONTROLFILE TO TRACE;

David Nishimoto
For Listen Software

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved