Re: Blog a Day

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Sat, 20 Jan 2018 21:22:23 -0600
Message-ID: <CAP79kiSiKP-PP_S7KB4K-ere00ZdBtmK83rseRxSG6pdR4wDUA_at_mail.gmail.com>



Well, the restore completed successfully, and then promptly dropped the 2 datafiles for the 2 tablespaces I told it to skip (facepalm).

Attemping to recovery those before recreating the standby controlfile....

Chris

On Sat, Jan 20, 2018 at 8:45 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> I've got one for you....
>
> Scenario:
> - 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
>
>
> 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!
>>
>> 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-l
Received on Sun Jan 21 2018 - 04:22:23 CET

Original text of this message