Re: Taking Backup from standby database

My sincere advice would be to include "BACKUP CURRENT CONTROLFILE" in EVERY backup you make. Also, turn the autobackup on. If you ever happen to lose an entire machine and have to use SET DBID, you will have to restore controlfile from autobackup.
The usual setup is to run data backup on standby only and to run the archive log backup on both primary and standby database, in order to maintain the free space and a running database. Nasty things happen when the database cannot write an archive log because the log destination is full. And those nasty things usually happen around 3 AM.

On 12/05/2016 03:52 PM, Vadim Keylis wrote:
> Good afternoon. Thanks so much for all valuable advice. Do I backup
> control file on the standby or primary if I want to activate the
> database restored using backup from standby? I added the following
> command to my script on standby database: BACKUP CURRENT CONTROLFILE;
>
> Thanks in advance,
> Vadim
>
> On Sat, Dec 3, 2016 at 6:52 AM, Vadim Keylis <vkeylis2009_at_gmail.com
> <mailto:vkeylis2009_at_gmail.com>> wrote:
>
> Thanks so much everyone for the help and suggestions.
>
>
> On Dec 2, 2016 3:38 AM, "Gmail" <jacques.kostic_at_gmail.com
> <mailto: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 <mailto: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
>> <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
>> <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 <mailto: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
>> <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
>> <mailto:timur.akhmadeev_at_gmail.com>] *Sent:* 02 December
>> 2016 10:46 *To:* Oracle-l <oracle-l_at_freelists.org
>> <mailto:oracle-l_at_freelists.org>>;
>> jacques.kostic_at_gmail.com
>> <mailto:jacques.kostic_at_gmail.com>; vkeylis2009_at_gmail.com
>> <mailto: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
>> <mailto: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
>> <mailto: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;
>>
>> }
>>

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l