Data guard "log verification"

Hi
I was created two physical stanby databases for one primary database, i put one 
as Active standby databse(STDB1) , So we are able to get the sys prompt ,So 
from sys prompt we can check whether the redolgs generated in the primary are 
applied on the standby database,  And i put the STDB2 in the maintenance 
recovery mode , so in this case we r not getting any sys prompt ,But i want to 
check whether the redo generated in the primary server was applied on the STDB2 
or not Withot disturbing MRM mode, How we can check it  ......



Bhaskar

Not sure what "maintenance recovery mode" is?  Do you mean "MANAGED STANDBY"?

You can always check Alert logs to see if logs are being applied/shipped.  And 
you can always come out of managed standby mode:

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.


## now do what you need and then place it back into managed standby mode:
##

SQL> alter database recover managed standby database using current logfile 
disconnect;

Database altered.


Most important:  don't assume that just because you setup TWO standby databases 
you are safe from failures and ready to do switchover/failover.  TEST, TEST and 
RE-TEST both failover and switchover and document everything.  This way when 
the failure occurs and you have to do this in the middle of the night you'll 
know exactly what to do.

Standby databases without testing failover/switchover are as useless as backups 
that haven't been tested for recoveries.

> Hi
> I was created two physical stanby databases for one primary database, i put 
> one as Active standby databse(STDB1) , So we are able to get the sys prompt 
> ,So from sys prompt we can check whether the redolgs generated in the 
> primary are applied on the standby database,  And i put the STDB2 in the 
> maintenance recovery mode , so in this case we r not getting any sys prompt 
> ,But i want to check whether the redo generated in the primary server was 
> applied on the STDB2 or not Withot disturbing MRM mode, How we can check it 
>  ......
> 
> Bhaskar

I have a script you can run on physical standby database no matter it is MOUNT 
or READ ONLY to check the archived and applied:

select substr('Thread('||a.thread#||')  RCV:['||a.SEQ_REC||']  
APLD:['||b.SEQ_APP||']  ACM:['||(a.SEQ_REC-b.SEQ_APP)||']',1,49) "  ** DR Redo 
Status Brief "
from
 (select thread#, max(sequence#) SEQ_REC
    from v$archived_log val, v$database vdb
   where val.resetlogs_change# = vdb.resetlogs_change#
   group by thread# order by 1) a, 
 (select thread#, max(sequence#) SEQ_APP
   from v$archived_log val, v$database vdb
  where val.resetlogs_change# = vdb.resetlogs_change#
        and val.applied='YES'
  group by thread# order by 1) b
where a.thread#=b.thread#
/

have a try and reply here if there is problem.

- Hank

Thanks Hank!