This forum is currently locked. You can't register or post questions at this time. (read more)

Data Guard Environment Backup

All posts relating to Oracle database administration.

Moderator: Tim...

peterx
Senior Member
Posts: 208
Joined: Wed Feb 09, 2011 7:07 am

Data Guard Environment Backup

Postby peterx » Sat Jun 22, 2013 2:23 pm

hi Tim,

My RMAN setting is:

Code: Select all

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PRIMARY are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/flash_recovery_area/PRIMARY/autobackup/%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 2;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 500 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE DB_UNIQUE_NAME 'PRIMARY' CONNECT IDENTIFIER  'PRIMARY';
CONFIGURE DB_UNIQUE_NAME 'PRIMARY1' CONNECT IDENTIFIER  'PRIMARY1';
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE' APPLIED ON ALL STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.1/db_1/dbs/snapcf_PRIMARY.f';

RMAN>




I can sure, when the Primary and Standby DB is up and running in a normal data guard status,
the primary backup job can keep the archivelog while not applied to standby.

Code: Select all

rman backup job....
...
...



RMAN>
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_22/o1_mf_1_106_8wccsh9k_.arc thread=1 sequence=106
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_22/o1_mf_1_107_8wccsjn0_.arc thread=1 sequence=107
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_22/o1_mf_1_108_8wccsmlx_.arc thread=1 sequence=108
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_22/o1_mf_1_109_8wccsply_.arc thread=1 sequence=109
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_22/o1_mf_1_110_8wccssn7_.arc thread=1 sequence=110
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_22/o1_mf_1_111_8wccswn3_.arc thread=1 sequence=111
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_22/o1_mf_1_112_8wccszrx_.arc thread=1 sequence=112
List of Archived Log Copies for database with db_unique_name PRIMARY
=====================================================================
...
...
...



But, i found that if I

1. shutdown my standby database.
2. create some archivelog, say, switch log.
3. make a full backup like before.

then, i found that the backup job will backup according the policy and delete all the
archivelog even the log is not applied to standby.

If this is normal, if network is not stable while backup, some archivelog will be lost ?
or for safe, delete the archive after more backup , but this will use more disk space ?

thanks.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Data Guard Environment Backup

Postby Tim... » Sat Jun 22, 2013 9:04 pm

Hi.

This is normal. The important thing from a backup perspective is your primary database is safe, so backups do what they need to do to protect your primary system.

You have a couple of solutions:

1) Only delete the archived redo logs after they've been backed up twice, so you leave plenty of time for them to get picked up by the standby.
2) Carry on as you are. If you hit a problem, restore the missing archived redo logs from the backups, so the standby can pick them up.

If you are using standby redo logs the changes have already reached the standby server before the archive switch has occurred, so this should never really be a problem. Also, if your network is flaky, then your standby is pretty much worthless, so that needs to be resolved anyway. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

peterx
Senior Member
Posts: 208
Joined: Wed Feb 09, 2011 7:07 am

Re: Data Guard Environment Backup

Postby peterx » Sun Jun 23, 2013 5:08 am

hi Tim,

very thanks for your help!

Yes, I had try in case the log is deleted by backup job while I shutdown the standby. The only thing
i can do is just restore the archivelog. Then data guard can simply transfer and apply it automatically.


If you are using standby redo logs the changes have already reached the standby server before the archive switch has occurred
<----- Do you mean by real-time apply ? Only start the standby database by :

Code: Select all

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE

right ?

thanks.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Data Guard Environment Backup

Postby Tim... » Sun Jun 23, 2013 7:42 am

Hi.

Yes. Use:

Code: Select all

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;


Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 11 guests

cron