Re: Recovery from online backup

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 19 Apr 2006 18:09:02 +0200
Message-ID: <00a701c663cb$94452c30$1a03310a@MPILA9>

> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 19 2006 - 11:09:02 CDT