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 [ads...@vm.marist.edu] On Behalf Of Yudi Darmadi
[y...@npp-asia.com]
Sent: Tuesday, August 03, 2010 9:28 AM
To: ADSM-L@VM.MARIST.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.
