what i am doing wrong? i know other better options for rman restore/recovery but just want to test these too
SQL> declare
2 devtype varchar2(256);
3 done boolean;
4 begin
5 devtype:=dbms_backup_restore.deviceallocate(type=>'sbt',params=>'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bi
n64/tdpo.opt)', ident=>'t1';
6 dbms_backup_restore.restoresetdatafile;
dbms_backup_restore.restorecontrolfileto('/tmp/test/controlfile_name.ctl');
7 8 dbms_backup_restore.restorebackuppiece('c-1031094670-20100618-01', DONE=>done);
9 dbms_backup_restore.devicedeallocate('t1');
10 end;
11 /
devtype:=dbms_backup_restore.deviceallocate(type=>'sbt',params=>'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/t
dpo.opt)', ident=>'t1';
*
ERROR at line 5:
ORA-06550: line 5, column 143:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol ")" was substituted for ";" to continue.