Re: New Non-ASM Standby Trying to use ASM during recovery

From: Don Seiler <don_at_seiler.us>
Date: Mon, 19 Aug 2013 16:08:13 -0500
Message-ID: <CAHJZqBCbRLQ=BLZtOP3KDXV4WQ71_ys_M62pueV_BfU=oxG6hg_at_mail.gmail.com>

I've cross-posted to the OTN forums at
https://forums.oracle.com/message/11152663 and updated that post with some more details and a trace file. I've got the standby recovered via DataGuard. RMAN recovery continues to get that error, as does using RMAN for commands like "crosscheck" and "backup database" (not important, right?).
So the standby is caught up and log apply works fine. RMAN not working so fine.

I've opened an SR with support for now, I'll update this thread and the OTN post with anything I find.

On Mon, Aug 19, 2013 at 3:54 PM, Adric Norris <landstander668_at_gmail.com>wrote:

> This is a shot in the dark, but have you tried running "switch datafile
> all to copy" at the RMAN prompt between restoring the datafiles and
> starting recovery?
> Your Blacklist
>
> -
> pydsh.sourceforge.net
> -
> www.dba-oracle.com
>
>
> Regular expressions are supported, do not use i or g flags.
> Preferences
>
> - Blacklist Enabled
> Toggles this userscript. This will reload the page..
> - Display Messages
> Shows "domain blacklisted" in SERP.
> - RegEx Blocker
> Use regex to block full domain name.
> - Auto Block Malware
> Auto-block sites listed as malware.
> - Blacklist News
> Blacklists google news widget.
> - Blacklist Related
> Blacklists related results.
> - Show Preferences
> Leaves prefs open for debugging.
>
> Import/Export
> Import Export
>
>
> On Mon, Aug 19, 2013 at 10:58 AM, Don Seiler <don_at_seiler.us> wrote:
>
>> Oracle 11.2.0.3 on RH6 x86_64.
>> We have a database on ASM. We want to migrate to filesystem storage on
>> same
>> host (Oracle ZFS). Recommended path from Oracle is to create a standby and
>> then do a failover when ready. Simple enough you'd think.
>>
>> Standby has all reference to ASM diskgroups removed, and convert
>> parameters
>> set appropriately. Take a new backup including archivelogs and also a
>> backup standby controlfile. The "duplicate target database for standby"
>> performs the restore phase perfectly fine. When the media recovery phase
>> starts, I see it tries to mount the diskgroup that the primary uses for
>> ASM. However it fails to do so (plenty of errors to alert log), then
>> recovery fails and the instance is left in mount mode. Subsequent attempt
>> to run "recover database" or even "crosscheck archivelog all" run into the
>> same ASM errors.
>>
>> The one odd thing I see is the reference to the srvctl resource name for
>> that diskgroup:
>>
>> Mon Aug 19 10:41:35 2013
>> ERROR: failed to establish dependency between database prod_zfs and
>> diskgroup resource ora.FRA.dg
>>
>> However I never registered prod_zfs in srvctl, and it still isn't listed
>> when I run "srvctl config database". Obviously the prod configuration has
>> the dependency on +FRA, and it is on the same machine. Is srvctl confusing
>> the two? Perhaps due to same DBID (as is necessary with primary/standby)?
>>
>> Wondering if any of you have seen this.
>>
>>
>> --
>> Don Seiler
>> http://www.seiler.us
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> "I'm too sexy for my code." -Awk Sed Fred
>

-- 
Don Seiler
http://www.seiler.us


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

Received on Mon Aug 19 2013 - 23:08:13 CEST