1748004 Members
4738 Online
108757 Solutions
New Discussion юеВ

Re: Instance Crashed

 
Parthiban Dhananjeyan
Occasional Contributor

Instance Crashed

 
11 REPLIES 11
Bokoko
Advisor

Re: Instance Crashed

Dear Parthiban,


The first thing is to check if this instance is still running by running the "ps -edf | grep oradb".

If this instance is still running, first connect to the database and shtudown this instgance with Force option and then startup again. It should be fine. Don't forget to check previously if there is no user managing this instance.

I hope this should help you.
Parthiban Dhananjeyan
Occasional Contributor

Re: Instance Crashed

This instance was not running and further in the trace, the instance number is "0"... Whenever I issue a startup either with nomount or just start specifying the pfile or not, I get this error... Sometimes when I use nomount and then issue the resetlogs I get the other big error...

Parthiban
Andreas D. Skjervold
Honored Contributor

Re: Instance Crashed

Hi

Seems like the redologs might be the problem.
Do the follwing in svrmgrl:
SVRMGR> connect internal
SVRMGR> startup mount
SVRMGR> recover database until cancel;
SVRMGR> alter database open resetlogs;

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!

Re: Instance Crashed

Hi,

Good point - can you recover at all?
You may like to try Andreas' suggestion from SQL*Plus as I gather you're using 9.2 and svrmgrl has been dropped in 9i.
Are you running in archivelog mode? Do you have a backup you can use and then recover to a point in time just before your crash?
Something like:
RECOVER DATABASE UNTIL TIME 18-OCT-2002:15:32:00

cheers.
Barbara
If all else fails, read the instructions.
Parthiban Dhananjeyan
Occasional Contributor

Re: Instance Crashed

The problem is I am not able to start the instance, then how can I recover???? Whenever I issue the startup command either with mount or nomount, specifying or not specifying the parameter file....... Can somebody help??????

Parthiban
T G Manikandan
Honored Contributor

Re: Instance Crashed

Can you try removing the ipcs entries for Oracle.
If you have two instances on the same machine this could be a problem.

You can reboot the box to clear all the memory used areas of Oracle and try mounting the instance.

Also check the alert log and post the messages when you do a mount or nomount.

Thanks

T G Manikandan
Honored Contributor

Re: Instance Crashed

What is the value for
LOG_CHECKPOINT_TIMEOUT in your init.ora file of the instance.

Thanks
T G Manikandan
Honored Contributor

Re: Instance Crashed

alert log also should help you.

I also suspect the values for the kernel parameters.

Thanks
Parthiban Dhananjeyan
Occasional Contributor

Re: Instance Crashed