Database Reference
In-Depth Information
'c:\oracle\oradata\neworcl\control02.ctl'
set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'
set log_file_name_convert
'c:\oracle\oradata\orcl', 'c:\oracle\oradata\neworcl';
Backup-Based Database Duplication
Using the
DUPLICATE DATABASE
command without the
FROM ACTIVE DATABASE
parameter
starts backup-based database duplication. The auxiliary channel will be allocated automati-
cally. No additional channel is required with backup-based database duplication.
When executing a backup-based database duplication, RMAN will determine the last
archived redo log available. RMAN will then restore the duplicate database to the point of
that last available archived redo log by default. You can use the
UNTIL
or
TO RESTORE POINT
parameter to change this behavior. Here is an example of the RMAN
DUPLICATE
command
performing a backup-based database duplication:
duplicate target database to neworcl
spfile
set control_files 'c:\oracle\oradata\neworcl\control01.ctl',
'c:\oracle\oradata\neworcl\control02.ctl'
set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'
set log_file_name_convert 'c:\oracle\oradata\orcl',
'c:\oracle\oradata\neworcl';
After the Duplication
Once the database duplication is complete, the duplicated database will be opened and
operational. You can use the
RESTRICTED SESSION
parameter of the
DUPLICATE
command
to indicate that RMAN should open the database in a restricted session only. You should,
of course, consider backing up the newly created database on a regular basis.
In Exercise 7.1, you'll be duplicating a database using backup-based database
duplication.
e xeRCiSe 7.1
Duplicating a Database Using Backup-Based Duplication
In this exercise, you will use backup-based duplication to create a database on the same
system that the target database resides on. For this exercise, your database should
be running in ARCHIVELOG mode and all networking to the target database should be
already configured
1.
Back up your database as shown in Exercise 3.2 in Chapter 3.
Search WWH ::
Custom Search