Recovery from online backup 2006-04-19 - By Jason Heinrich
My apologies, you are correct. I wasnąt paying close enough attention to
the statement. Sorry to spread my confusion.
On 4/19/06 11:09 AM, Radoulov, Dimitre wrote:
>> > 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)
>
> The SQL statement ALTER DATABASE BACKUP CONTROLFILE makes a binary backup of
> the control file.
> 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
>
-- ---- ---- --
Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
<HTML>
<HEAD>
<TITLE>Re: Recovery from online backup</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>My
apologies, you are correct. I wasn’t paying close enough attention
to the statement. Sorry to spread my confusion.<BR>
<BR>
<BR>
On 4/19/06 11:09 AM, Radoulov, Dimitre wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><SPAN STYLE='font-size:12.0px'><FONT FACE="Arial">>
; Contrary to its syntax, this command does not actually backup the<BR>
> controlfile. Rather, it creates a trace file with the commands to
recreate<BR>
> the controlfile. <BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Arial">Incorrect!<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Arial">Backup and Recovery Concepts Release 2(9.2)<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Arial">The SQL statement ALTER DATABASE BACKUP CONTROLFILE
makes a binary backup of the control file. <BR>
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<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
<BR>
</FONT><FONT FACE="Arial">Regards,<BR>
Dimitre<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"><BR>
</FONT></SPAN></BLOCKQUOTE><SPAN STYLE='font-size:12.0px'><FONT FACE="Verdana,
Helvetica, Arial"><BR>
-- ---- ---- --<BR>
Jason Heinrich<BR>
Oracle Database Administrator<BR>
Pensacola Christian College<BR>
</FONT></SPAN>
</BODY>
</HTML>
|
|
