| 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: [Re: [Re: standby DB in archivelog ?]]
I am talking about 8.1.6.
"ARUN K C" <arun_k_c_at_hotmail.com> wrote:
> Hello,
> Can you tell me on which version apart from 8.1.6 are you talking as re=
ad =
> only
> =
> =
> >From: Yigal Ran <ydran_at_usa.net>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: [Re: standby DB in archivelog ?]
> >Date: Fri, 29 Sep 2000 08:35:51 -0800
> >
> >It can also be in a READ ONLY mode.
> >
> >
> >K Gopalakrishnan <kaygopal_at_yahoo.com> wrote:
> > > Hi !
> > >
> > > Of course YES> Stabdby database will be in Recovery
> > > mode always.
> > >
> > >
> > > --- Rahul <rahul_at_ratelindo.co.id> wrote:
> > > > Lsit,
> > > > should a standby database be run in archivelog mode
> > > > ?
> > > >
> > > > TIA
> > > > Rahul
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > --
> > > > Author: Rahul
> > > > INET: rahul_at_ratelindo.co.id
> > > >
> > > > 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).
> > >
> > >
> > > =3D=3D=3D=3D=3D
> > > Warm Regards,
> > > K Gopalakrishnan
> > > Bangalore, INDIA
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
> > > http://photos.yahoo.com/
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: K Gopalakrishnan
> > > INET: kaygopal_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=
> > > San Diego, California -- Public Internet access / Mailing Li=
sts
> > > -------------------------------------------------------------------=
-
> > > 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)=
=2E
> >
> >
> >____________________________________________________________________
> >Get free email and a permanent address at http://www.amexmail.com/?A=3D=
1
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Yigal Ran
> > INET: ydran_at_usa.net
> >
> >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).
> =
> _______________________________________________________________________=
__
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.co=
m.
> =
> Share information about yourself, create your own public profile at =
> http://profiles.msn.com.
> =
> -- =
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- =
> Author: ARUN K C
> INET: arun_k_c_at_hotmail.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).
From: Winnie_Liu_at_infonet.com
Date: Fri, 29 Sep 2000 09:55:55 -0700
Subject: RE: case of MISSINGnnn datafile
If you cannot open the database, there is NO WAY you can take the tablespace offline.
As he is running in noarchive mode. There is no way to recover that tablespace alone. THe only thing that he can do is to recover it from the old cold backup. (if he need that tablespace badly).
If he does not need that tablespace, he can bring all the datafiles associating to that tablespace offline drop, open the database and then drop the whole tablespace.
Winnie
> -----Original Message-----
Received on Fri Sep 29 2000 - 13:14:29 CDT
 |
 |