Home » RDBMS Server » Backup & Recovery » Backup size (oracle,10.2.0.4,solaris)
Backup size [message #424653] Mon, 05 October 2009 03:22 Go to next message
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.

Re: Backup size [message #424655 is a reply to message #424653] Mon, 05 October 2009 03:27 Go to previous messageGo to next message
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
Re: Backup size [message #424674 is a reply to message #424653] Mon, 05 October 2009 04:29 Go to previous messageGo to next message
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 .
Re: Backup size [message #424731 is a reply to message #424674] Mon, 05 October 2009 12:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
Please go ahead with the command through RMAN,

rman>list backup of database;

Thanks,
Afroze.
Re: Backup size [message #425595 is a reply to message #425576] Fri, 09 October 2009 19:07 Go to previous message
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 .
Previous Topic: Problem with recovery of database
Next Topic: Applying archive logs across OS platforms
Goto Forum:
  


Current Time: Sat Dec 03 16:06:10 CST 2016

Total time taken to generate the page: 0.13156 seconds