Re: Backups failing after Data Guard configuration

From: Rajeev Prabhakar <rprabha01_at_gmail.com>
Date: Fri, 15 Apr 2011 17:56:30 -0400
Message-Id: <F051CC3A-0F7F-42EF-9FF5-C0C9E7AADF3A_at_gmail.com>



Hello Sandra,

At the very least, please ensure that
the correct DBID is registered with
rman catalog.

Regards,
Rajeev

On Apr 15, 2011, at 4:01 PM, Sandra Becker <sbecker6925_at_gmail.com> wrote:

> Platform: IBM zSeries
> OS: Suse10
> DB: EE 10.2.0.4 (planning to go to 11g in 4-6 months)
>
> Three weeks ago I created a standby database using RMAN and setting
> everything up manually. Had problems using EM so had to resort to
> the manual method when Oracle support was unable to find an EM
> solution. All went well, logs were shipping and applying when I
> turned on log apply at night, backups were performing as they always
> had and life was good. I then configured the standby in EM and set
> up the Data Guard configuration with the primary/standby. Now when
> I turn on log apply the backups fail with RMAN-20011. I have
> researched the error and tried to unregister/re-register the
> database to no avail. Restoring isn't an option either for this
> 24x7 OLTP. I have a ticket open with Oracle support but it's been
> 8 hours and they have yet to even notify me that someone is working
> on it--it's a Sev 2 right now. I did turn off log apply at 6:30am
> and at 7:30am an archive backup kicked off and ran successfully. I
> find this behavior frustrating and confusing.
>
> I have to turn off log apply during core business hours due to the
> excessive paging on the zSeries but it seems to me that the backups
> should work whether log apply is on or not. Has anyone ever seen
> this behavior? I'm sure I did something wrong in my configuration
> but I can't seem to find it. Any suggestions will be appreciated.
>
> --
> Sandy
> Transzap, Inc.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 15 2011 - 16:56:30 CDT

Original text of this message