How to minimize the recovery time of database:
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;