03-20-2009 11:41 PM
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 !!!
04-14-2009 01:19 AM
RESTORE DATAFILE '/ora2/oradata/xxxdb2/undotbs01.dbf' from ‚bk_92_1_682007943‘; of course you should change the bk_92_1_682007943 to the name of the backup you wish to use.