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
