Oracle Database Discussions

Hi Gurus,

Had a small query for you guys, I have a production and a standby database setup on Windows 2003 (10.2.0.4), my standby has been recovered till archive log 883,due to some issues with my production, I activated my standby database. Since standby is activated,the database gets opened in resetlogs. My archives starts generating from sequence 1,2,3.....

But now when I query v$archived_log to check the max sequence# generated it still shows as 883...and not as 6 which is my actual number of archive log creation.

As per my understanding, when we activate a standby database, the flag for standby database in the control file is reset so that the control file behaves as that of production database (I know I am using layman terminilogy over here)...so what makes the view v$archived_log show old value for sequence# prior to activation rather than the new value after activation?

Any help or direction over this from your side would be appreciated..

Thanks,
Ajinkya