Re: Blog a Day
Date: Sat, 20 Jan 2018 20:45:59 -0600
Message-ID: <CAP79kiRwBAn43Wgj4hvii0ANgkW6g=Bhy4bcikM0EvPh_CDAJA_at_mail.gmail.com>
I've got one for you....
Scenario:
Figured out from looking at the alert log the datafile it was complaining
about had already been fully recovered. So I restarted the recovery with
SKIP TABLESPACE UNDOTBS.
Seems to be working but won't find out fully until I get through the entire
recovery process which is taking hours. Standby had gotten 2 days behind
because of a failed monitoring configuration in our Grid setup.
Chris
On Sat, Jan 20, 2018 at 5:04 PM, Jared Still <jkstill_at_gmail.com> wrote:
> Thank you Kellyn!
- Need to recover Standby Database using Incremental Backup of Primary - (a
50TB primary db mind you) - Following Doc ID: 836986.1
- While recovery is running on Standby, kill the RMAN sessions so you can
reconfigure the rman channels and add more channels ( but only do this
after 1 or more datafiles have successfully recovered while others remain
to be recovered)
- Restart the recovery
- Immediately get this error on the new recovery session (in 12.1.0.2)
(instead of it telling you that datafile is already recovered, it throws an
ORA-19639 - which Oracle support doesn't have any knowledge base articles
on.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/20/2018 21:12:39
ORA-19870: error while restoring backup piece
/orabackup-xfs/db_name/backup/ForStandby_s3sp2kak_1_1
ORA-19639: file /oradata/db_name/system/undo_tbs1_01.dbf is more current
than this incremental backup
ORA-19642: start SCN of incremental backup is 908522280723
ORA-19641: backup datafile checkpoint is SCN 909723281357 time 01/19/2018
12:40:54
ORA-19640: datafile checkpoint is SCN 909723281357 time 01/19/2018 12:40:54
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Principal Consultant at Pythian
> Pythian Blog http://www.pythian.com/blog/author/still/
> Github: https://github.com/jkstill
>
>
>
> On Fri, Jan 19, 2018 at 2:02 PM, Kellyn Pot'Vin-Gorman <
> dbakevlar_at_gmail.com> wrote:
>
>> I was able to keep 3 per week for a good year, but it isn't easy when you
>> have a day job and want to keep the content technical. Sometimes the
>> writing isn't the issue, but the technical testing or builds... :)
>>
>> Good luck, Jared!
>>
>> Kellyn
>>
>>
>>
>> [image: Kellyn Pot'Vin on about.me]
>>
>> Kellyn Pot'Vin-Gorman
>> about.me/dbakevlar
>> <http://about.me/dbakevlar>
>>
>> On Fri, Jan 19, 2018 at 2:50 PM, Michael D O'Shea/Woodward Informatics
>> Ltd <woodwardinformatics_at_strychnine.co.uk> wrote:
>>
>>> Pick a good charity and you have a sponsor.
>>> Mike
>>>
>>> Am 19.01.2018 um 22:41 schrieb Jared Still <jkstill_at_gmail.com>:
>>>
>>>
>>> Doing a blog a day, Monday - Friday. Limited to what I can do in 30-45
>>> minutes per day.
>>> ( ok, sometimes 60 minutes...)
>>>
>>> How long can I keep this up? Until I run out of time or ideas, which
>>> ever comes first. :)
>>>
>>> Start here: https://blog.pythian.com/author/still/
>>>
>>>
>>> Jared Still
>>> Certifiable Oracle DBA and Part Time Perl Evangelist
>>> Principal Consultant at Pythian
>>> Pythian Blog http://www.pythian.com/blog/author/still/
>>> Github: https://github.com/jkstill
>>>
>>>
>>>
>>>
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 21 2018 - 03:45:59 CET