Re: ORA-01113_ file 1 needs media recovery
Date: Sun, 26 Apr 2009 17:17:22 -0700 (PDT)
Yes, the database isd too old and we are in the process of migrating to a different system and just happened to be down before we could extract the required information (whole content of four data tables) for the new system.
Anyway, we had two contoel files on this system. the startup process recognise only one control file and we managed to bypass the contol file error by copying the recognised control file into the raid5 folder then edit 'init.ora' file.
Is there any danger to force database startup so as to enable us exract/dump content of certain data tables? How? Any suggestions will be usefule.
On Apr 26, 4:57 pm, Michael Austin <maus..._at_firstdbasource.com> wrote:
> Gassamaba wrote:
> > Hi,
> > Please find below an error screenshot. The system failed last week and
> > we did recovery from the tape backup. Initially, there was error
> > Message 4505 then Control_File mismatch errors but we managed to
> > bypass all. Now, the database can be mounted but with this error as
> > indicated below.
> > Is there any possibility to bypass this error/corrupt file so as we
> > get access to the database and generate the dump of data?
> > ======================screen shot...=-==================
> > Alias LISTENER
> > Version TNSLSNR for HPUX: Version 18.104.22.168.0 -
> > Production
> > Start Date 25-APR-09 22:44:45
> > Uptime 0 days 0 hr. 0 min. 0 sec
> > Trace Level off
> > Security OFF
> > SNMP OFF
> > Listener Parameter File /etc/listener.ora
> > Listener Log File /oracle/ora734/network/log/listener.log
> > Services Summary...
> > e_GA has 1 service handler(s)
> > p_GA has 1 service handler(s)
> > t_GA has 1 service handler(s)
> > The command completed successfully
> > ora734_at_ONLINE:/oracle/ora734/dbs>svrmgrl
> > Oracle Server Manager Release 22.214.171.124.0 - Production
> > Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
> > Oracle7 Server Release 126.96.36.199.0 - Production
> > PL/SQL Release 188.8.131.52.0 - Production
> > SVRMGR> connect internal
> > Connected to an idle instance.
> > SVRMGR> startup
> > ORACLE instance started.
> > Total System Global Area 34204208 bytes
> > Fixed Size 38984 bytes
> > Variable Size 23761384 bytes
> > Database Buffers 10240000 bytes
> > Redo Buffers 163840 bytes
> > Database mounted.
> > ORA-01113: file 1 needs media recovery
> > ORA-01110: data file 1: '/raid5/BASE/e_GA/SYSTEMe_GA.dbf'
> > ========================
> > Thanks
> > Gassamaba
> Now you are really taxing the brain here as 7.3.4 is way too old to be
> doing anything useful. The corrupt data file appears to be the system
> tablespace. How did you "bypass all". You cannot attach "screen shots"
> in Usenet as most readers do not see them... What is the text of the
> 4505 error message?
> what happens when you:
> recover data file <datafile>;
> recover database;
> ??- Hide quoted text -
> - Show quoted text -
Received on Sun Apr 26 2009 - 19:17:22 CDT