Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Database recovery problem

Database recovery problem

2005-09-20       - By Mercadante, Thomas F (LABOR)

Reply:     1     2     3     4     5     6     7     8     9     10     >>  

Onkar,



It is asking for an archive file because the dummy file that you created
is not an Oracle database file.  So it is trying to bring it up to date.
Even though you are not running in archivelog mode, Oracle still acts
the same way - that is, it is keeping track of what would be the correct
archivelog file even though it did not write them out to disk.



You have one option:



Startup mount;

Alter datafile 'D:\DB\ORADATA\BODEV\NMSANDBOX_DATA.ORA' offline.

Alter database open.



You will be able to export all of the data in the database except what
was stored in this data file.  This will allow you to import it into
another database.



So all of your data is not gone - just the stuff in this
file/tablespace.  Everything else has been lost.



Good Luck!



Tom

__ ____ ____ ____ ____ ____ ____

From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Onkar N Tiwary
Sent: Tuesday, September 20, 2005 7:55 AM
To: oracle-l@(protected)
Subject: Database recovery problem



hi all,



We have got one oracle 9i rel 2 on windows 2000 running in no-archive
log mode. the problem is one of the dba of the other team has deleted
some of the dbf files while the database was running and tablespace was
online. after deleting the file he re-started the database which while
opening throw error saying that file needs recovery. I was told to do
this . I have created the dbf files also but while recovering the dbfs
using RECOVER DATAFILE ' 'D:\DB\ORADATA\BODEV\NMSANDBOX_DATA.ORA';
command its asking for the archive files . output is below mentioned :


SQL> recover datafile 'D:\DB\ORADATA\BODEV\NMSANDBOX_DATA.ORA';
ORA-00279 (See ORA-00279.ora-code.com): change 38062424 generated at 05/13/2005 00:52:05 needed for
thread 1
ORA-00289 (See ORA-00289.ora-code.com): suggestion : F:\ORACLE\ORA92\RDBMS\ARC00397.001
ORA-00280 (See ORA-00280.ora-code.com): change 38062424 for thread 1 is in sequence #397


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

I dont know why its asking for the archive files.??? Btw the team who is
owning the database has not taken any backup. If anyone has got the
problem like this , plz. share ur experience so that I can perform this.



TIA



--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
      to_onkar@(protected)
      onkarnath.tiwary@(protected)



<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1=
"urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC
-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"
downloadurl="http://www.5iamas-microsoft-com:office:smarttags"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place" downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:blue;
  text-decoration:underline;}
p
  {mso-margin-top-alt:auto;
  margin-right:0in;
  mso-margin-bottom-alt:auto;
  margin-left:0in;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.EmailStyle18
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Onkar,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>It is asking for an archive file because
the dummy file that you created is not an Oracle database file. &nbsp;So it is
trying to bring it up to date. &nbsp;Even though you are not running in
archivelog
mode, Oracle still acts the same way &#8211; that is, it is keeping track of
what would be the correct archivelog file even though it did not write them out
to disk.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You have one option:<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Startup mount;<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Alter datafile </span></font>'D:\DB
\ORADATA\BODEV\NMSANDBOX_DATA.ORA'
offline.<o:p></o:p></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Alter database open.<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You will be able to export all of the data
in the database except what was stored in this data file.&nbsp; This will allow
you
to import it into another database.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>So all of your data is not gone &#8211;
just the stuff in this file/tablespace. &nbsp;Everything else has been lost.<o
:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Good Luck!<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Tom<o:p></o:p></span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b><st1:PersonName w:st="on">Onkar
N Tiwary</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, September 20, 2005
7:55 AM<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> Database recovery problem
</span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>hi all,<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>We have got one oracle 9i rel 2 on windows 2000 running in no-archive
log mode. the problem is one of the dba of the other team has deleted some of
the dbf files while the database was running and tablespace was online. after
deleting the file he re-started the database which while opening throw error
saying that file needs recovery. I was told to do this . I have created the dbf
files also but while recovering the dbfs using RECOVER DATAFILE
'&nbsp;'D:\DB\ORADATA\BODEV\NMSANDBOX_DATA.ORA'; command its asking for the
archive files . output is below mentioned : <o:p></o:p></span></font></p>

</div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><br>
SQL&gt; recover datafile 'D:\DB\ORADATA\BODEV\NMSANDBOX_DATA.ORA';<br>
ORA-00279 (See ORA-00279.ora-code.com): change 38062424 generated at 05/13/2005 00:52:05 needed for thread 1
<br>
ORA-00289 (See ORA-00289.ora-code.com): suggestion : F:\ORACLE\ORA92\RDBMS\ARC00397.001<br>
ORA-00280 (See ORA-00280.ora-code.com): change 38062424 for thread 1 is in sequence #397<o:p></o:p></span><
/font></p>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><br>
Specify log: {&lt;RET&gt;=suggested | filename | AUTO | CANCEL}<o:p></o:p><
/span></font></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I dont know why its asking for the archive files.??? Btw the team who
is owning the database has not taken any backup. If anyone has got the problem
like this , plz. share <st1:City w:st="on"><st1:place w:st="on">ur</st1:place><
/st1:City>
experience so that I can perform this.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>TIA<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br clear=all>
<br>
-- <br>
Thanks &amp; Regards,<br>
T. Onkar Nath<br>
OneAPPS Enterprise Technology Pvt. Ltd.<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="mailto:to_onkar@(protected)">to
_onkar@(protected)</a><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="mailto:onkarnath.tiwary@(protected)
">onkarnath.tiwary@(protected)</a><br>
&nbsp;<o:p></o:p></span></font></p>

</div>

</div>

</body>

</html>