OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Backup size (oracle,10.2.0.4,solaris)

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

Backup size [message #424653]

Mon, 05 October 2009 03:22

replicated
Messages: 31
Registered: July 2009

Member

Hi

How do i calculate the total size of a level 0 backup taken by RMAN.Is there a view which gives such info or do i have to check size on DISK from the actual size of pieces.

Report message to a moderator

Re: Backup size [message #424655 is a reply to message #424653]

Mon, 05 October 2009 03:27

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Use

RMAN>List backup of backupset

there, you'll get information about backup file

Report message to a moderator

Re: Backup size [message #424674 is a reply to message #424653]

Mon, 05 October 2009 04:29

replicated
Messages: 31
Registered: July 2009

Member

Well thanks

I was looking moe like a view from where i can calculate the size.As far as doing a List backup from RMAN prompt will give a list of lots pieces and sets,have to calculate manually .

Report message to a moderator

Re: Backup size [message #424731 is a reply to message #424674]

Mon, 05 October 2009 12:45

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check V$BACKUP_PIECE or V$BACKUP_PIECE_DETAILS.

[Updated on: Mon, 05 October 2009 12:46]

Report message to a moderator

Re: Backup size [message #425576 is a reply to message #424653]

Fri, 09 October 2009 12:57

mohd_dba
Messages: 19
Registered: October 2009

Junior Member

Please go ahead with the command through RMAN,

rman>list backup of database;

Thanks,
Afroze.

Report message to a moderator

Re: Backup size [message #425595 is a reply to message #425576]

Fri, 09 October 2009 19:07

ebrian
Messages: 2794
Registered: April 2006

Senior Member

mohd_dba wrote on Fri, 09 October 2009 13:57

Please go ahead with the command through RMAN,

rman>list backup of database;

Thanks,
Afroze.

Did you not read the OP's request ?

replicated wrote on Mon, 05 October 2009 05:29

Well thanks

I was looking moe like a view from where i can calculate the size.As far as doing a List backup from RMAN prompt will give a list of lots pieces and sets,have to calculate manually .

Report message to a moderator

Previous Topic:	Problem with recovery of database
Next Topic:	Applying archive logs across OS platforms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 00:51:10 CDT 2024