Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select * from v$datafile, datafile gone offline and recovery mode! why? and Help!
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
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