Yes, why?
The implication is you are willing to give up on the hot backup, just to
get a copy of the tempfiles, (not good). Instead give up putting the
temp tablespaces in backup mode and copying the tempfiles, (it'll save
space at the destination).
But, Like Groot said. Of course you can shut down and take a cold
backup, even of the entire server if you want.
When you restore, the tablespace definitions will exist, and you can add
the tempfiles -- (see note below on trace controlfile).
-----Original Message-----
From: Groot A.F.H. de
[mailto:oracledba-ezmlmshield-x58619294.[Email address protected]
Sent: Wednesday, June 22, 2005 9:22 AM
To: LazyDBA Discussion
Subject: RE: temp tablespace
No Flame Intended
Tonny de Groot
DienstenCentrum van:
College voor zorgverzekeringen / College Toezicht Zorgverzekeringen
-----Oorspronkelijk bericht-----
Van: Groot A.F.H. de [mailto:oracledba-ezmlmshield-x68969577.[Email
address protected]
Verzonden: woensdag 22 juni 2005 15:20
Aan: LazyDBA Discussion
Onderwerp: RE: temp tablespace
Hi all,
Not to be a pain in the ass but the question is "can I take a cold
backup"
Yes you can.
But ask your self the question why?
Temporary Tablespace is just that temporary it is there for the
database.
The data there in is after the operation is completed useless.
Tonny de Groot
DienstenCentrum van:
College voor zorgverzekeringen / College Toezicht Zorgverzekeringen
-----Oorspronkelijk bericht-----
Van: Patterson Joel [mailto:oracledba-ezmlmshield-x29117424.[Email
address protected]
Verzonden: woensdag 22 juni 2005 15:06
Aan: LazyDBA Discussion
Onderwerp: RE: temp tablespace
If you are creating your own hot backup, (like me), I like to include
the trace controlfile: alter database backup controlfile to trace as
'<file_name>';
Inside you will already have available stuff you can use like creating
the tempfiles for the temporary tablespaces, (the definitions of the
tablespaces will have already been restored from the system tablespace).
It is also just a handy thing to have with all your other files.
-----Original Message-----
From: Rahul Dutta
[mailto:oracledba-ezmlmshield-x20987659.[Email address protected]
Sent: Wednesday, June 22, 2005 8:31 AM
To: LazyDBA Discussion
Subject: RE: temp tablespace
Backing up of Temp Tablespace is not reqd...
Just create a new temp tablespace wherever you restore it.
Regards,
Rahul Dutta
-----Original Message-----
From: Fathy Neveen
[mailto:oracledba-ezmlmshield-x66868081.[Email address protected]
Sent: Wednesday, June 22, 2005 6:00 PM
To: LazyDBA Discussion
Subject: temp tablespace
I tried to take hot backup of temporary table space
>> alter tablespace temp begin backup;
But it gives error; can I take a cold backup of temporary table space in
oracle 9i?
Regards
Neveen Elsayyad
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _
Disclaimer:
The Information contained in this transmission may be confidential
and legally privileged.
If you are not the intended recipient, please advise the sender and
delete
this transmission and all copies.
Any views or opinions expressed in this email are solely by the author
and not
necessarily those of PGESCo.
PGESCo is not responsible for any political, religious, racial or
partisan opinion
in any correspondence conducted by its domain users. Therefore, any such
opinion
expressed, whether explicitly or implicitly, in any said correspondence
is not to be interpreted as that of PGESCo.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page