Hi All
I have a problem, trying to restore a datafile, I'd like to take from a specific time, this is the bplist out:
-bash-3.00$ /usr/openv/netbackup/bin/bplist -t 4 -l -R /
-rw-rw---- oracle oinstall 7340032 Mar 20 14:45 /c-1881859899-20090320-05
-rw-rw---- oracle oinstall 7340032 Mar 20 14:44 /cntrl_96_1_682008273
-rw-rw---- oracle oinstall 7340032 Mar 20 14:43 /c-1881859899-20090320-04
-rw-rw---- oracle oinstall 1310720 Mar 20 14:42 /al_94_1_682008158
-rw-rw---- oracle oinstall 7340032 Mar 20 14:41 /c-1881859899-20090320-03
-rw-rw---- oracle oinstall 774373376 Mar 20 14:39 /bk_92_1_682007943
-rw-rw---- oracle oinstall 7340032 Mar 20 14:36 /c-1881859899-20090320-02
-rw-rw---- oracle oinstall 7340032 Mar 20 14:35 /cntrl_90_1_682007733
-rw-rw---- oracle oinstall 7340032 Mar 20 14:34 /c-1881859899-20090320-01
-rw-rw---- oracle oinstall 1835008 Mar 20 14:34 /al_88_1_682007640
-rw-rw---- oracle oinstall 7340032 Mar 20 14:33 /c-1881859899-20090320-00
-rw-rw---- oracle oinstall 774373376 Mar 20 14:30 /bk_86_1_682007423
-rw-rw---- oracle oinstall 7340032 Mar 20 11:26 /cntrl_250_1_681996383
-rw-rw---- oracle oinstall 786432 Mar 20 11:25 /al_249_1_681996325
-rw-rw---- oracle oinstall 7340032 Mar 20 11:24 /bk_248_1_681996267
-rw-rw---- oracle oinstall 849870848 Mar 20 11:21 /bk_247_1_681996082
-rw-rw---- oracle oinstall 7340032 Mar 20 11:13 /ctrl_u7mkacrb3_s246_p1_t681995619
-rw-rw---- oracle oinstall 1048576 Mar 20 11:12 /arch_u7lkacr90_s245_p1_t681995552
-rw-rw---- oracle oinstall 7340032 Mar 20 11:11 /bk_u7kkacr6s_s244_p1_t681995484
-rw-rw---- oracle oinstall 849870848 Mar 20 11:07 /bk_u7jkacqvh_s243_p1_t681995249
-rw-rw---- oracle oinstall 7340032 Mar 20 11:03 /bk_242_1_681995012
-rw-rw---- oracle oinstall 849870848 Mar 20 11:00 /bk_241_1_681994826
-rw-rw---- oracle oinstall 7340032 Mar 17 01:00 /cntrl_240_1_681699627
-rw-rw---- oracle oinstall 19136512 Mar 17 00:59 /al_239_1_681699570
-rw-rw---- oracle oinstall 7340032 Mar 17 00:58 /bk_238_1_681699512
How can I give the correct parameter to RMAN ? and not take it from the last one?
Actully I'm trying with "until_time" as below, but I need from backupset.
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=xxxx';
RESTORE DATAFILE '/ora2/oradata/xxxdb2/undotbs01.dbf'UNTIL TIME "TO_DATE('03-17-2009:13:38:19', 'MM-DD-YYYY:HH24:MI:SS')";
RECOVER DATAFILE '/ora2/oradata/xxxdb2/undotbs01.dbf';
RELEASE CHANNEL ch00;
}
Any help will be appreciated !!!
