Home » RDBMS Server » Backup & Recovery » How can get Archived log size in advance (9i to 11g)
How can get Archived log size in advance [message #480727] Tue, 26 October 2010 13:13 Go to next message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
Hi Gurus,

I have a question about Archived Log size. Do you know any way to get the Archived Log size before issuing backup archive log statement.

One request: Do *Not* depends on OS scan the location which contains Archived log, since it may not correct if only backing up partial of Archived log.

The best way, so far I am thinking, is any possible to get the file size information from Oracle DB?

Thanks you all in advance!
Edgefree
Re: How can get Archived log size in advance [message #480728 is a reply to message #480727] Tue, 26 October 2010 13:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B13789_01/server.101/b10755/dynviews_1015.htm
Re: How can get Archived log size in advance [message #480729 is a reply to message #480728] Tue, 26 October 2010 13:32 Go to previous messageGo to next message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
Yes, here has size information. But it looks show size one by one. I will going to test if it can be easy to calculate several archived log size. I will update it later when I tried.

Thank you Mahesh very much!
Re: How can get Archived log size in advance [message #480730 is a reply to message #480729] Tue, 26 October 2010 13:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can sum the size and group by day and apply filter on what range of days you want.
Re: How can get Archived log size in advance [message #480731 is a reply to message #480730] Tue, 26 October 2010 13:45 Go to previous message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
Yes, it works. Thank Mahesh very much for help!
Solution is:
"SELECT SUM(BLOCKS * BLOCK_SIZE) FROM V$ARCHIVED_LOG WHERE SEQUENCE# BETWEEN XXXX AND XXXX"
Previous Topic: how to reuse the obsolete backup in rman
Next Topic: How to Take Backup on every 30 Min
Goto Forum:
  


Current Time: Thu Aug 21 21:31:30 CDT 2014

Total time taken to generate the page: 0.12107 seconds