Home » RDBMS Server » Server Administration » Oracle RMAN backup (Oracle10G SE on RHCE 6)
Oracle RMAN backup [message #554047] Thu, 10 May 2012 01:18 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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

Re: Oracle RMAN backup [message #554980 is a reply to message #554048] Sun, 20 May 2012 10:38 Go to previous message
emergingdba
Messages: 13
Registered: April 2011
Location: bangalore
Junior Member

If you are statj g 600GB of data, the other 300GB could be indexes. Have you checked about indexes?. Deleted data/unwanted data will be written into recyclebin. I really doubt if recyclebin can grow that huge as much as 300GB.
Previous Topic: catalog.sql & catproc.sql
Next Topic: Ora-04030
Goto Forum:
  


Current Time: Thu Mar 28 19:27:13 CDT 2024