topic Re: shutdown oracle on hpux in Operating System - HP-UX

shutdown oracle on hpux

Manu_13 — Wed, 12 Jan 2005 08:50:46 GMT

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.

Re: shutdown oracle on hpux

RAC_1 — Wed, 12 Jan 2005 09:08:14 GMT

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

Anil

Re: shutdown oracle on hpux

Jean-Luc Oudart — Wed, 12 Jan 2005 09:16:15 GMT

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

Re: shutdown oracle on hpux

Peter Godron — Wed, 12 Jan 2005 09:20:18 GMT

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

Re: shutdown oracle on hpux

Steven E. Protter — Wed, 12 Jan 2005 09:25:01 GMT

I agree with the above analysis.

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

SEP

Re: shutdown oracle on hpux

Manu_13 — Wed, 12 Jan 2005 09:25:32 GMT

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

Re: shutdown oracle on hpux

Manu_13 — Wed, 12 Jan 2005 09:32:59 GMT

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

Re: shutdown oracle on hpux

Jean-Luc Oudart — Wed, 12 Jan 2005 09:42:05 GMT

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

Re: shutdown oracle on hpux

Fred Ruffet — Wed, 12 Jan 2005 09:44:09 GMT

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

Regards,

Fred

Re: shutdown oracle on hpux

Hein van den Heuvel — Wed, 12 Jan 2005 10:00:41 GMT

'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,

Re: shutdown oracle on hpux

Manu_13 — Thu, 13 Jan 2005 00:23:11 GMT

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

Re: shutdown oracle on hpux

Sanjay Kumar Suri — Thu, 13 Jan 2005 00:30:35 GMT

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

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

sks

Re: shutdown oracle on hpux

Yogeeraj_1 — Thu, 13 Jan 2005 00:57:47 GMT

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

Re: shutdown oracle on hpux

twang — Thu, 13 Jan 2005 01:03:51 GMT

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.

Re: shutdown oracle on hpux

Sanjay Kumar Suri — Thu, 13 Jan 2005 01:21:59 GMT

Sugeest, read the following link:

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

sks

Re: shutdown oracle on hpux

Fred Ruffet — Fri, 14 Jan 2005 01:47:01 GMT

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

Re: shutdown oracle on hpux

Manu_13 — Mon, 17 Jan 2005 05:01:46 GMT

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

Manu

Re: shutdown oracle on hpux

Manu_13 — Wed, 19 Jan 2005 05:46:00 GMT

I found the solution by rebooting the machine!