Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How Do I refresh Oracle Database?

Posted on 2011-04-19
8
Medium Priority
?
747 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
0
Comment
Question by:Infra_DBA1
  • 5
  • 3
8 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35429363
What OS?
What backup was done and with what tool?
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35429370
Also:
What version (all 4 numbers)?
What exactly did you delete/restore?


Best would probably be an export/import if possible.
0
 

Author Comment

by:Infra_DBA1
ID: 35429406
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.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35429427
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.
0
 

Author Comment

by:Infra_DBA1
ID: 35429492
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
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35429512
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.
0
 

Author Comment

by:Infra_DBA1
ID: 35429579
Thanks for your time, much appreciated.
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 35432330
OK, I'm back at a real computer.

The general process should go like this as long as the structure of the 'copy' is EXACT (same filesystem/directories/database name/...).  If you want to change the database name it gets more involved:

create a database on the test server with everything the same as production.  Shut it down, restore/overlay all the prod files.

If EVERYTHING (and I mean everything) has been restored, you should be able to startup the database.

You need to make sure you have all the control files and data files restored.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question