This policy
is make sure that the backup of archivelog done before an archivelog is deleted
on standby database.
PRACTICAL
STEPS ARE AS BELOW:-
ON PROD:
#######################################################################################
FIRST CONFIGURE
ARCHIVELOG DELETION POLICY TO "APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO
DISK"
#######################################################################################
[oracle@PROD ~]$ rman target
sys/oracle_4U@orcl
Recovery
Manager: Release 12.2.0.1.0 - Production on Thu Aug 10 17:03:29 2017
Copyright
(c) 1982, 2017, Oracle and/or its affiliates.
All rights reserved.
connected to
target database: ORCL (DBID=1478070817)
BEFORE:
RMAN> SHOW ALL;
RMAN
configuration parameters for database with db_unique_name ORCL are:
CONFIGURE
RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE
BACKUP OPTIMIZATION OFF; # default
CONFIGURE
DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE
CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE
DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE
ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
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
RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE
SNAPSHOT CONTROLFILE NAME TO
'/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED
ON ALL STANDBY BACKED UP 1 TIMES TO DISK;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY
TO NONE;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY
TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;
new RMAN configuration parameters are
successfully stored
AFTER:
RMAN> show all;
using target database control file
instead of recovery catalog
RMAN configuration parameters for
database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO
REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; #
default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
# default
CONFIGURE CONTROLFILE AUTOBACKUP ON; #
default
CONFIGURE CONTROLFILE AUTOBACKUP
FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM
1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR
DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR
DEVICE TYPE DISK TO 1; # default
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 RMAN OUTPUT TO KEEP FOR 7
DAYS; # default
CONFIGURE
ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN>
ON STANDBY:
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ORCL MOUNTED
########################################################################
#--------- CHECK
THE LAST ARCHIVE RECEIVED FROM PRODUCTION --------------------------------------------#
########################################################################
SQL>
select thread#, max(sequence#) "Last Standby Seq Received"
from
v$archived_log val, v$database vdb
where
val.resetlogs_change# = vdb.resetlogs_change#
group by thread#
order by 1;
THREAD# Last Standby Seq Received
----------
-------------------------
1
194
#######################################################################
#-----------------CHECK THE LAST ARCHIVE APPLIED ON STANDBY----------------------------#
#-----------------CHECK THE LAST ARCHIVE APPLIED ON STANDBY----------------------------#
#######################################################################
SQL>
select max(SEQUENCE#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
---------------------
186
#####################################################################
#-------------------CHECK
THE ARCHIVELOGS WHICH ARE NOT APPLIED ON STANDBY-----------------#
#####################################################################
SQL> select SEQUENCE#,NAME from v$archived_log
where applied='NO';
SEQUENCE# NAME
----------
-----------------------------------------------------------------------------------
160 orcl
161 orcl
187
/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_187_drrgw23w_.arc
188
/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_188_drrgw39r_.arc
189
/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_189_drrgw6xy_.arc
190
/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_190_drrgw71r_.arc
191
/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_191_drrgy3c6_.arc
192
/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_192_drrgyz94_.arc
193
/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_193_drrh1hll_.arc
194 /u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_194_drrh2ofs_.arc
10 rows selected.
#######################################################################
LETS TAKE THE FULL BACKUP ALONG WITH ALL ARCHIVELOG WITH DELETE INPUT ON STANDBY
LETS TAKE THE FULL BACKUP ALONG WITH ALL ARCHIVELOG WITH DELETE INPUT ON STANDBY
#######################################################################
[oracle@STDBY]$ rman target sys/oracle_4U@orcldr
Recovery Manager: Release 12.2.0.1.0 - Production on Thu Aug 10
16:56:50 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1478070817, not open)
RMAN> backup database plus archivelog delete input;
Starting
backup at 10-AUG-17
using target
database control file instead of recovery catalog
current log
archived at primary database
allocated
channel: ORA_DISK_1
channel
ORA_DISK_1: SID=125 device type=DISK
channel
ORA_DISK_1: starting archived log backup set
channel
ORA_DISK_1: specifying archived log(s) in backup set
input
archived log thread=1 sequence=187 RECID=191 STAMP=951668698
input
archived log thread=1 sequence=188 RECID=192 STAMP=951668699
input
archived log thread=1 sequence=189 RECID=193 STAMP=951668702
input
archived log thread=1 sequence=190 RECID=194 STAMP=951668703
input
archived log thread=1 sequence=191 RECID=195 STAMP=951668763
input
archived log thread=1 sequence=192 RECID=196 STAMP=951668791
input
archived log thread=1 sequence=193 RECID=197 STAMP=951668871
input
archived log thread=1 sequence=194 RECID=198 STAMP=951668909
input
archived log thread=1 sequence=195 RECID=199 STAMP=951670645
channel
ORA_DISK_1: starting piece 1 at 10-AUG-17
channel
ORA_DISK_1: finished piece 1 at 10-AUG-17
piece
handle=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/backupset/2017_08_10/o1_mf_annnn_TAG20170810T165726_drrjryg9_.bkp
tag=TAG20170810T165726 comment=NONE
channel
ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel
ORA_DISK_1: deleting archived log(s)
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file
name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_187_drrgw23w_.arc
thread=1 sequence=187
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file
name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_188_drrgw39r_.arc
thread=1 sequence=188
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file
name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_189_drrgw6xy_.arc
thread=1 sequence=189
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_190_drrgw71r_.arc
thread=1 sequence=190
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_191_drrgy3c6_.arc
thread=1 sequence=191
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file
name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_192_drrgyz94_.arc
thread=1 sequence=192
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file
name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_193_drrh1hll_.arc
thread=1 sequence=193
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file
name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_194_drrh2ofs_.arc
thread=1 sequence=194
RMAN-08137: warning: archived log not deleted,
needed for standby or upstream capture process
archived log file
name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_195_drrjrwy2_.arc
thread=1 sequence=195
Finished
backup at 10-AUG-17
Starting
backup at 10-AUG-17
using
channel ORA_DISK_1
channel
ORA_DISK_1: starting full datafile backup set
channel
ORA_DISK_1: specifying datafile(s) in backup set
input
datafile file number=00001 name=/u01/app/oracle/oradata/ORCLDR/datafile/o1_mf_system_dqgdh8ls_.dbf
input
datafile file number=00003
name=/u01/app/oracle/oradata/ORCLDR/datafile/o1_mf_sysaux_dqgdjdg8_.dbf
input
datafile file number=00004 name=/u01/app/oracle/oradata/ORCLDR/datafile/o1_mf_undotbs1_dqgdk5xc_.dbf
input
datafile file number=00007
name=/u01/app/oracle/oradata/ORCLDR/datafile/o1_mf_users_dqgdk6z4_.dbf
channel
ORA_DISK_1: starting piece 1 at 10-AUG-17
channel
ORA_DISK_1: finished piece 1 at 10-AUG-17
piece
handle=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/backupset/2017_08_10/o1_mf_nnndf_TAG20170810T165727_drrjrzpf_.bkp
tag=TAG20170810T165727 comment=NONE
channel
ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished
backup at 10-AUG-17
Starting
backup at 10-AUG-17
current log
archived at primary database
using
channel ORA_DISK_1
channel
ORA_DISK_1: starting archived log backup set
channel
ORA_DISK_1: specifying archived log(s) in backup set
input
archived log thread=1 sequence=196 RECID=200 STAMP=951670682
channel
ORA_DISK_1: starting piece 1 at 10-AUG-17
channel
ORA_DISK_1: finished piece 1 at 10-AUG-17
piece
handle=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/backupset/2017_08_10/o1_mf_annnn_TAG20170810T165803_drrjt40o_.bkp
tag=TAG20170810T165803 comment=NONE
channel
ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel
ORA_DISK_1: deleting archived log(s)
RMAN-08137:
warning: archived log not deleted, needed for standby or upstream capture
process
archived log
file name=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/archivelog/2017_08_10/o1_mf_1_196_drrjt2tm_.arc
thread=1 sequence=196
Finished
backup at 10-AUG-17
Starting
Control File and SPFILE Autobackup at 10-AUG-17
piece
handle=/u01/app/oracle/fast_recovery_area/orcldr/ORCLDR/autobackup/2017_08_10/o1_mf_s_951668774_drrjt56h_.bkp
comment=NONE
Finished
Control File and SPFILE Autobackup at 10-AUG-17
RMAN>
WE CAN SEE
WARNING "RMAN-08137: warning: archived log not deleted, needed for standby
or upstream capture process". THIS
INDICATES THAT ARCHIVES ARE RECEIVED BUT NOT APPLIED TO STANDBY DATABASE FROM
sequence# 187 TO 195, SO RMAN JUST BACKUP THE ARCHIVES BUT NOT DELETING.
No comments:
Post a Comment