Hi all
Not a DBA so I hope someone can help:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
Where are work, there are two databases that get refreshed from the live one.
- Reporting - Refreshed from Live nightly. It runs at 1AM and is done by morning. This is how I expect database copies to work based on backup and restore of SQL Server databases I've done in the past.
- Test - where I work. This is refreshed from the live database about once a month. When it is refreshed it is basically out of action for 3 days as the live database is copied into it. During this time, the test DB is available but many of its tables get wiped. I assume they are being emptied and refilled from the live DB or something, which seems slow and inefficient
Obviously I can only see these processes from the outside and I don't know what exactly is the difference between these two methods being used but they are obviously not the same. I want to ask the DBA to change the way the test DB is refreshed so it works the same way as the reporting one. However, I've hit some communication issues and I would like to be as specific as possible to avoid wasting time because I'm not getting anywhere so far!
In short, based on the above, can you tell what the two different methods are likely to be and what I should be asking the DBAs to change please?
Thanks very much for taking the time to read this and I look forward to hearing from you!