Production DB Crash Recovery process - Some immediate advice ASAP pls 2006-02-12 - By LiShan Cheng
well he said he had this error
Using CANCEL based recovery upon attempting to open the Databse
following Error is occurring:-
ORA-01194 (See ORA-01194.ora-code.com): file 1 needs more recovery to be consistent
Isn't file 1 system.dbf?
On 2/12/06, Carel-Jan Engel <cjpengel.dbalert@(protected)> wrote:
>
> Vivek wrote 1 Datafile ( as: one datafile, a datafile, only one datafile)
> He didn't write Datafile 1 (as: the first datafile)
>
> He also wrote it was added after the last HOT backup. Datafile 1 is
> usually there since database creation, and not added afterwards.
>
> Best regards,
>
> Carel-Jan Engel
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
> On Sun, 2006-02-12 at 11:51 +0100, LiShan Cheng wrote:
>
> I am interested how did you put file 1 offline and opened the database.
> File 1 should be system tablespace, I dont think that can be offlined ever?
>
>
>
>
>
>
>
> On 2/12/06, *VIVEK_SHARMA* <VIVEK_SHARMA@(protected)> wrote:
>
>
> DATABASE is UP & OPEN Hemant, Jeremiah.
>
> Thanks indeed for all the Support
>
> It was a Case of 1 Datafile NOT being in sync with the rest of Database.
> This had been added after the Last HOT backup(being used in recovery).
>
> <SNIP>
>
>
>
>
>
<div>well he said he had this error</div>
<div> </div>
<div> </div>
<div>Using CANCEL based recovery upon attempting to open the Databse<br
>following Error is occurring:-<br><br>ORA-01194 (See ORA-01194.ora-code.com): file 1 needs more recovery to
be consistent</div>
<div> </div>
<div> </div>
<div>Isn't file 1 system.dbf?<br><br> </div>
<div><span class="gmail_quote">On 2/12/06, <b class="gmail_sendername">Carel
-Jan Engel</b> <<a href="mailto:cjpengel.dbalert@(protected)">cjpengel.dbalert
@(protected)</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">Vivek wrote 1 Datafile ( as: one datafile, a
datafile, only one datafile)<br>He didn't write Datafile 1 (as: the first
datafile)
<br><br>He also wrote it was added after the last HOT backup. Datafile 1 is
usually there since database creation, and not added afterwards.<br><br>
<table cellspacing="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td>Best regards,<br><br>Carel-Jan Engel<br><br>===<br>If you think education
is expensive, try ignorance. (Derek Bok)<br>=== </td></tr></tbody></table><span
class="q"><br><br>On Sun, 2006-02-12 at 11:51 +0100, LiShan Cheng wrote:
<blockquote type="CITE"><font color="#000000">I am interested how did you put
file 1 offline and opened the database. File 1 should be system tablespace, I
dont think that can be offlined ever?</font> </blockquote>
<blockquote type="CITE"><font color="#000000"> </font> </blockquote>
<blockquote type="CITE"><br><br><font color="#000000"> </font> <
/blockquote></span>
<blockquote type="CITE"><span class="q"><font color="#000000">On 2/12/06, <
/font><font color="#000000"><b>VIVEK_SHARMA</b></font><font color="#000000"> <
;<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:VIVEK
_SHARMA@(protected)" target="_blank">
VIVEK_SHARMA@(protected)</a>> wrote: </font><br>
<blockquote><br><font color="#000000">DATABASE is UP & OPEN Hemant,
Jeremiah.</font><br><br><font color="#000000">Thanks indeed for all the Support
</font><br><br><font color="#000000">It was a Case of 1 Datafile NOT being in
sync with the rest of Database.
</font><br><font color="#000000">This had been added after the Last HOT backup
(being used in recovery).</font><br></blockquote></span></blockquote><SNIP>
;<br>
<blockquote type="CITE">
<blockquote><br></blockquote></blockquote><br>
<table cellspacing="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td><br></td></tr></tbody></table></blockquote></div><br>
|
|
