Re: Taking Backup from standby database

You need to include archivelogs in your backup so that Oracle can perform recovery to a consistent point after restoring the fuzzy datafiles. Either that or you need to stop standby recovery while you take your backup.

On Fri, Dec 2, 2016 at 12:09 AM, 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;
> }
>
>
>

-- 
Don Seiler
http://www.seiler.us

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