RE: Locally Managed Tablespace Survey

You CAN use RMAN to backup locally managed.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Elliott, Patrick
Sent: Friday, June 16, 2000 12:10 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Locally Managed Tablespace Survey

What about RMAN and local tablespaces? I have heard that you cannot use RMAN to backup local tablespaces. Is this true?

> -----Original Message-----
> From: Charlie Mengler [SMTP:charliem_at_mwh.com]
> Sent: Friday, June 16, 2000 12:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Locally Managed Tablespace Survey
>
> Another way under V8.1.6 is to -
>
> The statement to convert TBS_1 to a locally managed tablespace is as
> follows:
>
> EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL ('tbs_1');
>
> HTH & YMMV!
>
> Oracle General wrote:
> >
> > Here's a quote from the Oracle Applications 11i Upgrade Manual. This I
> guess
> > clearly shows Oracle's direction.
> > -------------------------------------------------------------------
> > Oracle Applications recommends the use of local extent management to
> > increase performance. To convert all non-SYSTEM tablespaces from Data
> > Dictionary extent management to local extent management, run the
> following
> > script:
> > From the UNIX prompt:
> > $ cd $APPL_TOP/admin/preupg
> > $ sqlplus <SYSTEM username>/<SYSTEM password> @adtbscnv.pls \
> > <SYSTEM password>
> > --------------------------------------------------------------------
> >
> > Manish
> > -----Original Message-----
> > Sent: Thursday, June 15, 2000 7:17 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Jonathon,
> >
> > While I haven't used them yet, the instructor of the internals class I
> took
> > said that Oracle is advocating locally managed tablespaces these days.
> And
> > that in a future release, SYSTEM will also be able to be created as
> locally
> > managed.
> >
> > Rachel
> >
> > >From: Jonathan Gennick <jonathan_at_gennick.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: Locally Managed Tablespace Survey
> > >Date: Thu, 15 Jun 2000 11:49:16 -0800
> > >
> > >I'm writing a magazine article on locally managed
> > >tablespaces, and I'd like to get some opinions and feedback
> > >from anyone who might be using these in a production
> > >environment. If you are using locally managed tablespaces,
> > >and you could find the time to answer the following
> > >questions, I'd be grateful. I'm sure others on this list
> > >would find the answers interesting as well.
> > >
> > >
> > >Are you currently using locally managed tablespaces in a
> > >production environment?
> > >
> > >Do you see locally managed tablespaces as the preferred
> > >tablespace type going forward?
> > >
> > >Have you kept any tablespaces as dictionary managed, and
> > >why?
> > >
> > >Have you used the AUTOALLOCATE feature to allow Oracle to
> > >size your extents automatically?
> > >
> > >Have you encountered any specific problems with locally
> > >managed tablespaces that other DBAs should be aware of?
> > >
> > >Do you over use DBMS_SPACE_ADMIN to verify or fix the
> > >bitmaps in your locally managed tablespaces? Do you do this
> > >on a regular basis, or only when a problem occurs?
> > >
> > >Have you ever had a problem where you _needed_ to run
> > >DBMS_SPACE_ADMIN in order to fix it?
> > >
> > >Have you noticed any measurable performance improvement as a
> > >result of using locally managed tablespaces?
> > >
> > >
> > >
> > >That's it. Not too many questions, I hope. Of course, if you
> > >can think of anything useful to add that I havn't asked
> > >about, that would be great too.
> > >
> > >Thanks,
> > >
> > >Jonathan
> > >
> > >_____________________________________________________
> > >jonathan_at_gennick.com
> > >http://gennick.com
> > >Brighten the Corner Where You Are
> > >--
> > >Author: Jonathan Gennick
> > > INET: jonathan_at_gennick.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).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_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).
> > --
> > Author: Oracle General
> > INET: OracleGeneral_at_mwd.dst.ca.us
> >
> > 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).
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 5505 Morehouse Drive
> 858-552-6229 San Diego, CA 92121
> Always be sincere about your enthusiasm, whether you mean it or not.
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.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).

--
Author: Elliott, Patrick
  INET: Patrick.Elliott_at_bestbuy.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