hot-backup recovery question 2005-03-15 - By Hemant K Chitale
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 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would get =
>error
> below
> ORA-01194 (See ORA-01194.ora-code.com): file 83 needs more recovery to be consistent
> ORA-01110 (See ORA-01110.ora-code.com): 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
|
|
