Database Reference
In-Depth Information
You can use the
DUPLICATE
command to exclude tablespaces, as shown here:
Duplicate target database to neworcl nofilenamecheck spfile skip tablespace users;
You can also define a restore point, as shown in this example:
Duplicate target database to neworcl nofilenamecheck spfile skip
tablespace users to restore point 'Test';
You can have Oracle open the duplicated database in restricted mode by adding the
OPEN
RESTRICTED
parameter, as follows:
Duplicate target database to neworcl nofilenamecheck spfile open restricted;
As with pretty much everything else Oracle, the
DUPLICATE
command
is well documented. We strongly recommend that you review the Oracle
Database Backup and Recovery Reference (Oracle part number B28273-02)
for more information on all RMAN-related commands.
Active Database Duplication
When you perform standard RMAN database duplication, the server where the new data-
base is going to be created must have access to the RMAN backup set files of the target
database. This can be problematic if the systems do not have a way to share storage or if
security restrictions make maintaining NFS mounts impractical. Also, if the target data-
base has not yet been backed up, then you would not be able to duplicate it (this is a much
less frequent situation).
In cases like this, you can use an RMAN feature called Active Database Duplication.
Active Database Duplication sources the duplicate database creation from the target data-
base itself rather than from RMAN backup sets. Active Database Duplication uses the
network to move the data from the target database to the duplicate database being created
(thus, a network connection must be able to be established between the servers where the
target and duplicated database reside).
Active database duplication is started by issuing the RMAN
DUPLICATE DATABASE
command and including the
FROM ACTIVE DATABASE
parameter. Active database duplica-
tion is not the default.
When you perform active database duplication, Oracle will create the auxiliary channel to
the auxiliary database. An additional target-database RMAN channel will also be required.
If you have configured automated channels, this should be sufficient. If not, you will need to
allocate a channel manually with the
ALLOCATE CHANNEL
command.
Finally, the
UNTIL
and
TO RESTORE POINT
clauses are not valid when doing an active
database duplication. Here is an example of the RMAN
DUPLICATE
command performing
an active database duplication:
duplicate target database to neworcl from active database nofilenamecheck
spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',
Search WWH ::
Custom Search