Re: ORA-01113_ file 1 needs media recovery

From: joel garry <joel-garry_at_home.com>
Date: Mon, 27 Apr 2009 16:02:36 -0700 (PDT)
Message-ID: <c73abbad-7c54-42bc-aa8a-3c3ae9a1a3db_at_d7g2000prl.googlegroups.com>

On Apr 26, 8:15 am, Gassamaba <ogs..._at_gmail.com> 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 2.3.4.0.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 2.3.4.0.0 - Production
>
> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
> Oracle7 Server Release 7.3.4.0.0 - Production
> PL/SQL Release 2.3.4.0.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

You first want to back up everything you have right now.

You want to see what archivelogs you have, and what datafiles you can get.

Then look up the using backup controlfile until cancel syntax.

Then don't do anything until you answer David's questions.

Then put this system out of its misery.

jg

--
_at_home.com is bogus.
http://www3.signonsandiego.com/stories/2009/apr/27/1m27prejean23927-prejean-stands-her-beliefs/?metro&zIndex=89226

Received on Mon Apr 27 2009 - 18:02:36 CDT