表的许多分区被意外drop用rman不完全恢复

sqlplus / as sysdba
startup nomount;

CREATE CONTROLFILE REUSE DATABASE "XXX" RESETLOGS ARCHIVELOG
MAXLOGFILES 40
MAXLOGMEMBERS 3
MAXDATAFILES 400
MAXINSTANCES 2
MAXLOGHISTORY 454
LOGFILE
GROUP 1 (
'/oracle/oradata/xxx/rdb_redo01a'
) SIZE 10M,
GROUP 2 (
'/oracle/oradata/xxx/rdb_redo02a'
) SIZE 10M
DATAFILE 
'/oracle/oradata/xxx/system01.dbf',
'/oracle/oradata/xxx/undo01.dbf',
'/oracle/oradata/xxx/sysaux01.dbf',
'/oracle/oradata/xxx/pay_ts01.dbf'
CHARACTER SET ZHS16GBK
;

recover database until cancel using backup controlfile;
...

alter database open resetlogs;

create table xxx as select xxx from xxx where xxx;
exp,ftp .dmp,imp

restore database;
recover database using backup controlfile until cancel;
alter database open resetlogs;
...

END