TDP restore rman backup set to disk

[justmaxis]

I use tdp to backup my oracle database to tape

the backup like this
Starting backup at 2020/02/19
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00034 name=/oradata/topprd/undotbs03.dbf
input datafile file number=00002 name=/oradata/topprd/sysaux01.dbf
input datafile file number=00001 name=/oradata/topprd/system01.dbf
input datafile file number=00044 name=/oradata/topprd/undotbs03d.dbf
channel t1: starting piece 1 at 2020/02/19
channel t1: finished piece 1 at 2020/02/19
piece handle=prod_t1032746404_s25262_p1.db tag=TAG20200219T020004 comment=API Ve
rsion 2.0,MMS Version 6.3.0.0
channel t1: backup set complete, elapsed time: 00:11:55
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00009 name=/oradata/topprd/dsdata5.dbf
input datafile file number=00035 name=/oradata/topprd/dsdataD.dbf
input datafile file number=00017 name=/oradata/topprd/dsaws.dbf
input datafile file number=00028 name=/oradata/topprd/temptabs2.dbf
................


can I restore backup set "prod_t1032746404_s25262_p1.db" to my filesystem instead of oracle database?

 

[marclant]

You cannot restore data backed up with the Baclient that was backed up with the API(RMAN). So you would need to do the restore with RMAN. I don't know if RMAN has options to restore the DB to a file instead of inside the DB. If RMAN doesn't allow it, you could restore to a new DB and then do an RMAN backup to a file instead of to Spectrum Protect.

 

[pvarney]

You can restore TDP/API backed up objects via the backup/archive client...although I'm not sure how useful they would be. You just need to put curly brackets around the TDP API filespace name to do the restore. Here is an example for an Oracle TDP backup. Note that the SUBDIR=YES is important:

Protect> rest "{/ORA-19}/cp1kfqne_11673_1_1" /tmp/ -subdir=yes
Restore function invoked.

Restoring                 /ORA-19//cp1kfqne_11673_1_1 --> /tmp//cp1kfqne_11673_1_1 [Done]

Restore processing finished.

Total number of objects restored:             1
Total number of objects failed:               0
Total number of bytes transferred:         2.75 MB
Data transfer time:                        0.00 sec
Network data transfer rate:          530,321.61 KB/sec
Aggregate data transfer rate:            907.30 KB/sec
Elapsed processing time:               00:00:03