High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Archive log gaps

  Hi,

Does anybody knows how is this possible?

At standby database, I executed this query:

SQL> select sequence#,applied from v$archived_log order by sequence#;

         784080 YES
         784082 YES
         784083 YES
         784084 YES
         784085 YES
         784086 YES
         784087 YES

Notice that 784081 is missing, but the succeeding logs were applied.  My workaround here is to ftp the missing archive log file and register it manually. The database is running in 10g version.

May I know if there are other solution for this instead of performing the synch of 2 databases manually?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center