on 05-20-2010 3:12 PM
Hi there,
I am doing backup and archive using these commands:
Oracle 10g, under windows 2003
ONLINE BACKUP: BRBACKUP -u system/************ -c force -t online -m all -p initbiq.sap
ONLINE ARCHIVE: BRARCHIVE u2013u system/************ -c u2013sd
How to Restore backup and archive
Please kindly advise
Regards,
Q1 - I have to take weekley OFFLINE backup what is the command line under windows (BACKUP in Network Drive "D")
A1 - BRTOOLS -u system/********** -p initMTDp -d disk -t offline_force -m all -c -k no -e 0 -l E
Here you can simplify your command as below:
brbackup -d disk -t offline_force -m full -u system/password
Q2 - How to restore OFFline backup
A2 - BRRESTORE -b xxxxxx..and (backup log file) -m all -p initMTD.sap
here also you can simplify as below:
brrestore -b filename -m full
Q3 - Database + controlfiles are saved in "F" drive, If I delete all database files+controlfiles+logs from "F" can I recover/restore from "D" drive ??? how
Yes this is a normal restoration process, Go through systemcopy guide or backup restore guides on SMP
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First need some clarification on below message from you
1) DATABASE BACKUP (OFFLINE)?
- Shutdown SAP Instance (SAP-MMC) + DB (user: sqlplus /as sysdba - shutdown abort;)
Why you are using shutdown abort ? Is there any reason/requirement behind this use instead of shutdown or shutdown immediate?
And on your latest query: You have to read system copy guide to find the reason why system is asking for controlfile.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for Reply!!!
let me summarize my questions:- and some asnswers, please tell me if i am wrong...
Q1 - I have to take weekley OFFLINE backup what is the command line under windows (BACKUP in Network Drive "D")
A1 - BRTOOLS -u system/********** -p initMTDp -d disk -t offline_force -m all -c -k no -e 0 -l E
Q2 - How to restore OFFline backup
A2 - BRRESTORE -b xxxxxx..and (backup log file) -m all -p initMTD.sap
Q3 - Database + controlfiles are saved in "F" drive, If I delete all database filescontrolfileslogs from "F" can I recover/restore from "D" drive ??? how
regards,
Hi
the logfile of the online backup should have two entries for
a "current log sequence" number. Record the last one (the one,
after the logswitch enforced at the end of the backup).
brrecover -seq {number recorded - 1}
This should do all the steps required to get you DB operational again.
This should contain the following steps (in case you like to do it manually)
restore of onlinebackup brrestore -m all|full ...
restore of required archive logs brrestore -a ....
recovery of archive logs sqlplus , mount, recover database ..., open resetlogs
recreation of required tempfiles create tempfile
May be you should do it with brrecover to see all the steps it takes to do it,
and then do the steps manually again, esp. the recover part just to see how
it works in sqlplus.
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
BACKUP & RESTORE REQUIREMENT
Coluld anyone provide these answer will be really appriciated
1) DATABASE BACKUP (OFFLINE)?
- Shutdown SAP Instance (SAP-MMC) + DB (user: sqlplus /as sysdba - shutdown abort;)
- Execute BRTOOLS option 4 - 1 - 5-user & pass 6-offline
- BRBACKUP -p initBIQ.sap -d disk -t offline -m all -k no -e 0 -l E
DONE
1) DATABASE RESTORE (OFFLINE)?
- Shutdown SAP + Database
- Select xxxxxx.and file from E:\oracle\BIQ\sapbackup
- BRRESTORE -b xxxxxx..and (backup log file) -m all -p initSID.sap
DONE
2) COMPLETE DATABASE BACKUP (ONLINE) ARCHIVED?
BRBACKUP -u system/*********** -c force -t online -m all -p initbiq.sap*
DONE
2) COMPLETE RESTORE DATABASE WITH ARCHIVED?
ANS:
3) DISASTER RECOVERY?
ANS:
Hi,
2) COMPLETE RESTORE DATABASE WITH ARCHIVED?
ANS:
brrestore -b <backup_log_filename> -m full
(For Complete Database restore)
brrestore -a <Seq.No.From>-<Seq.No.To>
(To Restore the archived redo log files with the log sequence numbers FROM and TO into the archiving directory.)
3) DISASTER RECOVERY ?
ANS: with BRTOOLS
[http://help.sap.com/saphelp_nw70/helpdata/en/72/96d34c435c3c4ca5894749ef1435ac/content.htm|http://help.sap.com/saphelp_nw70/helpdata/en/72/96d34c435c3c4ca5894749ef1435ac/content.htm]
Regards.
Rajesh Narkhede
>
> Hi,
>
>
2) COMPLETE RESTORE DATABASE WITH ARCHIVED?
> ANS:
> brrestore -b <backup_log_filename> -m full
> (For Complete Database restore)
>
> brrestore -a <Seq.No.From>-<Seq.No.To>
> (To Restore the archived redo log files with the log sequence numbers FROM and TO into the archiving directory.)
>
Hi,
and after this RESTORE part, you still need to RECOVER!
sqlplus / as sysdba
startup mount
recover database using backup controlfile until cancel
... providing logs up tp <Seq.No.To>
cancel
alter database open resetlogs
Volker
Hi again,
I am trying to now OFFLINE backup, stop sap and shutdown database.
BRTOOLS -u system/********** -p initBIQ.sap -d disk -t offline_force -m all -c -k no -e 0 -l E
Take offline backup in "D" drive and in C drive Oracle\database which is sapdata1, sapdata2 some files are deleteed... and try to restore back from "D" drive... using this command
BRRESTORE -b xxxxxx..and (backup log file) -m all -p initSID.sap
Why its asking me control files while restore... ???
I am looking for Offline backup with control files....
please help
Hi Angeline,
Could you please check the below link.
http://help.sap.com/saphelp_nw70/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/frameset.htm
Hope this helps you.
Thanks,
Nick S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check brrestore -h
Kind regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.