Restoring a test instance using files (archivelogs) from production instance.
Hi,
We have a test database which is a copy of our production database on July 24, 2012. The test db was created using datapump export/import db migration and has a different SID than the production. The test db was also opened for some querying after it was created.
I would like to ask, first: if it is POSSIBLE to roll forward the TEST DB to August 17, 2012 using backup files (on tape) of PRODUCTION DB. If possible, can you give me a simple and comprehensive guide? If not, is there a way to make the TEST DB consistent with the PRODUCTION DB?
We have a test database which is a copy of our production database on July 24, 2012. The test db was created using datapump export/import db migration and has a different SID than the production. The test db was also opened for some querying after it was created.
I would like to ask, first: if it is POSSIBLE to roll forward the TEST DB to August 17, 2012 using backup files (on tape) of PRODUCTION DB. If possible, can you give me a simple and comprehensive guide? If not, is there a way to make the TEST DB consistent with the PRODUCTION DB?
0