This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Mar 4, 2013 12:37 PM by ADaniel Go to original post RSS
  • 15. Re: Duplicate huge schema
    TSharma-Oracle Guru
    Currently Being Moderated
    RMAN does block level recovery. It is much faster than export. With multiple channel allocation, it can restore 2 TB of database in less than 3 hours(ofcourse its little depends upon your hardware) also
  • 16. Re: Duplicate huge schema
    TSharma-Oracle Guru
    Currently Being Moderated
    Please check the document for duplicating the database.
  • 17. Re: Duplicate huge schema
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    If both databases are on the same server, you could "transfer" the data over DB Links.
    If you use normal datapump without DB Links, you'd need to have enough disk space to create the dump files for the data. Also, you'd be doing double the reads and writes (read from source, write to dump, read from dump, write to target) instead of DB Links (read from source, write to target).
    Define the DBLink over IPC instead of TCP so that you don't suffer TCP overheads.

    Hemant K Chitale
  • 18. Re: Duplicate huge schema
    User286067 Journeyer
    Currently Being Moderated
    for 2TB i think rman clone might be a faster option than expdp/impdp. You will get your data, but index creation and constraint enabling would probably kill you(r timing). No one in their right mind puts production and non-prod on same server, granted there will be some but that would be classic shooting-yourself-in-the-foot.

    If you already have a hotbackup, just use it, it will not only make it easier, it will also validate that your backups are actually usable to re-create database which would overwhelm your internal and external auditors with joy.
  • 19. Re: Duplicate huge schema
    ADaniel Newbie
    Currently Being Moderated
    Starting from 10g there is a new option in RMAN:
    RMAN Tablespace Point-in-Time Recovery (TSPITR)
1 2 Previous Next


  • Correct Answers - 10 points
  • Helpful Answers - 5 points