Re: temp datafiles not on restore tapes

Afternoon J Dex,

Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051

>>> "J. Dex" 01/06/06 03:06pm >>>
>> I am trying to stand up a database from a tape restore and rename
it. The
>> restore did not include any of the temp datafiles but I think I know
what
>> the temp tablespace had been called. How should this be addressed?
In the
>> create controlfile script, should I have an alter tablespace petemp
add
>> datafile.... or will I have to create a new temp tablespace? Can
the temp
>> tablespace be created after the database is opened?

is your temp tablespace in a 8i, 9i or 10g database ? If so, you don't need to backup the assorted TEMPFILES (see dba_temp_files) and if you need a restore, you simply do something like :

ALTER TABLEPSACE TEMP
ADD TEMPFILE 'full path' SIZE xxx REUSE;

And new files will be created for you. Old files, that exist, will be reused - assuming no checks are done on the size that is.

You can find the command(s) to do this at the end of a ALTER ... BACKUP CONTROLFILE TO TRACE; Cheers,
Norman.

[Yipee, I remembered to REPLY ALL !]

Information in this message may be confidential and may be legally privileged. If you have \ received this message by mistake, please notify the sender immediately, delete it and do \ not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any \ attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom \ of Information Act, Data Protection Act or for litigation. Email messages and attachments \ sent to or from any Environment Agency address may also be accessed by someone other than \ the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and \ conditions which you can get by calling us on 08708 506 506. Find out more about the \ Environment Agency at http://www.environment-agency.gov.uk

--
http://www.freelists.org/webpage/oracle-l