Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: hot-backup recovery question

Re: hot-backup recovery question

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 15 Mar 2005 23:50:34 +0800
Message-Id: <6.2.0.14.0.20050315234919.04a7cc00@pop.singnet.com.sg>

Just a question :

    Do you have two seperate mirrors of the database volume and are splitting one mirror but actually attempting a recovery on another mirror ?

Hemant
At 11:09 PM Monday, Rich Holland wrote:
>I=92m trying to use a hot backup to make a copy of our production 817_32 =
>database
>using a 3rd disk mirror split operation. Here are the steps I=92m =
>taking:
>
>
> SQL> connect / as sysdba
> SQL> alter database recover automatic using backup controlfile until =
>cancel;
> SQL> alter database recover cancel;
>
>At this point, I get an error like this:
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get =
>error
> below
> ORA-01194: file 83 needs more recovery to be consistent
> ORA-01110: data file 83: '/oracle/PRD/data44/tsdata.data1'
>
>In the alert log I see errors like this:
> WARNING! Recovering data file 386 from a fuzzy file. If not the =
>current file
> it might be an online backup taken without entering the begin backup =
>command.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 15 2005 - 11:57:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US