I work more in SQL server end. Would like to know the difference of some backup strategies between Sql server and Oracle.
In sql server in our environment we do usually full backup at weekend, daily differentials and hourly transaction log backup. And I see in our oracle prod server, we do incremental level 0 backup on Sunday, then daily level1 incremental at week days. I understand level0 and level1 both set up for database and archive log backups, but that happens on only at 8pm daily, but I don’t see something equivalent as sql server hourly transaction log backup? Are those archive logs similiar like sql transaction log backup.? But how can it be ensured to hourly or even shorter time backed up?
Thanks