Database Backup and Recovery (MOSC)

MOSC Banner

How to create a physical copy of a database excluding user data

edited Nov 11, 2018 4:05AM in Database Backup and Recovery (MOSC) 12 commentsAnswered

For some very specific purposes, I need a clone of a production database fulfilling following conditions:

  1. It *MUST* be a physical copy as far as following tablespaces are concerned: SYSTEM, SYSAUX, UNDO
  2. It  should also contain all other tablespaces and user objects but *WITHOUT ANY APPLICATION DATA*. Deleting data or truncating objects after the creation is not an option.

I could do a duplicate skipping all user tablespaces (mentioned TS are always cloned automatically), but then, also all user objects would be missing. In this particular case, we don't care about those missing user objects as long as Oracle tolerates this situation, but their references should still exist in the dictionary. I am not sure about the implications of working with such a database, but we are troubleshooting a bug that is completely unrelated to user objects or data and leaves them untouched, and we could get along with that database as far as there are no Oracle errors.

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