| Oracle RMAN backup [message #554047] |
Thu, 10 May 2012 01:18  |
 |
gauravsrivastava
Messages: 22
Registered: November 2011
Location: india
|
Junior Member |
|
|
Hi All,
My production database is about 900 GB in size but the actual data in our database is only approx 600Gb it means 300GB is a deleted data and not fragmented, as per my understanding the best way to resolve fragmentation is Import/Export but we can go for this option because its a very time taking process.
We are taking full database backup using RMAN every week and also going to upgrade our production database from Oracle SE to Oracle EE edition using the same full database RMAN backup, as i know Rman is also not backup of those blocks which not containing any data , it means if we will use Rman full backup to setup our new EE database it will only 600GB of data not 900GB or there is only Export/Import to remove fragmentation
Waiting for your valuable Advise.
Gaurav-
Thanks
|
|
|
|
| Re: Oracle RMAN backup [message #554048 is a reply to message #554047] |
Thu, 10 May 2012 01:52  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Almost certainly, you are trying to solve a non-existent problem. Some questions:
Quote:Database is about 900 GB in size but the actual data in our database is only approx 600Gb How did you derive these figures?
Quote:it means 300GB is a deleted data Why do you say this?
Quote:the best way to resolve fragmentation What do you mean by "fragmentation", and why would it be a problem?
[Updated on: Thu, 10 May 2012 01:54] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
