Recovery from online backup 2006-04-19 - By Radoulov, Dimitre
> 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial size=2>> 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. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Incorrect!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Backup and Recovery Concepts Release
2(9.2)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<LI class=LB1 type=disc><A name=1004785></A><FONT face=Arial size=2>The SQL
statement ALTER DATABASE BACKUP CONTROLFILE makes a binary backup of the
control
file. </FONT>
<LI class=LB1 type=disc><A name=1004786></A><FONT face=Arial size=2>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</FONT></LI></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Dimitre</FONT></DIV></BODY></HTML>
|
|
