Hello Yudi,
Your request dos not contain complete informion and I do not know waht is 
BRRESTORE, but as Oracle DBA I can give you some advices:
1) if you are using Oracle offline backups - just start database after 
restoring all files ("alter database open resetlogs" is not required);
2) if you are using snapshot online backups like VSS -   after restoring all 
files (including active redo logs) you need at least "startup mount", "recover 
database" and "alter database open";
3) if you are using legacy online backups like RMAN + TDP for Oracle + TSM - 
you need:
    - restore control files, if they are lost;
    - restore datafiles;
    - restore archive redo logs for period from last backup till required 
recovery time;
    - recover database by "recover database using backup controlfile" for 
complete recovery, if you have good copies of active redo logs;
    - OR recover database by "recover database until time 'XXXXXXXXXXXXXX' 
using backup controlfile" and "alter database open resetlogs" for incomplete 
recovery, if you have lost active redo logs.
Regards,
Grigori

________________________________________
From: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] On Behalf Of Yudi 
Darmadi [yudi AT NPP-ASIA DOT COM]
Sent: Tuesday, August 03, 2010 9:28 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP for SAP - Restore from online backup

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

Please consider the environment before printing this Email.

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.