Re: select * from v$datafile, datafile gone offline and recovery mode! why? and Help!

From: Shmuel Duek <shmueld_at_aviv.co.il>
Date: 5 May 1998 17:48:51 GMT
Message-ID: <01bd7855$cd5e3b20$858ecbc7@shmueld.aviv.co.il>

hi steven

your database probably crashed and needs recovery . shutdown, startup mount, alter database recover datafile .... --

Shmuel Duek
Infrastructure
D.b.a. & Sysadmin
Aviv Advanced Solutions
8 Lavontin St.
Tel Aviv 65111
Israel

Tel: 972-3-566-0050
Fax: 972-3-566-0020
Mobile: 972-50-715-479

Home: 972-3-550-5226
Email: shmueld_at_aviv.co.il

  	   O                                       //
       >==-{  -<                      .--._.-^-).{
        ('                          /}        ) \d
       ./\,                           ( -._.- <
      /  /                             `\    /'

MEYOU_at_ComPorts.com wrote in article
<354dff5e.16376617_at_news.netvigator.com>...
> Platform: Solaris 2.5.1
> Oracle 7.3.3
>
> Hi all,
>
> We have a serious problem with our oracle databases,
>
> when issue below statement from within sqlplus
>
> select * from v$datafile
>
> we have strange error such as datafile gone offline and recovery mode!
>
> Can anyone help as the deadline is very near.
>
> Thanks in advance.
>
>
> Regards
>
> Steven
>
>
>
>
>
Received on Tue May 05 1998 - 12:48:51 CDT