Skip to Main Content
  • Questions

  • Redo log archived but not applied in DR.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, sanjiv .

Asked: February 22, 2018 - 6:19 am UTC

Last updated: March 01, 2018 - 1:08 am UTC

Version: 11.2.0

Viewed 10K+ times! This question is

You Asked

Greetings,

I have configured DG with maximum availability with one primary and one standby.

It was working okay and real time redo transport was applying fine.

Now, the problem is ::

Archived log is being transmitted to Standby but is not getting applied.

The status in v$archived_log are (archived->yes, applied-> no)

I tried to cancel the recovery using ::

sql> alter database recover managed standby database using current logfile disconnect from session;
But gives error :: Standby recovery process not active.

Even after manual log switch from primary, the archived logs are transmitted but not applied.

I checked the size of db_recovery_file_dest it was ok.

What might be the solution to it?

Yours' Sincerely,
Sanjiv Ranjit

and Connor said...

The most common cause is that an earlier archive log is missing or could not be applied, and hence we are "stuck" - we cannot proceed beyond that point.

Check out MOS Note 1537316.1 - Data Guard Gap Detection and Resolution

Typically you'll need to make sure the archive file is present as expected on the standby node, and perhaps run

alter database register logfile '/mylocation/myfile.arc';

in case the standby database did not have correct information about the presence of the file.

But check the note for more details.


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Log archive not applied SOLVED!!!

sanjiv ranjit, February 28, 2018 - 5:14 am UTC

Greetings,

Thank you for the advice. Always comes handy.

My problem was, i tried to convert the physical database to logical database. Hence the control file became a logical standby controlfile. But then i halted the process and issued 'alter database recover standby database using current logfile disconnect from session'. This recovered the files but could not apply them to the current datafile because the controlfile was disordered.

Then i again took back backup of controlfile and replaced them with existing one.

Then i rebooted and tried to recover the database.

Now its up and running well!!!

Thanks.

Yours' Sincerely,
Sanjiv Ranjit
Connor McDonald
March 01, 2018 - 1:08 am UTC

Thanks for getting back to us with an update.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database