OraFAQ Forum: Server Administration » Issue with temporary tablespace

Home » RDBMS Server » Server Administration » Issue with temporary tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue with temporary tablespace [message #179231]

Mon, 26 June 2006 07:49

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hi,

can we backup the temp tablespace using RMAN...?
will export utility consider objects in the temp tablespace for export backup..?

plz help...

regards
bala

[Updated on: Mon, 26 June 2006 08:02]

Report message to a moderator

Re: Issue with temporary tablespace [message #179233 is a reply to message #179231]

Mon, 26 June 2006 07:54

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Why would you back up a temp tbs?
the key is in its name, i.e. it is Temporary, transient, impermanent ..... fleeting .... err momentary ....... that's all i've got Smile

The point is that you don't backup temp tablespaces, you simply recreate them if needs be.

HTH
Jim

Report message to a moderator

Re: Issue with temporary tablespace [message #179234 is a reply to message #179231]

Mon, 26 June 2006 07:57

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

What does the documentation say?

Report message to a moderator

Re: Issue with temporary tablespace [message #179235 is a reply to message #179234]

Mon, 26 June 2006 07:59

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

c'mon Mahesh, there's no WAY something like that would be in the documentation ......
Laughing

Report message to a moderator

Re: Issue with temporary tablespace [message #179236 is a reply to message #179233]

Mon, 26 June 2006 07:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just to add, RMAN will not even 'see' the temp tablespace

RMAN> connect target sys/sys

connected to target database: MUTATION (DBID=2135294536)

RMAN> report schema;

using target database controlfile instead of recovery catalog
Report of database schema
File K-bytes    Tablespace           RB segs Datafile Name
---- ---------- -------------------- ------- -------------------
1        256000 SYSTEM               ***     /u01/app/oracle/oradata/mutation/system01.dbf
2        522240 UNDOTBS1             ***     /u01/app/oracle/oradata/mutation/undotbs01.dbf
3         25600 INDX                 ***     /u01/app/oracle/oradata/mutation/indx01.dbf
4         10240 TOOLS                ***     /u01/app/oracle/oradata/mutation/tools01.dbf
5        704000 USERS                ***     /u01/app/oracle/oradata/mutation/users01.dbf
6             0 mytbs1               ***     /tmp/1.dbf

Report message to a moderator

Re: Issue with temporary tablespace [message #179240 is a reply to message #179235]

Mon, 26 June 2006 08:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Yeah. Absolutely. That was an outrageous claim that i made.

Report message to a moderator

Re: Issue with temporary tablespace [message #179241 is a reply to message #179240]

Mon, 26 June 2006 08:12

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

LOL, Well, you can hardly expect Oracle to think of everything

Report message to a moderator

Re: Issue with temporary tablespace [message #179244 is a reply to message #179231]

Mon, 26 June 2006 08:18

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

OP wrote:
>> will export utility consider objects in the temp tablespace for export backup..?
Definately time to read a decent book on Oracle.
To answer the question, NO.
Export will NOT see anything in the temp tablespace.

Report message to a moderator

Previous Topic:	PLS-00123
Next Topic:	Exporting transportable tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:50:18 CDT 2024