Dear all,

I tried to (test) restore SAP-Oracle database from an online backup, but it
failed,

Here's the command i executed:
brrestore -b bedupkyv.anf -d util_file -r
/oracle/SM1/102_64/dbs/initSM1.utl -m full

The restore completed with the following messages:
BR0280I BRRESTORE time stamp: 2010-08-02 10.57.49
#FILE..... /oracle/SM1/sapdata4/sr3usr_1/sr3usr.data1
#RESTORED. SM1___A0GCCQB7JD
BKI1215I: Average transmission rate was 308.459 GB/h (87.739 MB/sec).
BKI0020I: End of program at: Mon Aug  2 10:57:51 GMT+07:00 2010 .
BKI0021I: Elapsed time: 12 min 04 sec .
BKI0024I: Return code is: 0.

BR0280I BRRESTORE time stamp: 2010-08-02 10.57.51
BR0374I 21 of 21 files restored by backup utility
BR0230I Backup utility called successfully

BR0406I End of file restore: reduppie.rsb 2010-08-02 10.57.51
BR0280I BRRESTORE time stamp: 2010-08-02 10.57.51
BR0403I BRRESTORE completed successfully with warnings


Then, using SQLPLUS,  I startup the database (startup mount;), then open the
database (alter database open resetlogs;), but it said 1 datafile needs more
recovery:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/SM1/sapdata1/system_1/system.data1'

Please help, what should i do next? Thanks,


Regards,

Yudi