OraFAQ Forum: Backup & Recovery » How can get Archived log size in advance

Home » RDBMS Server » Backup & Recovery » How can get Archived log size in advance (9i to 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can get Archived log size in advance [message #480727]

Tue, 26 October 2010 13:13

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

Report message to a moderator

Re: How can get Archived log size in advance [message #480728 is a reply to message #480727]

Tue, 26 October 2010 13:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B13789_01/server.101/b10755/dynviews_1015.htm

Report message to a moderator

Re: How can get Archived log size in advance [message #480729 is a reply to message #480728]

Tue, 26 October 2010 13:32

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!

Report message to a moderator

Re: How can get Archived log size in advance [message #480730 is a reply to message #480729]

Tue, 26 October 2010 13:38

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: How can get Archived log size in advance [message #480731 is a reply to message #480730]

Tue, 26 October 2010 13:45

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"

Report message to a moderator

Previous Topic:	how to reuse the obsolete backup in rman
Next Topic:	How to Take Backup on every 30 Min

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 18:57:17 CST 2024