Home » RDBMS Server » Backup & Recovery » Archivelog backup details from RMAN (oracle 11.2.0.1.0 linux 2.6)
Archivelog backup details from RMAN [message #517431] Tue, 26 July 2011 01:35
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
Dear Sir/Madam,

I just wanted to know how many archive logs have been backed up recently.
I first checked the archivelog sequence details from ASMCMD as below:


ASMCMD [+RECO/TEDW/ARCHIVELOG] > ASMCMD [+RECO/TEDW/ARCHIVELOG] > ls
2011_07_25/
2011_07_26/
ASMCMD [+RECO/TEDW/ARCHIVELOG] >
Below files are presented in folder - 2011_07_25/

select min(sequence#),max(sequence#),thread#,count(sequence#) from v$archived_log
where name like '+RECO/tedw/archivelog/2011_07_25%'
group by thread#;

MIN(SEQUENCE#) MAX(SEQUENCE#)    THREAD# COUNT(SEQUENCE#)
-------------- -------------- ---------- ----------------
        285971         286519          1              549
        137960         138512          2              553

2 rows selected
.



select to_char(sysdate,'Dy dd mon yyyy:hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'DYDDMON
------------------------
Tue 26 jul 2011:02:17:04

1 row selected.



select sysdate-1 from dual;

SYSDATE-1
---------
25-JUL-11

1 row selected.


then i checked backup details thro RMAN as below:


RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME 'sysdate-1';
...
...
...
  List of Archived Logs in backup set 2453
  Thrd Seq     Low SCN        Low Time  Next SCN      Next Time
  ---- ------- ----------     --------- ----------    ---------

  1    285968  10695335353270 25-JUL-11 10695335399500 25-JUL-11
  1    285969  10695335399500 25-JUL-11 10695335473187 25-JUL-11
  1    285970  10695335473187 25-JUL-11 10695335496288 25-JUL-11
  2    137946  10695334455089 25-JUL-11 10695334533306 25-JUL-11
  2    137947  10695334533306 25-JUL-11 10695334585793 25-JUL-11
  2    137948  10695334585793 25-JUL-11 10695334666311 25-JUL-11
  2    137949  10695334666311 25-JUL-11 10695334734440 25-JUL-11
  2    137950  10695334734440 25-JUL-11 10695334797219 25-JUL-11
  2    137951  10695334797219 25-JUL-11 10695334846892 25-JUL-11
  2    137952  10695334846892 25-JUL-11 10695334894568 25-JUL-11
  2    137953  10695334894568 25-JUL-11 10695334945781 25-JUL-11
  2    137954  10695334945781 25-JUL-11 10695334988581 25-JUL-11
  2    137955  10695334988581 25-JUL-11 10695335041427 25-JUL-11
  2    137956  10695335041427 25-JUL-11 10695335188210 25-JUL-11
  2    137957  10695335188210 25-JUL-11 10695335319582 25-JUL-11
  2    137958  10695335319582 25-JUL-11 10695335399806 25-JUL-11
  2    137959  10695335399806 25-JUL-11 10695335497205 25-JUL-11

RMAN> exit
I have pasted the partial output..but output put shows the archivelogs backup has been taken
upto seq.no: 285970( from thread1 ) and
upto seq.no:137959(from thread 2) for date: 25th july.

But for 25th july, the range of sequence number currently i have under folder : 2011_07_25/ is:

285971 - 286519 ( for thread 1 )
137960 - 138512 ( for thread 2 )

if backup is upto seq.no 285970(thread1) and 137959(thread2), then why date shows as 25-JUL-11, and not 24-JUL-11 in RMAN ouptut ?

i request you to clarify the same...
Previous Topic: How can i recover my db
Next Topic: Backup Sync problem
Goto Forum:
  


Current Time: Fri Mar 29 01:04:55 CDT 2024