Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FOR EXPERTS!! How to restore controlfile from tape using TSM??

187628May 10 2007 — edited May 11 2007
Hi ,

I have a backup of my database (controlfiles, datafiles and archives) on tapes (TSM).

I'm doing some tests and i delete all my controlfiles.

Now i'm trying to restore the control file using the following:
#############
RMAN>set DBID=1489198124;
RMAN>run{
allocate channel t1 device type sbt_tape parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_capdb15p.opt)';
restore controlfile from autobackup;
}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/10/2007 16:25:30
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


#############

The autobackup is OFF now (i will put this ON later and become a production enviroment).

How can i get the controlfile backup from tape. I have this backup on tape made by RMAN using TIVOLI STORAGE MANAGER.


Tks,
Paulo.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2007
Added on May 10 2007
10 comments
844 views