Usually recovery process quite complicated and depend on many things:
- a few copies of control files should be defined on different disks (see in 
init file something similar to  control_files=("/db/opcctl1","/db/opcctl2"). If 
you still have at least one control file it is possible to copy it to lost 
locations according to COLTROL_FILLES;
- if all copies of control files are lost, try to check if you have included 
control files into backups (check RMAN scripts for "backup .........database 
include current controlfile;"). In this case it is possible to restore control 
files from TSM by  using restore controlfile to '<any location>';
replicate controlfile from '<any location>';
- a few copies of redo log files should be defined on different disks. If you 
still have at least one redo log file in each group available, you are safe 
(Oracle will take care about lost redo log files by using available files and 
after restoring lost redo logs can be redefined). If you have lost all redo 
logs at least in one group, you have to use incomplete recovery;
- database has to be in ARCHIVELOG mode and all archived redo logs are kept in 
file system. If this file system is available, the latest archived redo logs 
(not backed up to TSM yet) can be used from that file system during recovery;
- archived redo logs have to be included into backups (check used RMAN scripts 
for command like "backup .........(archivelog from logseq $START_SEQUENCE)".
If you have archived redo log backups, they will be requested during recovery 
automatically;
SUMMARY:
1) If control files, redo log files, archived redo log file system and archived 
redo log backups are available, just use (no data loss):
restore database;
recover database;
2) if only control files have been lost, first restore control file and use (no 
data loss):
restore database;
recover database using backup control file;
3) if any redo log group has been lost use (data loss started from the last 
applied archived redo log):
restore database;
recover database;
...
alter database open resetlogs;

General comments:
- you must be Oracle DBA;
- you mast be familiar with RMAN;
- you must be familiar with TDPO;
- etc.

Good luck!


Grigori G. Solonovitch


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Huebner,Andy,FORT WORTH,IT
Sent: Tuesday, October 11, 2011 7:02 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Oracle TDP restore problem

We had some Oracle files deleted and we cannot restore the DB because we are 
missing the control file and catalog.  We cannot figure out how to tell RMAN to 
restore the DB and logs without them.

Is there a way?
This is a TDPO backup without a working TSM agent backup.  The node is running 
AIX.


Andy Huebner


This e-mail (including any attachments) is confidential and may be legally 
privileged. If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.

Thank you.


Please consider the environment before printing this Email.

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.