Thanks so much everyone for the help and suggestions.
On Dec 2, 2016 3:38 AM, "Gmail" <jacques.kostic@xxxxxxxxx> wrote:
It's included block change tracking.
On 2 December 2016 12:32:26 Timur Akhmadeev <timur.akhmadeev@xxxxxxxxx>
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@xxxxxxxxx>
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@xxxxxxxxx]
*Sent:* 02 December 2016 10:46
*To:* Oracle-l <oracle-l@xxxxxxxxxxxxx>; jacques.kostic@xxxxxxxxx;
vkeylis2009@xxxxxxxxx
*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@xxxxxxxxx> 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@xxxxxxxxx>
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;
}
