Re: hot-backup recovery question
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: holland@xxxxxxxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Mar 2005 23:50:34 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
