Re: Urgent!!! ora-01115 ora-01110 ora-27069

2002-10-23 Thread Yechiel Adar 
I now this thing. Had it two weeks ago.
Call Oracle and ask them to come with the DUL (database unload) utility.
Your database is OUT.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 8:58 AM


OS:WIN2K
DB:Oracle 9.0.1 (ArchiveLog  Production)

I'm facing those error with one my datafile. The datafile is 4GB. The
datafile is in autoextend mode, so I don't aware about the datafile
increasing, until suddenly database down:(
Unfortunetly, I've no backup at all also. The person who responsible to do
offline backup never backup the database. Some archive log is missing also:(

Please help me, to solve the problem. Any comment or suggestion I would
appreciate.

thank in advance,
~holly~

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lynxidajax
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Urgent!!! ora-01115 ora-01110 ora-27069

2002-10-23 Thread lynxidajax 
OS:WIN2K
DB:Oracle 9.0.1 (ArchiveLog  Production)

I'm facing those error with one my datafile. The datafile is 4GB. The datafile is in 
autoextend mode, so I don't aware about the datafile increasing, until suddenly 
database down:(
Unfortunetly, I've no backup at all also. The person who responsible to do offline 
backup never backup the database. Some archive log is missing also:(

Please help me, to solve the problem. Any comment or suggestion I would appreciate.

thank in advance,
~holly~

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lynxidajax
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Urgent!!! ora-01115 ora-01110 ora-27069

2002-10-23 Thread Naveen Nahata 
log a TAR with oracle. I don't think anything else can help you

Regards
Naveen

-Original Message-
From: lynxidajax [mailto:lynxidajax;myrealbox.com]
Sent: Wednesday, October 23, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Urgent!!! ora-01115  ora-01110  ora-27069


OS:WIN2K
DB:Oracle 9.0.1 (ArchiveLog  Production)

I'm facing those error with one my datafile. The datafile is 4GB. The
datafile is in autoextend mode, so I don't aware about the datafile
increasing, until suddenly database down:(
Unfortunetly, I've no backup at all also. The person who responsible to do
offline backup never backup the database. Some archive log is missing also:(

Please help me, to solve the problem. Any comment or suggestion I would
appreciate.

thank in advance,
~holly~

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: lynxidajax
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
åy«±ç­…ê~'jS‘Ä,P†Ûiÿü0ŠÚ}ªœ¢`.¶+5«ÞzsZ…«Z ѝ«Þzyڅ«Zš)ݶ·žr‰…jТ·#^·
+‘'«¾'³Î|ç9ӝa¶Úÿ
+0}«\ŠÜœ¢dšœ8ž‚€š–'è®xš1¨¥Šx%ŠËZÜn,¶)à±êï‰Ç¬N„D0åDʋ«±é_~º¶¬™¨¥Šx%ŠËlzwZœCŠYž²Æ zÚŠËFº»Ÿj×·'(šz-xEÀ
+ ;)zYbž
.+-êîjwbžØ^™ë,j86Énu楊wœ¢{ZŠx§CRP‘Ä.Ší…éڙꙨ¥Šx%ŠËr¢ìžÛhmêޚ‹Þuú虊.™¬š–Ê,zwm…áÄ,÷(šf§uú+¢Ø^®)ߢ¹š¶*'–)²æìr¸›Šx

Re: Urgent!!! ora-01115 ora-01110 ora-27069

2002-10-23 Thread Michael Ivanov 
Holly.
I look for your errors descriptions
$ oerr ORA 01115
01115, 0, IO error reading block from file %s (block # %s)
// *Cause:  Device on which the file resides is probably offline
// *Action: Restore access to the device
$ oerr ORA 01110
01110, 0, data file %s: '%s'
// *Cause:  Reporting file name for details of another error
// *Action: See associated error message
$ oerr ORA 27069
27069, 0, skgfdisp: attempt to do I/O beyond the range of the file
// *Cause:  internal error, the range of blocks being read or written is
//  outside the range of the file, additional information indicates
//  the starting block number, number of blocks in I/O, and the
//  last valid block in the file
// *Action: check for trace file and contact Oracle Support

I think that you need to run next command as sysdba
alter tablespace YOUR_TABLESPACE_NAME add file 
'NEW_FILE_PATH_FOR_TABLESPACE' 

 OS:WIN2K
 DB:Oracle 9.0.1 (ArchiveLog  Production)

 I'm facing those error with one my datafile. The datafile is 4GB. The
 datafile is in autoextend mode, so I don't aware about the datafile
 increasing, until suddenly database down:( Unfortunetly, I've no backup at
 all also. The person who responsible to do offline backup never backup the
 database. Some archive log is missing also:(

 Please help me, to solve the problem. Any comment or suggestion I would
 appreciate.

 thank in advance,
 ~holly~

-- 
Best regards
Michael Ivanov, TD ERA
•æ¬zǞ¶¨}øœ‰©ND‹±Bm§ÿðÃ
+iöªr‰€ºØh¬Èœ…§¥ö§¢ò
9¢½©è¾×^­ªî«BŠÜzÜ(®Dž®øœzÏ9óüçNu†Ûiÿü0Áö­r+rr‰’jpâz
jXŸ¢¹âhÆ¢–)à–+-jwpy¸h²Ø§‚Ç«¾'±:Õ*.®Ç¥}úèšØb²f¢–)à–+-±éÝjq
j)fzˁëh.+-êî}«\ŠÜœ¢ièµá$ì¥éeŠx(|¸¬´k«¹©ÝŠ{azg¬±¨à؊w%¹×š–)Þr‰íj)âž
IND‹º+¶§jg¨~f¢–)à–+-ʋ°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ‡³Ü¢iš×讋az¸§~ŠæjبžX¤z˛±Êân)à

Urgent!!! ora-01115 ora-01110 ora-27069

2002-10-22 Thread lynxidajax 
OS:WIN2K
DB:Oracle 9.0.1 (ArchiveLog  Production)

I'm facing those error with one my datafile. The datafile is 4GB. The datafile is in 
autoextend mode, so I don't aware about the datafile increasing, until suddenly 
database down:(
Unfortunetly, I've no backup at all also. The person who responsible to do offline 
backup never backup the database. Some archive log is missing also:(

Please help me, to solve the problem. Any comment or suggestion I would appreciate.

thank in advance,
~holly~

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lynxidajax
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).