Re: Taking Backup from standby database

From: Vadim Keylis <vkeylis2009_at_gmail.com>
Date: Sat, 3 Dec 2016 06:52:17 -0800
Message-ID: <CAHL4c1P3q7M92L3_a_i5jPq2Ce0RXe8samoqkQ12fLiFKZzE=A_at_mail.gmail.com>



Thanks so much everyone for the help and suggestions.

On Dec 2, 2016 3:38 AM, "Gmail" <jacques.kostic_at_gmail.com> wrote:

> It's included block change tracking.
>
> On 2 December 2016 12:32:26 Timur Akhmadeev <timur.akhmadeev_at_gmail.com>
> wrote:
>
>> Yes indeed and it's in the docs
>>
http://docs.oracle.com/cd/E11882_01/license.112/e47877/
>> options.htm#DBLIC141
>>
>> However they say "fast" incremental backups. What does it mean exactly?
>> BCT file usage on Standby: http://docs.oracle.com/cd/
>> E11882_01/backup.112/e10642/rcmbckba.htm#BRADV8125
>>
>> Didn't know that.
>>
>> On Fri, 2 Dec 2016 at 13:51, Jko - Google <jacques.kostic_at_gmail.com>
>> wrote:
>>
>>> Incremental backup from an active Standby is under ADG licence.
>>>
>>>
>>>
>>> https://www.oracle.com/database/active-data-guard/index.html
>>>
>>>
>>>
>>> But it doesn’t say database is Read-Only with Real Time Apply.
>>>
>>>
>>>
>>> So for me incremental backups from “Active” mean applying changes is
>>> under ADG licence.
>>>
>>>
>>>
>>> Cheers
>>>
>>> jko
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *From:* Timur Akhmadeev [mailto:timur.akhmadeev_at_gmail.com]
>>> *Sent:* 02 December 2016 10:46
>>> *To:* Oracle-l <oracle-l_at_freelists.org>; jacques.kostic_at_gmail.com;
>>> vkeylis2009_at_gmail.com
>>> *Subject:* Re: Taking Backup from standby database
>>>
>>>
>>>
>>> Any proof link for that? ADG has appeared in 11g while backups from
>>> standby are available for a long time - do you mean there was a license
>>> agreement change? I highly doubt so.
>>>
>>>
>>>
>>> On Fri, 2 Dec 2016 at 10:51, Gmail <jacques.kostic_at_gmail.com> wrote:
>>>
>>> Hi Vadim,
>>>
>>> Remember that you must be licensed active data guard for backup from
>>> active standby.
>>> Cheers
>>> Jko
>>>
>>> On 2 December 2016 7:10:34 a.m. Vadim Keylis <vkeylis2009_at_gmail.com>
>>> wrote:
>>>
>>> Good evening oracle experts. I am having issue activating database
>>> restored using backup taken from standby.
>>>
>>> Our current setup: We have one primary and one standby database. The
>>> standby database is kept in sync with primary using dataguard. We are
>>> currently taking backups from primary. We are want to move backups from
>>> primary to standby database.
>>>
>>>
>>>
>>>
>>>
>>> I used script bellow to take backup from standby database and then
>>> restored backup on different server. The database was successfully restored
>>> and physical standby. The problem started when I try activating it. I got
>>> the following error
>>>
>>> ORA-01194: file 1 needs more recovery to be consistent
>>>
>>> ORA-01110: data file 1: '+STAGEDATA/SETLR/DATAFILE/
>>> system.5096.929468439'
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> I will greatly appreciate suggestions on taking backups from standby in
>>> order to restore as primary in case of emergency as well as how to solve
>>> inconsistency error after standby database is activated.
>>>
>>>
>>>
>>> Thanks so much,
>>>
>>> Vadim
>>>
>>>
>>>
>>>
>>>
>>> -------------------------Script to backup from physical standby
>>> -------------------------------------------------
>>>
>>> run
>>>
>>> {
>>>
>>> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
>>> '/mnt/db_transfer/SETL/rman_backup/ctl/control_%F';
>>>
>>> CONFIGURE MAXSETSIZE TO 128 G;
>>>
>>> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/db_transfer/SETL/rman_
>>> backup/ctl/snapcf_SETL.f';
>>>
>>> ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT '/mnt/db_transfer/SETL/rman_
>>> backup/db_%d_df_t%t_s%s_p%p_level0';
>>>
>>> BACKUP INCREMENTAL LEVEL 0 TAG LEVEL_0_20161201_1526 DATABASE ;
>>>
>>> DELETE FORCE NOPROMPT OBSOLETE;
>>>
>>> RELEASE CHANNEL ch1;
>>>
>>> }
>>>
>>>
>>>
>>>
>>>
>>>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Dec 03 2016 - 15:52:17 CET

Original text of this message