Data base crashed and how to restore it?

[Former Member]

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

[fidel_vales · Accepted solution]

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

[sunny_pahuja2]

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

[Former Member]

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

[Former Member]

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

[fidel_vales]

>

> 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

[Former Member]

Ys boss, Not read properly.

DB13 i never used either backup or restore .But restoration not possible throgh db13.

[Former Member]

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