you perform incomplete recovery with archived logs and recover until last redo log if you can
What you say about Oracle is when your database is in noarchive log mode