[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Recover Standby Database

Posted on 2011-04-25
Medium Priority
Last Modified: 2012-05-11
A couple days ago i ran out of archived log space on the standby.  Since that time, i've not been able to recover past that time.  
I go into SQLPlus and issue a recover standby database until cancel.  

SQL> recover standby database until cancel;

ORA-00279: change 3390948827767 generated at 04/23/2011 05:35:03 needed for
thread 1
ORA-00289: suggestion : /u03/archived_logs/1_101461_665266938.arc
ORA-00280: change 3390948827767 for thread 1 is in sequence #101461

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00326: log begins at change 3390949430369, need earlier change
ORA-00334: archived log: '/u03/archived_logs/1_101461_665266938.arc'

When I present the suggested log, i get the 'need earlier change' message.

Change 3390948827767 is in the 1_101461_665266938.arc.
How do I get this standby back to recovering???
Question by:xoxomos

Assisted Solution

Piloute earned 600 total points
ID: 35465471

Just go backwards in the logs the recovery process asks for. Suggested is not necessary the good one...

LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 800 total points
ID: 35466543
I would contact Oracle Support on this one.

There appears to be a few bugs on this.  The bug reference numbers are talked about in:

LVL 16

Assisted Solution

by:Swadhin Ray
Swadhin Ray earned 600 total points
ID: 35472861
Run this :

alter database recovery automatic until cancel;

After issuing this ..you need to copy and past in the recovery directory path it is specifying archived needed for recovery

Author Closing Comment

ID: 35476874
All of you had most parts of the problem.  Oracle support gave me a query that returned unrecoverable_change# in both the primary and standby.  In cases where the unrecoverable_change# on primary was greater than standby i needed to copy from primary to standby.  The big mistake i was making was transferring from primary to the archive_log_dest directory on standby and the managed recovery process was just writing over it.  What I needed to do was transfer to some other directory then issue a SQL command to:
alter database register or replace logfile '/tmp/1_101461_665266938.arc';, then let it recover as much as it would and start the process all over each time i got the 'need earlier/later' number.
Thanks all.

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question