Databases Reference
In-Depth Information
Solution
You can use the following steps to optimally configure RMAN in a standby database. We're assuming that the standby
database is one for which you take backups.
1.
Log in to RMAN and connect to the standby database, as well as to the recovery catalog:
$ rman target sys@standby catalog rman@catdb
2.
Configure the automatic backup of the SPFILE and the control file:
RMAN> configure controlfile autobackup on;
3.
Configure backup optimization:
RMAN configure backup optimization on;
4.
Configure a tape channel for the backups:
RMAN> configure channel device type sbt parms 'channel parameters';
5.
Configure the deletion of the archived logs after backing up n times (n=2, for example):
RMAN> configure archivelog deletion policy backed up 2 times to device type sbt;
How It Works
As mentioned in the Solution section, we're assuming that you're using the standby database for backups. If you aren't
performing backups on the standby database, you can configure the deletion of archived logs once they're applied at
the standby database. Thus, Step 5 in the Solution section becomes:
RMAN> configure archvielog deletion policy to applied on all standby;
Registering Databases in a Data Guard Environment
Problem
You want to register both the primary and the standby database in an Oracle Data Guard environment with RMAN.
Solution
To register a primary database, execute the
register database
command, as shown here:
$ rman target sys@primary catalog sys@catdb
RMAN> register database;
The
register database
command registers the primary database with RMAN. You don't need to explicitly
register the standby database with RMAN. RMAN will automatically register the standby database in the catalog when
you connect to the standby database.
