Re: Issues with server and need to restore controlfiles and spfiles

Hi Sandy,

On Monday, January 10th, 2022 at 3:34 PM, Sandra Becker <sbecker6925_at_gmail.com> wrote:

> Yes, it's very suspicious to me. No, at this time I can't get the errors from the logs. I don't have the logs available to me and would need to get them restored. I am more interested in how do we get these databases back online than in finding the root cause right now

Agreed, I guess I meant that if you try to start an instance now, what are the errors that you are getting. I'm guessing you can't even start the ASM instances. On a separate reply, Tim suggested troubleshooting verifying that your asm devices are mapped properly. That makes sense.

As for snaphot controlfiles, if you have one then you just need to point to it in your s/pfile, right? But, my guess is you'll end up in the same place since your datafiles live on ASM. :)

Andy K

--
http://www.freelists.org/webpage/oracle-l