Re: Need help with standby database REAL TIME APPLY

  • From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
  • To: sbecker6925@xxxxxxxxx, Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • Date: Tue, 28 Jul 2020 16:01:40 +0100

Hi Sandy,

On 28/07/2020 15:30, Sandra Becker wrote:
> I have 5 SRLs for each thread, but the alert log still says "No standby
> redo logfiles available for T-2".
Just to be 100% certain, can you run:

SELECT TYPE, COUNT(*) FROM V$LOGFILE
GROUP BY TYPE;  


I'm thinking that your standby redo logs might not be standby! Apologies if they are! You should see the count of online redo logs and the count of standby redo logs.


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767
--
//www.freelists.org/webpage/oracle-l


Other related posts: