Solved

how to export over 40tbs from source to target

Posted on 2013-05-23
4
257 Views
Last Modified: 2013-06-05
How to clone  a large database
Size: 40tbs

Linx RHEL5
Oracle 11gr2
0
Comment
Question by:taaz
[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
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 39192232
I assume you have ruled out RMAN DUPLICATE?

Short of that:
create a duplicate database on the destination with the same file names
shutdown the source
ftp the datafiles over
startup both


If you are using *nix, you can compress the datafiles before you ftp them and save on transfer time.

You can probably to it all in-stream with pipes so you don't have to store the compressed files on disk to save some write times.
0
 
LVL 3

Assisted Solution

by:gopisera
gopisera earned 250 total points
ID: 39193856
Hi,

In 11g R2 we can even clone the database actively

Active Database Duplication   ==>  New feature.


DUPLICATE DATABASE TO <new_dbname> FROM ACTIVE DATABASE  SPFILE  NOFILENAMECHECK;

See the link for Active database duplication

http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php



We can perform this based on scn we can clone the database actively to other location.




Thanks,
Ramesh G
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39194083
>>In 11g R2 we can even clone the database actively

Still using the RMAN DUPLICATE command which was mentioned previously.
0
 

Author Closing Comment

by:taaz
ID: 39223456
Thanks, You put me to the right track and now I am going through the docs.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

635 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