Suggestions for large DB maintenance
Posted by: Leonidas Papoulakis
Date: October 05, 2018 03:48PM

Hello all,

i have one large database (more than 1,500 tables and total db size of 56GB) and i would like to ask for tips and guidance regarding the maintenance of such large database!

Will the size be a problem anytime? For example when i reach 4000 or 5000 tables, i am going to have an issue? At the moment i have a "problem" with the backup/restore of it. A complete backup takes around 5 hours to finish, so you can imagine how long it takes the restore!

As you can understand this is not a proper solution, because in case of a db crash, it will take me at least 12 hours to be back online! Any suggestion?

Options: ReplyQuote


Subject
Written By
Posted
Suggestions for large DB maintenance
October 05, 2018 03:48PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.