Database Reference
In-Depth Information
Once the media manager software is successfully installed, it needs to be tightly integrated and must interact with
RMAN. After the configuration, ensure that an RMAN can interact without any issues, and you need to configure or
set the SBT channels in RMAN pointing to appropriate media manager software. The following examples of different
MML options illustrate the backup run level configuration settings with RMAN:
OSB:
RMAN> run{
ALLOCATE CHANNEL ch00 DEVICE TYPE sbt
PARMS 'SBT_LIBRARY=/<dir_location>/lib/libobk.so,
ENV=(OB_DEVICE=drive1,OB_MEDIA_FAMILY=datafile_mf)';
.......
Release channel ch00;
}
Symantec NetBackup:
RMAN> run{
allocate channel ch00 type 'SBT_TAPE';
allocate channel ch01 type 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=host_name,NB_ORA_POLICY=RONDB_FULL_LEVEL0,NB_ORA_SERV=netbackup_master_server_name';
..
release channel ch00;
release channel ch01;
}
IBM TDPO:
RMAN> run{
ALLOCATE CHANNEL ch00 type 'sbt tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/tdpo.opt)';
;
..
release channel ch00;
release channel ch01;
}
You must ensure that the MML is configured successfully without any issues; otherwise, you will run into troubles
executing backup/recovery operations. Similarly, you can also define static MML tape configuration in the RMAN
configuration.
Online Backup and Recovery Prerequisites
As a prerequisite to perform a wide range of online database backup and recovery operations, with or without RMAN,
the database in the context must be configured in archivelog mode with a few additional recovery-related database
initialization parameters. The following procedure configures a RAC database in archivelog mode and also sets the
database recovery-related initialization parameters:
1.
Define a user-specified, upper-limit size to the recovery destination:
SQL> alter system set db_recovery_file_dest_size=1g SCOPE=BOTH SID='*';
