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,

[Manu_13]

Hi Jean,

I had removed all the control files including the one mentioned in the control_file parameter in *.ora file for my SID.

Now if i run the command
select * from v$controlfile

I get the following output.
STATUS
-------
NAME
--------------------------------------------------------------------------------
/u01/oradata/openview/control01.ctl
/u01/oradata/openview/control02.ctl
/u01/oradata/openview/control03.ctl

But none of these files are acutally present. Now i tried shutdown. output is below.

==========================================
SQL> shutdown
ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/u01/oradata/openview/control01.ctl'
ORA-27041: unable to open file
HP-UX Error: 2: No such file or directory
Additional information: 3
==========================================

Now I tried shutdown abort. ORACLE was shutdown now.

Thanks,
Manu

[Sanjay Kumar Suri]

It seems that you have lost all the current control files.

You need to carry out database recovery using a backup controlfile.

sks

[Yogeeraj_1]

hi,

You should have done as Hein mentioned above. "alter database backup controlfile to trace" would have created a script that you could have used to re-create your control file.

Do you have a copy of such a script? You may also recover from your RMAN backup and use the archived logs to come back to the point where you got this problem.

regards
Yogeeraj

[twang]

First of all, check the controlfile from the location stated in init.ora. If you lost all controlfiles, you may need to recreate them,
after 'SHUTDOWN ABORT' the database, then
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS ARCHIVELOG
MAXLOGFILES 64
MAXLOGMEMBERS 2
MAXDATAFILES 512
MAXINSTANCES 2
MAXLOGHISTORY 10210
LOGFILE
GROUP 1 '/oradb3/prod/log1.dbf' SIZE 20M,
GROUP 2 '/oradb3/prod/log2.dbf' SIZE 20M,
GROUP 3 '/oradb3/prod/log3.dbf' SIZE 20M
DATAFILE
'/oradb4/prod/system1.dbf',
'/oradb4/prod/system2.dbf',
'/oradb4/prod/system3.dbf',
'/oradb4/prod/rbs1.dbf',
'/oradb4/prod/rbs2.dbf',
'/oradb4/prod/rbs3.dbf',
'/oradb5/prod/usrdat.dbf',
'/oradb2/prod/usridx.dbf',
....
CHARACTER SET ZHT16BIG5
;
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP_NEW ADD TEMPFILE '/oradb3/prod/temp1.dbf' REUSE;
....

Now you have recreated your controlfiles.

[Sanjay Kumar Suri]

Sugeest, read the following link:

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/control.htm#1433

sks

[Fred Ruffet]

Something sounds strange :
. You lost your control files,
. You shutdown abort,
. You reboot,
. Then restarted all
???

How did you restart without a control file ? Did you used a backup control file ? I may have missed something...

Regards,

Fred

[Manu_13]

I have mentioned whatever I did. I dont know if I am not aware something which is missing here.

Manu

[Manu_13]

I found the solution by rebooting the machine!