Infra_DBA1
asked on
How Do I refresh Oracle Database?
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
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
Also:
What version (all 4 numbers)?
What exactly did you delete/restore?
Best would probably be an export/import if possible.
What version (all 4 numbers)?
What exactly did you delete/restore?
Best would probably be an export/import if possible.
ASKER
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.
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.
Can you take a copy to restore from now?
You'll save some time and a lot of headaches if you can.
ASKER
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
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.
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.
ASKER
Thanks for your time, much appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What backup was done and with what tool?