We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Recover Standby Database

xoxomos
xoxomos asked
on
Medium Priority
1,624 Views
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}
 /u03/archived_logs/1_101461_665266938.arc
ORA-00326: log begins at change 3390949430369, need earlier change
3390948827767
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???
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.