We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How Do I refresh Oracle Database?

Medium Priority
786 Views
Last Modified: 2013-12-19
I am new to the Oracle Database, I have no idea how it works. What I want to know is steps and commands on refreshing the Pre Production Database with the Production Database.
The restored database from Production dates back to the 2nd of April. What I've done so far is shutdown the database in Pre Prod, deleted all database folder in the respective folder
and restored the database files from the backup for the 2nd of April and copied them into the folder. Need urgent assistance
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
What OS?
What backup was done and with what tool?
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Also:
What version (all 4 numbers)?
What exactly did you delete/restore?


Best would probably be an export/import if possible.

Author

Commented:
The OS for both Pre Production & Production server is Windows 2003 R2 and the version of Oracle is 9.2. Our main application Ellipse runs off Oracle so we are trying to refresh the Ellipse Databases on Oracle. So we deleted the Ellipse Database files and restored it from back with data dating back to 02 April. We use HP Data protector to backup all our files to disk and the it gets backed up to tapes.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Don't know hp data protector.  Can't help with that.

Can you take a copy to restore from now?

You'll save some time and a lot of headaches if you can.

Author

Commented:
Right now the only copies that we can take is that of the 02nd of April. What we did is restore the database files to Pre Production then copied those files into the respective folder. In Production the database files are sitting on 3 different partitions, which are, E: , F: & G:, with path name as, eg, for one partition it reads, E:\oradata\ellprd. So yeah we restored files from the 3 partitions onto the Pre Production server, then copied all those in files in each different folder into one folder on Pre Production called E:\oradata\ellpre. That's we am stuck now, the script to use to run the refresh. These are Ellipse databases
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
The problem is just restoring the files is only half the battle.  Where they are/were is less important as to what they are.

Without knowledge of how Oracle works this will be very difficult through a question and answer site like this.

I'm about done for the day.  Hopefully another Expert will have the time to try to walk you through this.

If it is urgent, I would look towards plan-B.

Author

Commented:
Thanks for your time, much appreciated.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.