cancel
Showing results for 
Search instead for 
Did you mean: 

shutdown oracle on hpux

Manu_13
Frequent Advisor

shutdown oracle on hpux

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.
17 REPLIES
RAC_1
Honored Contributor

Re: shutdown oracle on hpux

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

Anil
There is no substitute to HARDWORK
Jean-Luc Oudart
Honored Contributor

Re: shutdown oracle on hpux

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
fiat lux
Peter Godron
Honored Contributor

Re: shutdown oracle on hpux

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
Exalted Contributor

Re: shutdown oracle on hpux

I agree with the above analysis.

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

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Manu_13
Frequent Advisor

Re: shutdown oracle on hpux

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
Frequent Advisor

Re: shutdown oracle on hpux

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
Honored Contributor

Re: shutdown oracle on hpux

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
fiat lux
Fred Ruffet
Honored Contributor

Re: shutdown oracle on hpux

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

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Hein van den Heuvel
Honored Contributor

Re: shutdown oracle on hpux



'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
Frequent Advisor

Re: shutdown oracle on hpux

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
Honored Contributor

Re: shutdown oracle on hpux

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

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

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Yogeeraj_1
Honored Contributor

Re: shutdown oracle on hpux

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
twang
Honored Contributor

Re: shutdown oracle on hpux

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
Honored Contributor

Re: shutdown oracle on hpux

Sugeest, read the following link:

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

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Fred Ruffet
Honored Contributor

Re: shutdown oracle on hpux

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

"Reality is just a point of view." (P. K. D.)
Manu_13
Frequent Advisor

Re: shutdown oracle on hpux

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

Manu
Manu_13
Frequent Advisor

Re: shutdown oracle on hpux

I found the solution by rebooting the machine!