RE: Duplicate function is a lot longer than a backup
- From: "vit\.spinka" <vit.spinka@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 30 Nov 2009 20:06:44 +0100
Have you tried and timed a restore operation, to determine if it will still
take so long?
One reason for such difference can be the fact that RMAN skips never used
blocks doing the backup - so if I create a huge 1TB tablespace but leave it
empty, it will still backup it up in just few seconds. However, during
restore/duplicate, the datafiles are created at their actual size - so restore
of that 1TB tablespace would still take a long time (depending on OS, some
could still do it fast, creating the file as sparse). In real world the
difference is usually not so big, but still could do a bold difference in time
needed for the restore.
Could this be your case?
Vit Spinka
Other related posts:
