Re: RE: Recovering WITHOUT tablespaces

Yes.

>
> From: Kumanan Balasundaram <kumanan.balasundaram_at_qxl.com>
> Date: 2001/08/17 Fri AM 10:11:10 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Recovering WITHOUT tablespaces
>
> So if I just have SYSTEM, RBS, and TEMP along with the required data TS, it
> will
> be fine to "apply archive redo logs" of the DB?
> If so, that will be great.
>
> Thanks
> Kumanan
>
> > -----Original Message-----
> > From: Jon Walthour [SMTP:jonw_at_fuse.net]
> > Sent: 17 August 2001 14:16
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Recovering WITHOUT tablespaces
> >
> > Kumanan:
> >
> > Where I work, our databases are so big that we do it this way all the
> > time. You need to restore the SYSTEM tablespace, at least one rollback
> > tablespace, and any tablespaces you're interested in recovering from.
> > You'll also need to have a copy of a 'backup controlfile to trace' script.
> > You edit that script to include on the files you're recovering and use it
> > to bring up the database.
> >
> > Jon Walthour
> > >
> > > From: Kumanan Balasundaram <kumanan.balasundaram_at_qxl.com>
> > > Date: 2001/08/17 Fri AM 07:55:29 EDT
> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > Subject: Recovering WITHOUT tablespaces
> > >
> > > Hi I need to recover the database with only a number of tablespaces from
> > HOT
> > > backup.
> > >
> > > I know I can drop it from system later on, but will it cause any
> > problems in
> > >
> > > applying archive logs with recover database statement?
> > >
> > > Any experiences/issues?
> > >
> > > Thanks
> > > Kumanan
> > >
> > >
> > >
> > > **********************************************************************
> > > This email and any files transmitted with it are confidential and
> > > intended solely for the use of the individual or entity to whom they
> > > are addressed. If you have received this email in error please notify
> > > postmaster_at_qxl.com
> > >
> > > This footnote also confirms that this email message has been swept by
> > > MIMEsweeper and Nortons Anti-Virus, for the presence of computer
> > viruses.
> > >
> > > **********************************************************************
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Kumanan Balasundaram
> > > INET: kumanan.balasundaram_at_qxl.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).
> > >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jon Walthour
> > INET: jonw_at_fuse.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kumanan Balasundaram
> INET: kumanan.balasundaram_at_qxl.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: jonw_at_fuse.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).