Members   Search   Help    Register    Login   Home
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: 20
Registered: July 2009
Junior 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 Go to previous messageGo to next message
Kamran Agayev
Messages: 76
Registered: February 2009
Location: Azerbaijan, Baku
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 Go to previous messageGo to next message
replicated
Messages: 20
Registered: July 2009
Junior 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 Go to previous messageGo to next message
ebrian
Messages: 2714
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.
Report message to a moderator
Re: Backup size [message #425595 is a reply to message #425576] Fri, 09 October 2009 19:07 Go to previous message
ebrian
Messages: 2714
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:NID- utility giving ora-01103 error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 21:03:43 CST 2009

Total time taken to generate the page: 0.29426 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.