• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

how to export over 40tbs from source to target

How to clone  a large database
Size: 40tbs

Linx RHEL5
Oracle 11gr2
0
taaz
Asked:
taaz
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
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
 
gopiseraCommented:
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
 
slightwv (䄆 Netminder) Commented:
>>In 11g R2 we can even clone the database actively

Still using the RMAN DUPLICATE command which was mentioned previously.
0
 
taazAuthor Commented:
Thanks, You put me to the right track and now I am going through the docs.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now