shutdown oracle on hpux

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