Skip to Main Content

Database Software

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!

RMAN hangs during restore using TSM

o.popelyaevMar 7 2011 — edited Mar 7 2011
Hi all,

I need an advice. My database version is 11.2.0.2.0. TSM Client version is 5.5.2

I'm testing a restore using Tivoli Storage Manager. I'm trying to restore a specific tablespace using RMAN

RMAN> connect target /

connected to target database (not started)

RMAN> run {
2> startup mount;
3> allocate channel t1 device type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> restore tablespace 'ECRIXAR';
5> recover tablespace 'ECXIAR';
6> alter datbase open;
7> }

RMAN-06196: Oracle instance started
RMAN-06199: database mounted

Total System Global Area 2137886720 bytes

Fixed Size 2221336 bytes
Variable Size 1308625640 bytes
Database Buffers 822083584 bytes
Redo Buffers 4956160 bytes

RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: SID=63 device type=SBT_TAPE
RMAN-08526: channel t1: Data Protection for Oracle: version 5.5.2.0

RMAN-03090: Starting restore at 07-MAR-11

RMAN-08016: channel t1: starting datafile backup set restore
RMAN-08089: channel t1: specifying datafile(s) to restore from backup set
RMAN-08610: channel t1: restoring datafile 00014 to /dbspace/oradata/CMSDB/ecrixar01.dbf
RMAN-08003: channel t1: reading from backup piece CMSDB_25_20110304.bkp

And on this place RMAN just hangs and nothing happens further...
I tried to search some information and tried to write some trace files during restore like this...

oracle@hostname:/> rman target / trace /home/oracle/log/rman.trc debug

connected to target database (not started)

RMAN> run {
2> startup mount;
3> allocate channel t1 device type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' trace=2;
4> restore tablespace 'ECRIXAR';
5> recover tablespace 'ECXIAR';
6> alter datbase open;
7> }

But I cannot find any errors in trace files...

What else can i do to check what's happenig?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2011
Added on Mar 7 2011
2 comments
1,137 views