IBM Tivoli Storage Manager for Databases, Data Protection for Oracle, Version 6.3
Script examples
Sample RMAN scripts illustrate how to create parallel backup streams to Tivoli? Storage Manager server storage.
In these examples, to back up to Tivoli Storage Manager by using Data Protection for Oracle, you must specify type 'sbt_tape' in the RMAN script or within the global RMAN configuration settings.
Example 1:
When the Tivoli Storage Manager server and Oracle machines have multiple network cards, you can back up your data using multiple network paths to improve network throughput. Your environment is set up as follows:?The Oracle machine has two network cards with two addresses (A and B).
?The Tivoli Storage Manager server also has two network cards with two addresses (C and D).
?Paths exist between A and C, B and D, but not between A and D or B and C.
Create two backup streams (Oracle channels) without using two separate options files to point to different two different addresses. Channel t1 goes to address C, channel t2 goes to address D. Be careful not to send parts of your backup to two different Tivoli Storage Manager server because you will not be able to restore it.
You can maintain one Data Protection for Oracle options file and change the Tivoli Storage Manager server specification in an RMAN script in the following manner:run
{
allocate channel t1 type 'sbt_tape';
SEND channel t1 '-TCPSERVER=
allocate channel t2 type 'sbt_tape';
SEND channel t2 '-TCPSERVER=
backup
filesperset 5
format 'df_%t_%s_%p'
(database);
release channel t2;
release channel t1;
}
Example 2:
This backup script allocates two parallel connections to the Tivoli Storage Manager server. The Tivoli Storage Manager server views these connections as two separate sessions:
UNIX and Linux operating systems run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)';
backup
filesperset 5
format 'df_%t_%s_%p'
(database);
}
UNIX and Linux operating systems On AIX? operating systems, do not use /home/oracle11gr2/scripts/tdpo.opt in your path. "oracle11gr2 " exceeds the 8-character string limit for users on AIX.
Windows operating systems run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\oracle\scripts\tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\oracle\scripts\tdpo.opt)';
backup
filesperset 5
format 'df_%t_%s_%p'
(database);
}
Example 3:
This restore script allocates one parallel connection to the Tivoli Storage Manager server:
UNIX and Linux operating systems run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)';
restore database;
recover database;
alter database open;
}
Windows operating systems run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\oracle\scripts\tdpo.opt)';
restore database;
recover database;
alter database open;
}