Archive log gaps
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!