When you backup, temporary tablespace does not need to be backed up and it is not a required tablespace for creating/bringing up database. My hot backup does not include temporary tablespace and I was many times able to restore/recovery the database without any problem.
-----Original Message----- Sent: Wednesday, April 17, 2002 4:59 PM To: Multiple recipients of list ORACLE-L The poster implied he was going to change the temporary tablespace to locally managed. > > > > > to some of the other org's, so maybe staying > > > with > > > > > dictionary-managed would > > > > > be > > > > > best, except for the temporary tablespace. > > > > > > > > > > Darren. All of my production databases are still dictionary managed. I played around with locally managed tablespaces a while back on a test server, and when I ran a generic hot backup script, which attempted to dynamically put each tablespace in backup mode, it failed on the temporary tablespace. Of course all other tablespaces were successful (as you pointed out). Hopefully he would be doing this in a test environment first anyway, but I was just pointing out that he may want to test backup/recovery after converting. Rob Pegram Oracle Certified DBA --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > That's not a temp tablespace (TEMP_DATA_A). It's a > place to put temporary > load tables. My temporary tablespace is TEMP, which > is dictionary. From > the research I did on LMT's before I decided to use > them, it looked like > there were several bugs associated with temporary > tablespaces being LMT's so > I left my temporary ts dictionary. > > LK > > > > -----Original Message----- > > From: Robert Pegram [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, April 17, 2002 11:34 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Locally managed tablespaces/What a > DBA can do ? > > > > What about your locally managed "temporary" > > tablespace? > > > > > > --- "Koivu, Lisa" <[EMAIL PROTECTED]> > wrote: > > > What? I was just able to do it. 8.1.7, W2K > > > > > > (INV-SYSTEM)>@ts > > > > > > TS_NAME LMT MB_FREE MB_TOTAL > > > PCT_USED > > > --------------- ---------- --------- --------- > > > --------- > > > LOAD_DATA_A LOCAL 740 2000 > > > > 63 > > > LRG_INDEX_A LOCAL 390 2500 > > > > 84.4 > > > LRG_INDEX_B LOCAL 980 1000 > > > > 2 > > > LRG_TABLE_A LOCAL 2440 4000 > > > > 39 > > > LRG_TABLE_B LOCAL 360 1000 > > > > 64 > > > MED_INDEX_A LOCAL 480 1000 > > > > 52 > > > MED_TABLE_A LOCAL 680 1000 > > > > 32 > > > RBS DICTIONARY 299 1000 > > > > 70.1 > > > SMALL_INDEX_A LOCAL 183 200 > > > > 8.5 > > > SMALL_TABLE_A LOCAL 169 200 > > > > 15.5 > > > SYSTEM DICTIONARY 110 200 > > > > 45 > > > TEMP DICTIONARY 961 1000 > > > > 3.9 > > > TEMP_DATA_A LOCAL 900 1000 > > > > 10 > > > TOOLS LOCAL 19 20 > > > > 5 > > > USERS LOCAL 34 75 > > > > 54.7 > > > > > > 15 rows selected. > > > > > > (INV-SYSTEM)>alter tablespace load_data_a begin > > > backup; > > > > > > Tablespace altered. > > > > > > (INV-SYSTEM)>alter tablespace load_data_a end > > > backup; > > > > > > Tablespace altered. > > > > > > > > > > > > > -----Original Message----- > > > > From: Robert Pegram [SMTP:[EMAIL PROTECTED]] > > > > Sent: Wednesday, April 17, 2002 9:58 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: Locally managed tablespaces/What > a > > > DBA can do ? > > > > > > > > Darren, > > > > > > > > If using a hot backup strategy (other than > Rman), > > > > make sure to test your backup/recovery if you > > > switch > > > > the temporary tablespace to locally managed. > You > > > > can't put a locally managed temporary > tablespace > > > in > > > > backup mode. > > > > > > > > Rob Pegram > > > > Oracle Certified DBA > > > > > > > > ---------------- > > > > > > > > SQL> create tablespace temp_dict > > > > 2 datafile 'c:oracleoradataorcl > emp_dict.dbf' > > > size > > > > 10M > > > > 3 default storage (initial 1M next 1M > > > maxextents > > > > unlimited pctincrease 0) > > > > 4* temporary > > > > SQL> / > > > > > > > > Tablespace created. > > > > > > > > SQL> create temporary tablespace temp_local > > > > 2 tempfile 'c:oracleoradataorcl > emp_local.dbf' > > > size > > > > 10M > > > > 3 extent management local > > > > 4 uniform size 1M; > > > > > > > > Tablespace created. > > > > > > > > > > > > SQL> alter tablespace temp_dict begin backup; > > > > > > > > Tablespace altered. > > > > > > > > SQL> alter tablespace temp_local begin backup; > > > > alter tablespace temp_local begin backup > > > > * > > > > ERROR at line 1: > > > > ORA-03217: invalid option for alter of > TEMPORARY > > > > TABLESPACE > > > > > > > > > > > > --- "Browett, Darren" > > > <[EMAIL PROTECTED]> > > > > wrote: > > > > > Okay, maybe re-org would be a little too > much, > > > as > > > > > you say, I would need > > > > > to know the application better, and with 8 > > > > > distinctly different apps, > > > > > including > > > > > oracle financials, I maybe heading for > trouble. > > > > > > > > > > But what about simply turning the existing > > > > > dictionary-managed tablespaces > > > > > into > > > > > locally managed tablespaces, other then > > > maintenance, > > > > > would I gain > > > > > performance ? > > > > > > > > > > From what I read on this list, the growth of > my > > > > > tables is very small > > > > > compared > > > > > to some of the other org's, so maybe staying > > > with > > > > > dictionary-managed would > > > > > be > > > > > best, except for the temporary tablespace. > > > > > > > > > > Darren. > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > Sent: April 15, 2002 3:58 PM > > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > Darren - Do you have to reorganize the > vendor's > > > > > files now? The objective of > > > > > LMT's is to make Oracle more self-managing > (you > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Wong, Bing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
