How to include tempfile in creating crontrolfile from trace

Posted on 2006-05-27
Medium Priority
Last Modified: 2008-01-09

My dictionary shows an tablespace entry TEMP01 but not the controlfile...how can add it in creating controlfile from trace
before opening the database. Is there any other option.

Thanks in advance.

Question by:bbasumatary
LVL 16

Expert Comment

ID: 16779156
First create control file from trace and mount the database. Then using "alter database add tempfile ....." command add the tempfile for temporary tablespace. Open database.
LVL 19

Accepted Solution

actonwang earned 1000 total points
ID: 16795437
when you issue "alter database backup controlfile to trace", you will see steps to recreate control file, TEMP01 is only added  back after the database is reopen and you issue:

alter tablespace temp add tempfile '...' reuse;

>>how can add it in creating controlfile..
     NO, You can not ADD TEMP01 in "create controlfile ..." because control file doesn't contain any information about tempfile and only max information, datafiles and redo log file etc.


Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month17 days, 6 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question