N/APosted on - 12/21/2011
My problem is about reducing the size of the database which is 6.5TB. Can someone help me on how to trim my database size? My data warehouse system is growing bigger and bigger. It has reached to an average growth of 500GB every month. It takes me 19 full hours for my RMAN to back up and save my data even though I already have enabled BLOCK_CHANGE_TRACKING_FILE. My bitmap indexes is there so it is useless to rebuild my indexes. Please help me. Thanks!
How to Trim Database Size?
To reduce database file size, there are lots of things that you can try to do this, These are the things that I can suggest to you:
1. Delete temporary files on your database.
2. Delete any files that is not important or trash files, it will help you a lot cause not all files in the database is useful or important. Try to delete those files.
3. Save your database to a utility program like archive program. It will reduce the database file size a lot.
4. Produce or provide a database copy without the trash files on it.
Hope this helps your problem.