Home » RDBMS Server » Backup & Recovery » Estimating storage space for backing up
Estimating storage space for backing up [message #610035] Mon, 17 March 2014 02:37 Go to next message
kakakoko
Messages: 22
Registered: March 2014
Junior Member
Hi,


If the maximum size of database equals 20 terabytes,
How much storage space for backing up should be considered?

What type of storage do you recommend?(such as Tape,External Hard,Attached Disk ...)

Report message to a moderator

Re: Estimating storage space for backing up [message #610037 is a reply to message #610035] Mon, 17 March 2014 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ It depends on the content of the datafiles and if you use compression or not.
2/ It depends on how much you want to pay and what is the time you have to backup and the one to recover.

Report message to a moderator

Re: Estimating storage space for backing up [message #610047 is a reply to message #610037] Mon, 17 March 2014 03:36 Go to previous messageGo to next message
kakakoko
Messages: 22
Registered: March 2014
Junior Member

Thanks for your reply Michel Cadot.
Yes you are right, but I wanted this information for the Feasibility study.
I wanted to know if the maximum size of data equals 20 terabytes, we need backup storage space 20 terabytes? and the previous question on the type of storage ?

Report message to a moderator

Re: Estimating storage space for backing up [message #610050 is a reply to message #610047] Mon, 17 March 2014 03:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can't know without knowing the points I mentioned.

Report message to a moderator

Re: Estimating storage space for backing up [message #610204 is a reply to message #610050] Tue, 18 March 2014 07:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
how much of the 20TB are indexes?

Report message to a moderator

Re: Estimating storage space for backing up [message #610213 is a reply to message #610035] Tue, 18 March 2014 08:52 Go to previous messageGo to next message
kakakoko
Messages: 22
Registered: March 2014
Junior Member
Quote:
how much of the 20TB are indexes?

The type of more data are blob that are not indexed.

And another question:
The system that oracle running on How much RAM should be have and How much of RAM should be allocate to oracle (in the case of the memory management in SGA is automatic)?
IFU:
the Data Block size is 32 KB.
The more of queries retrieves blob data. The size of blob data are between 4 KB and 100 KB.
A query may retrieves 10,000 blob data.

[Updated on: Tue, 18 March 2014 09:40]

Report message to a moderator

Re: Estimating storage space for backing up [message #610220 is a reply to message #610213] Tue, 18 March 2014 10:05 Go to previous message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
It depends on the usage. Test with the expected workload?
For backup it also counts how many copies you want to keep, what backup mode, how much of it is read only...

Report message to a moderator

Previous Topic: Netbackup Error : specified client does not exist in the specified policy
Next Topic: Restore from RMAN full backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 23 09:40:52 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.