OraFAQ Forum: Server Administration » recreate control file: do i need to create temp file after i mount the database

Home » RDBMS Server » Server Administration » recreate control file: do i need to create temp file after i mount the database

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

recreate control file: do i need to create temp file after i mount the database [message #321532]

Tue, 20 May 2008 11:06

skumar.dba
Messages: 82
Registered: October 2007

Member

experts,

i am in a situation like i have move database from one host to another host. now i moved all the dbf files(physical disks/file systems ).here i need to change the paths of the dbf. and i took control file trace and i made necessary changes to create control,init.ora file.(like new paths.. etc).

now i have a question. do i need to create temp table space and datafiles?

my oracle version is 9.2.0.7

Report message to a moderator

Re: recreate control file: do i need to create temp file after i mount the database [message #321548 is a reply to message #321532]

Tue, 20 May 2008 12:54

varu123
Messages: 754
Registered: October 2007

Senior Member

You are saying you moved all the datafiles including control files.
Did you restore the datafiles in the location you set during recreating control file.
If you did not restore tempfiles than you need to create it.
What is the current state of the database?
Can you login as sysdba and start the database?

Report message to a moderator

Re: recreate control file: do i need to create temp file after i mount the database [message #321564 is a reply to message #321548]

Tue, 20 May 2008 13:52

skumar.dba
Messages: 82
Registered: October 2007

Member

database is down now.
now i am making all the changes required to create control file. like
path's of dbf
path's of log files
changes in init.ora file

-- and i got a doubt with temp files.
i have moved the temp files too.
that is the reason i have posted this question.

reason why i am creating control file is while moving LUN from one server to another we got some Path problems. means on the target server already paths existed for other database.

Report message to a moderator

Re: recreate control file: do i need to create temp file after i mount the database [message #321649 is a reply to message #321564]

Tue, 20 May 2008 23:27

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

If you have restored the temp datafile to another location then, yes, you should specify that location in control file too.. Or you can specify it using alter tablespace <temptbs> add tempfile statement.

[Updated on: Tue, 20 May 2008 23:40]

Report message to a moderator

Re: recreate control file: do i need to create temp file after i mount the database [message #321750 is a reply to message #321532]

Wed, 21 May 2008 04:21

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

If control file is binary with it temp file information is not there. If it is trace then inside it temp file information is there.

If you use binary one then it will be better if you perform restore operation and then you manually create temporary tablespace.

Report message to a moderator

Previous Topic:	IS and AS
Next Topic:	REDO log status

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 02:26:57 CST 2024