shutdown oracle on hpux

[Manu_13]

I have oracle 8.1.7.
I am trying to intall VPO 7.X server on the machine. I was trying configuring database. By mistake i removed some control files. not I am not able to shutdown the database.

any solution for this?

manu.

[RAC_1]

Reboot the box.
On svrmgrl, shutdown immedaiet
If that does not help then shutdown abort

Anil

[Jean-Luc Oudart]

Manu,

If I understand you stil have a "good" control file.
shutdown abort
copy good control file to the lost one (location and name)
re-start database

check Metalink 289540.995 "Will the database still run if 1 of my 3 control files is corrupted? "

Regards
Jean-Luc

[Peter Godron]

Manu,
location of the control files is in
$ORACLE_HOME/dbs/sp.ora
Replicate the good file to the other location and you should be ok to restart.
Regards

[Steven E. Protter]

I agree with the above analysis.

If shutdown abort does not work, you may need to kill the database processes individually.

SEP

[Manu_13]

Hi,

I am novice in oracle stuff and i wanted to know wht is good file and where is it located? will the location be mentioned in the *.ora file ? there three control files for openview SID and i have removed all of them.

thnx,
manu

[Manu_13]

hi,

I rebooted the machine and the problem is solved. thanks for the help. Stil i wanna know what id good control file and where wil it be?

thanks,
Manu

[Jean-Luc Oudart]

Manu,

If you lost all your control files it is still possible to re-create them.
(You mentione "some" and my undertanding was you still had a good one, hence previous post).
Now, you say everything is ok.
Have really lost the control files ?

run a sqlplus session :
select * from v$controlfile

output ?

What does the alert log file says ?

Can you shutdown normal/immediate now without pb ?

Regards
Jean-Luc

[Fred Ruffet]

Controlfile is specified in your init.ora or spfile.ora file. It's stored in control_files parameter.

Regards,

Fred

[Hein van den Heuvel]

'RAC' wrote: "Reboot the box.
On svrmgrl, shutdown immedaiet
If that does not help then shutdown abort"

for future reference... the order is reversed on that.
You are supposed to TRY shutdown immediate first.
If that fails 'shutdown abort', this will kill the processes and attempt to clean up shared memory and such.
Only if that fails would I consider rebooting (hey, we are not talking about a windows server are we?! :-)

Also for future reference check out:

SQL> ALTER DATABASE BACKUP CONTROLFILE ...
which will get you a script to do:
CREATE CONTROLFILE....


Cheers,
Hein,