 |
|
RMAN - duplicate target database for standby
dorecover
Oracle Tips by Burleson |
Oracle Data Guard- Recovery Manager and Data
Guard
Creating an Image Copy of the Primary
Database
After this script is executed, exit from RMAN,
open the primary database and execute the following statement to
archive the latest SCN:
ALTER SYSTEM
ARCHIVE LOG CURRENT;
Duplicate and Recover as Standby
Database
Use the following command to duplicate the
primary database from an image copy and recover it. The duplication
process will create the standby database. Before starting the
duplication process, the Oracle instance
should be started, but it
should not be mounted. Then, connect to the auxiliary and target
database using RMAN and issue the duplicate command as shown below:
DBA@jrbk01;
rman auxiliary / target sys/change_on_install@appsdb
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY DORECOVER;
If the Oracle instance
is on
remote host, copy the image copies to the remote host in the same
directory structure. The file system mount option can be used to
facilitate it.
Once the database is duplicated, start the
managed recovery process and test the newly created Oracle instance
as described in the previous section.
Backup of a Oracle instance
Using RMAN
According to the information presented in
earlier chapters, it is clear that a Oracle instance
can take the
load of the backup operation from the primary database. In fact,
offloading the backup operation to the standby site is a preferred
solution to reducing the computing resource consumption on the
primary database. The data files and archived redo log files can be
backed up on the standby site, and those backed up files can be used
to recover the primary database. However, the control file of the
Oracle instance
cannot be used to recover the primary database.
|
