Database Administration (MOSC)

MOSC Banner

How to minimize the recovery time of database:

edited Oct 7, 2014 10:02AM in Database Administration (MOSC) 3 commentsAnswered

We have a large scale OLTP database (11TB), (11gR2, 11.2.0.3) having the operations 24/7. Our database is connected with the Application servers and database is also connected with the VAS (VALUE ADDED SERVICES) applications, and any downtime in production database severely affects our Financials.

We are continuously making changes to the database that does needs the downtime. Like data purging, addition of new Packages, Procedures, index creations, etc.

We want to know the best approach through which we can minimize the restore time in case any thing wrong happens to production database. Can we create a parallel database that can be synced with the production database and in case of any issues/failure at production we can quickly switch to secondary, but we need to make sure that this activity takes minimum time.  Like can we use;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center