Re: The Redo Hasn't Arrived Yet
Date: Tue, 19 May 2020 07:32:15 +0000 (UTC)
Message-ID: <1414925850.1341438.1589873535971_at_mail.yahoo.com>
Thanks Hemant,
imho, while applying redo to a Standby, datafiles will , temporarily, be at inconsistent SCNs until a checkpoint is done to update all the headers consistent with the controlfile.An ABORT doesn't execute a checkpoint while an IMMEDIATE does do so.
Hemant K Chitale
On Mon, May 18, 2020 at 11:24 PM Charlotte Hammond <charlottejanehammond_at_yahoo.com> wrote:
I agree - shutdown immediate would be better.
It's kind of procedural - servers are being shutdown by a third party "at random" when not required to save on hosting costs - Oracle Restart is being used which uses shutdown abort when the host itself is going down (regardless of the shutdown mode specified for the resource).
Now, there are various ways this can be fixed but I'm really trying to understand WHY this is actually causing the problem below, so I can explain / motivate people to address it.
Thanks!Charlotte
On Monday, May 18, 2020, 03:38:39 PM GMT+1, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote:
Why ABORT for the Standby ?
Hello,
Mon May 18 07:03:53 2020Standby crash recovery failed to bring standby database to a consistentpoint because needed redo hasn't arrived yet.MRP: Wait timeout: thread 1 sequence# 0Standby Crash Recovery aborted due to error 16016.Errors in file /u01/app/oracle/diag/rdbms/dinmybs1/DINMYBS1/trace/DINMYBS1_ora_4660.trc:ORA-16016: archived log for thread 1 sequence# 1134 unavailableRecovery interrupted!Some recovered datafiles maybe left media fuzzyMedia recovery may continue but open resetlogs may failCompleted Standby Crash Recovery.Errors in file /u01/app/oracle/diag/rdbms/dinmybs1/DINMYBS1/trace/DINMYBS1_ora_4660.trc:ORA-10458: standby database requires recoveryORA-01196: file 1 is inconsistent due to a failed media recovery sessionORA-01110: data file 1: '+DATA/dinmybs1/datafile/system.268.1023746733'ORA-10458 signalled during: ALTER DATABASE OPEN /* db agent *//* {0:0:2} */...
But what I don't understand is how datafiles could be updated when the redo hasn't arrived yet. Surely the redo should *always* be ahead of any other file in the database?
Thanks,Charlotte On Tuesday, May 19, 2020, 02:58:14 AM GMT+1, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote:
I use SHUTDOWN IMMEDIATE.
Hemant K Chitale
On Mon, 18 May 2020, 22:11 Charlotte Hammond, <dmarc-noreply_at_freelists.org> wrote:
If we shutdown *abort* our Data Guard standbys (11.2.0.4 maximum performance with RTA), we occasionally get the errors below on restart ("redo hasn't arrived yet")
Now this isn't a problem and is easy to fix - but I'm trying to understand WHY it happens: How can the controlfile and/or datafile headers in the standby database be ahead of the available redo at the time of abort?i.e. What is different about crash recovery on a standby compared to a primary?
Many thanks for any clarifications!
Charlotte
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 19 2020 - 09:32:15 CEST