RMAN Archivelog Backup Counting
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 14 Mar 2008 03:42:26 -0700 (PDT)
Hi All,
I'm experiencing the behavior below and I'm not sure if this is correct (I've
read the manual wrong) or if I'm hitting a bug. Would anyone here care to
comment? Here's the steps - I have, for the sake of discussion, 5 active
archivelog destinations:
[1] Confirm that archivelog 578 has not been backed up.
[2] Backup archivelog 578 - ONCE only.
[3] List shows that archivelog 578 has been backed up 5 times, but I've only
backed it up once!
[4] List shows archivelog 578 has really only been backed up once as expected.
[5] Subsequent backup of archivelog 578 (not backed up 2 times) fails as RMAN
thinks it's been backed up 5 times already.
This is on 10.2.0.3.
Many thanks!
Charlotte
Here's the full RMAN output for the session:
[1]
RMAN> list backup of archivelog sequence 578 summary;
RMAN> sql "alter system switch logfile";
sql statement: alter system switch logfile
[2]
RMAN> backup archivelog sequence 578;
Starting backup at 25-MAR-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=578 recid=914 stamp=650275446
channel ORA_DISK_1: starting piece 1 at 25-MAR-08
channel ORA_DISK_1: finished piece 1 at 25-MAR-08
piece
handle=/recovery/TESTDB/backupset/2008_03_25/o1_mf_annjn_TAG20080325T080408_3ykdht18_.bkp
tag=TAG20080325T080408 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 25-MAR-08
[3]
RMAN> list archivelog sequence 578 backed up 5 times to disk;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
914 1 578 A 25-MAR-08 /oracle/archive1/TESTDB/1_578_654154315.dbf
915 1 578 A 25-MAR-08 /oracle/archive2/TESTDB/1_578_654154315.dbf
918 1 578 A 25-MAR-08 /oracle/archive5/TESTDB/1_578_654154315.dbf
917 1 578 A 25-MAR-08 /oracle/archive4/TESTDB/1_578_654154315.dbf
916 1 578 A 25-MAR-08 /oracle/archive3/TESTDB/1_578_654154315.dbf
[4]
RMAN> list backup of archivelog sequence 578 summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
227 B A A DISK 25-MAR-08 1 1 NO
TAG20080325T080408
[5]
RMAN> backup archivelog all not backed up 2 times;
Starting backup at 25-MAR-08
current log archived
using channel ORA_DISK_1
skipping archive log file /oracle/archive3/TESTDB/1_578_654154315.dbf; already
backed up 5 time(s)
skipping archive log file /oracle/archive2/TESTDB/1_578_654154315.dbf; already
backed up 5 time(s)
skipping archive log file /oracle/archive1/TESTDB/1_578_654154315.dbf; already
backed up 5 time(s)
skipping archive log file /oracle/archive4/TESTDB/1_578_654154315.dbf; already
backed up 5 time(s)
skipping archive log file /oracle/archive5/TESTDB/1_578_654154315.dbf; already
backed up 5 time(s)
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=579 recid=919 stamp=650275597
channel ORA_DISK_1: starting piece 1 at 25-MAR-08
channel ORA_DISK_1: finished piece 1 at 25-MAR-08
piece
handle=/recovery/TESTDB/backupset/2008_03_25/o1_mf_annjn_TAG20080325T080637_3ykdngtl_.bkp
tag=TAG20080325T080637 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 25-MAR-08
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RMAN Archivelog Backup Counting
