on 11-09-2006 2:16 PM
Hi ,
Can anyone provide me the notes of how to take backup and than restore of oracle database..
Rohit
-> brbackup/brrestore
-> sapdba/brtols (depending on your rlz)
-> see pdf @ sapnet -> alias: systemmanagement -> oracle dba
-> check sapnote 43.399...
GreetZ, AH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rohit,
In backup 2 types cold and Hot.
Shutdown DB Copy all physical files and restote it to required location wich is a cold backup.
Hotbackup carefull DB shd be in archive mode.bring all tablespaces in backup mode and copy datafiles and archive log files.
This is at OS and DB level.
With SAP tools like BRTOOLS u can do these things.Execute DB13 u will see all options.If u have tape u need to config it .For details u can look in to Oracle Db guide in service.sap.com or help.sap.com
Regards
Vinod
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinod,
Thx for ur last reply..,
actually i need to take backup on another hard disk drive,not on any tape.
the server is R/3 and installed on win server2000.
and i am very new in this sap world..kindly tell me of which folders i need to take backup and than how to restore. because i m going to reinstall o/s on that particular system...and also am i able to install this same r/3 system on window server2003?after taking backup am i able to restore that on windows server 2003..
Regards,
Rohit goswami
Rohit,
For ur plan shutdown all sap and oracle services.
Backup complete folder by name oracle This folders will be in installed drive like .c:/oracle/oradata/<SID>/.....
I think u can easily find out instaleld dirs.Backup completely.folders names will be SAPDATA1,SAPDATA2 etc .backup complete folder.
reinstall NT (if necessary) and Oracle (if necessary)
reinstall SAP app server from the kernel CD .
oracle software will be in oracle_home sap in /usr/sap or mentioned path .
Check it.
reinstall sap db server with database exists options OR quit program when "Creating database" message appears, Out of these two choose one because you don't need to recreate the database.Down all services restrore database reboot machine.
Should work for u
I am asking for u take complete backup of sap and oracle folders because this will contain all profiles files and many files.
General backup complete sap and oracle located folders.
Restoring means copy and paste the backed up folders.Dont paste sap folder if u reinstalled sap kernel.
Regards
Vinod
thank you very much Vinod for your reply ...
......Dont paste sap folder if u reinstalled sap kernel??kindly tll me why i dont paste sap folder or what is the purpose of sap kernel. ......
it will definately work for me ...i'll follow your instructions and try to complete my task as quick as possible.
thanks again.
regards,
Rohit Goswami
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.