On 4/18/07, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
wrote:
>
>
> RESTORE CONTROLFILE from '/somedisk/ctrlfile.bak';
>
> I have done that when testing restores from backups and it works. I must
> also make sure I am backing up my spfile and can restore it as well so
> basically I still don't understand the difference between the above
> statement and RESTORE CONTROLFILE from AUTOBACKUP;
>
>
If the controlfile has been backed up with autobackup, you don't need
to know which file to ask for. Maybe not a huge issue, but a timesaver
when you need to restore, and just extra insurance.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 18 2007 - 17:16:58 CDT
