RE: Recovery from online backup

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 19 Apr 2006 11:23:07 -0400
Message-ID: <020601c663c5$28c89920$3359000a@vttaxnet.tax.state.vt.us>

When you do an online backup you need to backup the controlfile as part of the backup. The you have to recover the database using backup controlfile. If you don't have a controlfile you can try to create one. Check the docs for the correct syntax.

HTH,
Ruth

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Alessandro Vercelli Sent: Wednesday, April 19, 2006 7:04 AM
To: Oracle Freelists.org
Subject: Recovery from online backup

I'm doing some backup/recovery tests on a not-operative database, following the scenarios in:

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data base_id=NOT&p_id=94114.1

I'm using a hot backup as described at d.1-d.10 in the specified document; the backup ran without errors.

Now, after deleting all datafiles/controlfiles/redologs, I'd like to perform a restore, but the database cannot mount as no controlfile is found.

Does anybody have any suggestion?

Thanks for the help,

Alessandro

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 19 2006 - 10:23:07 CDT