2 Replies Latest reply: Dec 12, 2012 6:30 PM by onedbguru RSS

    Restore Missing Data from Production database to QA database

    Meenakshy singh
      Hi Gurus,

      My oracle database version is 9iR2.Some of the Data are missing from QA database.In both prod & QA, same instance is running smartemc. but directory structure is different.No dataguard.

      1.How do I restore the missing data from production to QA database,without shuttdown of production database.

      2.How to restore backup in QA database without shut down of production database?Kindly provide steps.

      3.How many ways we can do the restoration without shutdown of production database and which one is easier to do?with steps.

      4.We have daily RMAN backup of production database,can I restore from RMAN backup?provide me step by step procedure.

      5.can we do imp/exp for missing data in oracle 9i.How?please give me step by step procudere.

      6.My oracle size of production database is 75 GB.so how much space required for QA database,is it will same or less than 75GB?

      7.After restoration of backup ,can we get back the missing data in QA?

      Please reply me soon.Its urgent.


      Thanks
      Meena