Moneycontrol Brokerage Recos

Tuesday, September 20, 2011

How to recover if we delete a data file at OS level no backup for that?


Bring the database to the mount state

SQL>alter database create datafile ;

SQL>recover datafile ;

SQL>alter database open;

2 comments:

  1. Sir if we dont have backup then how we can recover the file?

    ReplyDelete
    Replies
    1. This case is only applies if all archives logs are available since the data file was created

      Delete