Database Backup and Recovery (MOSC)

MOSC Banner

Using Transportable Tablespaces Recovery Method for Consolidation of the Testing/Development Copy of

edited May 29, 2011 9:08PM in Database Backup and Recovery (MOSC) 3 commentsAnswered
Hello,
I am dealing with the idea to use TTS recovery for Testing/Development Copy of the production database.
This should be the regular cycling process ran every few days according to the demands of the fresh production data in test database.

The test/development database is divided in two parts:

Group PROD
- owners of the data, objects, privileges, roles, accesses  that is refreshed from the production database and then masked with
  aligned tablespaces ( data and index tablespace for each )

Group DVL/TST
- owners of the data and objects, privileges, roles, accesses of the projects in development/testing phase
  with aligned tablespaces ( data and index ) ...

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center