on 06-05-2009 7:05 AM
Hi,
I was taking data base back up through DB13. I am taking the back up whole data base offline+redo log back up.Back up is stored in tapes and daily iam taking the redo log back up through DB13.
If may data base is crash how to restore database ,it can be done through BRTOOLS or DB13.
R egards,
Asif
Hi
That is the only thing you cannot do wrong.
You should test your backup strategy and test the restore procedures.
For your questions you have not done it so you MUST
1) Read the oracle documentation to know what to do (to actually know what restore is, what type of restores/recoveries are avaialble)
=> [Backup and Recovery Basics|http://www.oracle.com/pls/db102/to_toc?pathname=backup.102%2Fb14192%2Ftoc.htm&remark=portal+%28Books%29]
=> [Backup and Recovery Advanced User's Guide|http://www.oracle.com/pls/db102/to_toc?pathname=backup.102%2Fb14191%2Ftoc.htm&remark=portal+%28Books%29]
2) Read the SAP/BR* documentation. Restoring/recovering is not something to "click, click" without thinking
=> -> [Backup and Recovery|?rid=/webcontent/uuid/1cc71b42-0d01-0010-7f91-f352b58078cf] [original link is broken];
3) If you think a little you would realize that you cannot do a recovery from DB13
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please go thorugh below document for restore..it will be helpful for you..
http://help.sap.com/saphelp_nw04/helpdata/en/65/cade3bd0c8545ee10000000a114084/content.htm
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Before doing Restoration of Backup. First check Backup status by brtools. then analyze the error.
easiast way to restore backup is Restore offline backup by Brtools. or if u r confident in Oracle then do restoration by redolog file.
Brtools is the best utility to perform Restoration.
Thanks
Presu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Read Help before restoration.U can restore either brtools commnad prompt or db13. but
prefer through command prompt
http://help.sap.com/saphelp_nw04/helpdata/en/e6/f3d0ed99634078be2da254b97104d7/content.htm
read oracle backup/restore from oracle url.
Surendrajain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> HI,
> Read Help before restoration.U can restore either brtools commnad prompt or db13. but
> prefer through command prompt
> http://help.sap.com/saphelp_nw04/helpdata/en/e6/f3d0ed99634078be2da254b97104d7/content.htm
> read oracle backup/restore from oracle url.
> Surendrajain
I indicate that this is not possible. You indicate that is possible.
Could you indicate how to restore via DB13?
Except when you are restoring and recovering one file, usually (not always) your starting point for restoring is a stopped DB.
I'm not aware of any DB13 option to restore (and I do not think it would be logical to have one)
I'm not aware of any DB13 option to recover (and I do not think it would be logical to have one)
DB13 uses the "OP user" <sid>adm, for proper recovery it is necessary the ora<sid>
But, it looks like you know something I do not know, can you share that information with us.
Thanks
Asif,
You can restore the database by using BR*Tools.
Check below link for how to restore and recover your Oracle database with BR*Tools.
http://help.sap.com/saphelp_nw04/helpdata/en/93/4ffb72309fb04e80ebfefae1b7a96f/frameset.htm
Thanks
Sushil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.