Re: Recovery from online backup
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: <jheinrich@xxxxxxxx>
- Date: Wed, 19 Apr 2006 18:09:02 +0200
> Contrary to its syntax, this command does not actually backup the
> controlfile. Rather, it creates a trace file with the commands to recreate
> the controlfile.
Incorrect!
Backup and Recovery Concepts Release 2(9.2)
a.. The SQL statement ALTER DATABASE BACKUP CONTROLFILE makes a binary backup
of the control file.
a.. The SQL statement ALTER DATABASE BACKUP CONTROLFILE TO TRACE exports the
control file contents to a SQL script file. You can use the script to create a
new control file. Trace file backups have one major disadvantage: they contain
no records of archived redo logs, offline ranges for datafiles, and RMAN
backups and copies. For this reason, binary backups are preferable
Regards,
Dimitre
Other related posts:
