Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Migrate everything from test database to production in 11.2.0.2

Posted on 2013-06-10
9
Medium Priority
?
367 Views
Last Modified: 2013-06-11
Please advice and provide for the best method and steps in details for migration from test database to production.
0
Comment
Question by:lium1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 800 total points
ID: 39236117
I'm afraid we need more information.

Things like Size of database, what objects you are migrating, etc...

Off the top of my head, I would look at export/import.  Just export the schemas you want moved over and import them into the production database.
0
 
LVL 29

Assisted Solution

by:MikeOM_DBA
MikeOM_DBA earned 800 total points
ID: 39236148
Adding to the above:

* clone db using Rman
* clone db using data file copy
* create new prod db and use transportable tablespaces
* use datapump like slightwv's suggestion
:p
0
 

Author Comment

by:lium1
ID: 39236175
SlightWV,

Basically, moving everything from test to production.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 49

Assisted Solution

by:PortletPaul
PortletPaul earned 400 total points
ID: 39236344
'moving everything'

Double-check table contents:

Some tables may contain test data that should not be migrated. e.g. in testing there may be 'customers', 'orders', 'invoices' etc that are all bogus - and should never be in production.

On the other hand other tables may require the data (e.g. for lookup values).
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39237478
>>Basically, moving everything from test to production.

This doesn't answer the questions I posed.  

"Everything" could be 3 tables or 3000 tables.
It could be 100 Meg of data or 300 Terabytes of data.
It could be one schema or 100 schemas.
0
 

Author Comment

by:lium1
ID: 39237907
I meant all data plus schemas, tables (data files), etc ., and it is 500 gig of data.
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 800 total points
ID: 39237920
For 500 Gig I would look at cloning as suggest by MikeOM_DBA.

I would probably go with RMAN duplication:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126

Then change the name of the database when you restore in production.

If you are comfortable with Oracle, you can manually clone the database.

There are many blogs/links out there on how to clone an Oracle database and restore to a different server as well as changing the name once you've restored.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39238058
And...
Consider PortletPaul's suggestion to clean-up test data.
0
 

Author Closing Comment

by:lium1
ID: 39238117
Thanks guys!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

597 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