DBMS_BACKUP_RESTORE - Secrets of the Oracle Database - page 168

Disaster Recovery Case Study with Tivoli Data
Protection for Oracle
Tivoli Data Protection for ORACLE (TDPO) is software that conforms to Oracle Corporation's
SBT specification and enables integration of RMAN-based backup and recovery with Tivoli
Storage Manager (TSM) through a shared library (see http://www.tivoli.com ). It supports the
client platforms AIX, HP-UX, Solaris, Linux, and Windows.
From the perspective of the TSM server, an ORACLE instance is a backup client. Using the
TSM utility dsmadmc , it is possible to retrieve the names of backup pieces. If a control file were
available, these would match the backup piece names in V$BACKUP_PIECE.HANDLE . The TSM
server accepts SQL statements for retrieving files backed up by a client. The column NODE_NAME
stores the name of the TSM client used by the database server host. If you have given different
file name prefixes to control file, data file, and archived log backups, it will pay off now.
dsmadmc> SELECT * FROM backups WHERE node_name='DBSERVER'
ANR2963W This SQL query may produce a very large result table, or may
require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) y
NODE_NAME: DBSERVER
FILESPACE_NAME: /adsmorc
FILESPACE_ID: 1
STATE: ACTIVE_VERSION
TYPE: FILE
HL_NAME: //
LL_NAME: CF-DB-NINE-20071010-vsiu61og
OBJECT_ID: 201461790
BACKUP_DATE: 2007-10-10 14:43:27.000000
DEACTIVATE_DATE:
OWNER: oraoper
CLASS_NAME: DEFAULT
In the output from dsmadmc , you would look for the most recent control file backup or the
most recent backup piece that contains a control file. Control files are backed up whenever file 1,
the first file of tablespace SYSTEM, is backed up. The script dbms_backup_restore_cf_tdpo.sql ,
which is reproduced in the following code segment, may be used to restore a control file without
mounting a database and accessing a catalog or automatic control file backup. The LL_NAME
found in the TSM repository is used as the piece name in the call to DBMS_BACKUP_RESTORE .
variable type varchar2(10)
variable ident varchar2(10)
variable piece1 varchar2(513)
begin
:type:='SBT_TAPE';
:ident:='channel1';
:piece1:='CF-DB-NINE-20071010-vsiu61og';
end;