Home » Server Options » Data Guard » Generate log sequence 1 at standby database everyday (DB : Release 10.2.0.4.0, OS : Linux Enterprise release 5.2 (Carthage))
Generate log sequence 1 at standby database everyday [message #504027] Thu, 21 April 2011 03:15 Go to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi All,

We have standby dataguard set up namely CRMSTDY of 3 node RAC clusterware. It has been observed that log sequence number 1 is generated since last 4 days on standby database. There is nothing more information in alert_standby.log file and the same file is visible when we checked with ASMCMD utility. Check the attached print sceen and suggest. Below mentioned system information.

DB : Release 10.2.0.4.0
OS : Linux Enterprise release 5.2 (Carthage)

Regards,
Vishal/forum/fa/8893/0/
  • Attachment: standby.JPG
    (Size: 193.92KB, Downloaded 516 times)
Re: Generate log sequence 1 at standby database everyday [message #504091 is a reply to message #504027] Thu, 21 April 2011 08:46 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi All,


Please help me to solve this...?

Need expert input.

Regards,
Vishal
Re: Generate log sequence 1 at standby database everyday [message #504124 is a reply to message #504091] Thu, 21 April 2011 10:48 Go to previous message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
You haven't given much information, but I expect (this is only a guess) that you have configured your archivelog deletion policy to APPLIED ON STANDBY, or something similar? You don't need to apply that log, so use RMAN to delete it, on both the primary and the standby.
Just a suggestion, it may be wrong.
Previous Topic: switchover_status=not allowed
Next Topic: Apply Patches on Oracle Database with Logical Standby Database
Goto Forum:
  


Current Time: Thu May 28 04:06:10 CDT 2020