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

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Mon, 10 Jan 2022 13:17:37 -0700
Message-ID: <CAJzM94DsQsD0d6P2WBHb-WKUqq6t5J=RAe2pe31DjhZ_3RVopg_at_mail.gmail.com>



I don't have any servers that run ASM that are not RAC. They already are RAC databases, just the commvault configuration was done as single instance. We will eventually be putting them all on a non-RAC system.

Sandy

On Mon, Jan 10, 2022 at 1:12 PM Douglas Dunyan <dmdunyan_at_gmail.com> wrote:

> Hmmmm -
> Restore to single instance from commvault. After it's up and open,
> convert to RAC...
>
> Doug
>
> On Mon, Jan 10, 2022 at 12:36 PM Sandra Becker <sbecker6925_at_gmail.com>
> wrote:
>
>> Oracle Database & Grid: 11.2.0.1
>> OS: RHEL5.5
>>
>> We had some issues with a database server and the 9 databases stopped
>> working. The sys admins suggested a reboot, which we did. GRID/ASM would
>> not come back online after the reboot. It says it can't find the ASM
>> disks, but everything the sys admins look at say they are there and
>> online.
>>
>> We tried restoring the $GRID_HOME, but that didn't change anything. Our
>> Rimini support said a lot of libraries were missing from the $GRID_HOME, so
>> another DBA tried to getting the missing files. Still no luck. It's a
>> two-node RAC, but only one of the nodes was functional at the time we
>> rebooted the first node. The second has the same issues as the first, so
>> we can't bring anything online there either.
>>
>> We tried setting up on another comparable cluster, but due to the way the
>> database configurations were done in CommVault for the "bad" server,
>> CommVault thinks they are single instance and won't let us restore to a RAC.
>>
>> Ultimately, we want to move these databases to a non-ASM server in AWS.
>> Any suggestions as to what we can do? I was wondering if we could
>> reinstall GRID/ASM on the "bad" server and then use Commvault to do our
>> restores. Is that totally off base or a viable option?
>>
>> --
>> Sandy B.
>>
>>

-- 
Sandy B.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 10 2022 - 21:17:37 CET

Original text of this message