Skip to Content
0
Former Member
Jun 05, 2009 at 09:52 AM

Database restore

69 Views

Hi ,

I would like to know if the following general method to restore a database from a backup medium is correct enough to startup the database successfully.

Scenerio of datafile/database corruption

1)Remove all files from the related database folders (Eg sapdataX, origlogX etc)

2)Restore last night online backup

3)Restore the necessary archivelog to oraarch

4)Check all permission

5)STARTUP NOMOUNT

6)recover database until cancel

7)alter database open;

Regards

Lauran