| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deep Doo-Doo
TAR Number 1766421.999 Open Date 13-AUG-01 16:14:03 Support Identifier 3223081 Name Dave Farnsworth Priority 2 Last Update 13-AUG-01 18:02:05 Product Oracle Server - Enterprise Edition Product Version 8i Platform MS Windows NT Detailed Status Soft Close TAR Reference n/a BUG Reference n/a
Abstract
I have a couple of bad data files and no backups.
Resolution History
13-AUG-01 16:14:03 GMT
Can you easily recover from, bypass or work around the problem? = NO
Does your system or application continue normally after the problem occurs?
=
NO
Are the standard features of the system or application still available; is
the
loss of service minor? = NO
### Platform and O/S version, including patchset or service pack level? ### NT 4.0 SP6
### What version and patchset level of the database are you running? ### 8.1.7
### Please describe your problem: ###
During last nights backup something caused the backup to hang. I do a cold
backup nightly and the backup is run from a script that is scheduled nightly
at
midnight. It does a disk to disk copy and then area that is copied to is
suppose to go to tape. When I got to work this morning I could not connect
to
my DB so I went to the server. There were no error messages and no
programs(like a DOS window) opened up. I could see that the backups had
copied
only three of my datafiles to the backup directory. I did a shutdown abort
and
then did a startup. After it started up I saw in the <SID>Alrt.log this
error;
Errors in file I:\orant\admin\DISPATCH\bdump\dispatchLGWR.TRC:
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF' ORA-01114: IO error writing block to file 10 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.
recovery from the nightly backup but that also gave the same error. It is
like
something corrupted a data file during the backup. I then thought I would
take
it off of a tape from Saturday night but was informed that these tapes did
not
exist(surprise, surprise).
So I have a database that is down with no backup that is any good. What are
my
options??
Thanks,
Dave
### If you are receiving errors, please list exact error messages and text:
###
ORA-01113: file 10 needs media recovery
Text continued in next action...
13-AUG-01 16:15:04 GMT Text continued from previous action...
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF' ORA-01113: file 10 needs media recovery ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF' ORA-01113: file 8 needs media recovery ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF' ORA-01113: file 10 needs media recovery ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
### Did the error generate a trace file? ### No
#### Remote Diagnostic Agent ####
Unknown
### What was being done at time of error? Any changes since this last
worked? ##
cold backups. There were no changes to any of the backup scripts.
### Can error be generated if SQL is run in SQL*PLUS or Server Manager? ### Does not apply
### What is the frequency of the error? ### Consistently
### What is the impact to your business because of this problem? ### This is a production database. I need help ASAP.
Error : ora-01113
Contact me via : Telephone -> 608-323-6733
13-AUG-01 16:36:30 GMT The OS5 error, I am told, indicates that some other process had the file locked while you were trying to access it. At this point, try bringing the database to a MOUNT state, and issue the RECOVER DATABASE command. There are some log files which may be available and the DB should find them. If not...
Calling Dave... goes to vm; left message suggesting above.
13-AUG-01 16:40:58 GMT already assigned
13-AUG-01 16:53:02 GMT
New info : Michael,
Can you please call. I got your message about the recovery tools that Oracle
has. I would appreciate if you can walk me through this process. I am also
going to try calling you.
Thanks,
Dave
13-AUG-01 17:37:29 GMT calling...
13-AUG-01 17:40:22 GMT Client will try to RECOVER and will update TAR.
13-AUG-01 18:02:05 GMT
Closed by customer
Michael,
Thanks a ton!! It worked like a charm. My database is up and running. This
TAR can be closed.
Thanks,
Dave
-----Original Message-----
Sent: Friday, August 17, 2001 12:25 AM
To: Multiple recipients of list ORACLE-L
Hi,
I tried to view the TAR posted by you, But it said that I don't have
sufficient privileges to view the TAR.
Can u pl send me a copy of the TAR 1766421.999.
TIA
venkat
-- On Thu, 16 Aug 2001 05:10:58 Farnsworth, Dave wrote:Received on Fri Aug 17 2001 - 06:41:00 CDT
>I did this from svrmgrl. The database was shutdawn at the time.
>
>svrmgrl>STARTUP MOUNT
>svrmgrl>RECOVER DATABASE
>svrmgrl>STARTUP
>
>That was it. It worked like a charm. You can also view my
TAR(1766421.999)
>for the blow by blow details.
>Oh yea, my dad got out of the hospital last night. He has an infection but
>they do not know the source. His temperature is back to normal, it was
>105(fahrenhiet). Thanks to all for their thoughts!!
>
>Dave
>
>
>-----Original Message-----
>Sent: Thursday, August 16, 2001 3:31 AM
>To: DFarnsworth_at_Ashleyfurniture.com
>
>
>Hi,
>Can u share your experience, what solution did support gave to open the
>database. It will be useful for other databases.
>
>TIA
>Best Regards
>Venkat
>--
>
>On Mon, 13 Aug 2001 11:30:37
> Farnsworth, Dave wrote:
>>Ron,
>>
>>Thanks, I opened a TAR with Oracle and their support person gave the
>>solution in a fairly quick manner. I used the "recover database" command.
>>My database came back up and is running fine now. The network admin is
>>happy to!! I'll bet that there will ba a tape backup tomorrow!!!
>>
>>Dave
>>
>>-----Original Message-----
>>Sent: Monday, August 13, 2001 1:52 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Dave,
>>I hope all is okay with your father.
>>It sounds like you still have some datafiles that are still under the
>>control of the os backup script. If you did a cold backup and it was still
>>hung, who started the database up where you had to shutdown abort? Did the
>>alert log show any problems with the startup after the backup time? Was
the
>>database shutdown to do the backup?
>>Dig deep and good luck.
>>ROR mª¿ªm
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: DFarnsworth_at_Ashleyfurniture.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
 |
 |