How can I quickly make a copy of an Oracle database?

Question

Oracle

Good day.
Tell me, how can I quickly make a copy of the Oracle database?
At the moment, deploying a 44GB dump takes about 5 hours. Previously used Veritas Replication Exec on 32-bit Windows and copied over VSS. Now there is already 64-bit Windows and Veritas does not work on it. I liked the idea of ​​copying the changed blocks of files, but they did not find a similar software.

Answer 1

On the merits of the question:
We made 3 standbys of which:
1 is standby itself,
and 2 others are just for developers, tests, etc.
These same "2 others" are full-fledged physical standby at night - they roll data from the working one,
and during the day they switch to snapshot standby - for the work of "developers, tests, etc."
Switching is organized by cron scripts - "open" in the morning, "close" in the evening.
In the evening, if necessary, you can not close it - the main thing is that there is enough space on the disk.
At the same time, every day we have a fresh "slice" of the working database for "developers, tests, etc."
PS
"At the moment, deploying a 44GB dump takes about 5 hours. "
We deploy a separate (not standby) test database in 20 hours.
~6Tb, rman duplicate from active or backup location, 12 threads

Answer 2

Read this:
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
A 38-40 Gb base is transferred in less than an hour.
Or perhaps a better way:
http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php

Answer 3

If 11g, then you can clone on the fly from the active database without creating a backup:
rman target [email protected] auxiliary [email protected]
DUPLICATE TARGET DATABASE TO db2
FROM ACTIVE DATABASE
DB_FILE_NAME_CONVERT '/u01/oradata/db1/','/u01/oradata/db2 /'
SPFILE
PARAMETER_VALUE_CONVERT '/u01/oradata/db1/','/u01/oradata/db2/'
SET LOG_ARCHIVE_DEST '/u01/oradata/arc/db2/'
SET LOG_FILE_NAME_CONVERT '/u01/oradata/db1/','/ u01/oradata/db2/';
File name conversion is relevant if we make a copy on the same host

Answer 4

How often should this operation be performed? If for fault tolerance, then did not think in the direction of the Standby-base in Mirror mode to the main one?
At the same time, all transactions made on the main base will be automatically applied on Standby; the database can be used for Read-only operations (for example, reporting), and quickly turned into production, if necessary.

Answer 5

And if you automate the filling of the dump for the night? In this case, even 5 hours is not a problem - let him calmly transfer from production to developers.
Or is production at night critical for such a load?
With this approach, the problem of deploying a copy for a long time still remains, but here it already rests more on hardware ... Bottleneck in disks?