Hi Ramu,

Is your database production or a test DB.

If you database is in no-archive mode,there is no way you can recover.Only option is restore from the previous day's backup.