Re: Recovery from online backup

From: Jason Heinrich <jheinrich_at_pcci.edu>
Date: Wed, 19 Apr 2006 10:59:58 -0500
Message-ID: <C06BC8AE.10FB7%jheinrich@pcci.edu>

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. Open it up with a text editor and copy the correct lines into SQL*Plus while connected to an idle instance of your database. Note that there are two sets of commands, to recreate the controlfile with or without resetting the logs.

On 4/19/06 10:47 AM, Alessandro Vercelli wrote:

> alter database backup controlfile to '<destination_path/file>'

---

Jason Heinrich
Oracle Database Administrator
Pensacola Christian College

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

Received on Wed Apr 19 2006 - 10:59:58 CDT