In a previous article we analyzed how to flashback a database to a guarantee restore point in an Oracle database. In this article we will see how to go back in time through flashback database technology without using a restore point... read more
How do we backup an Oracle Database that is in archive-log mode
In this article we will analyze what it takes to take an online backup of an Oracle database that is in archived-log mode. In order to take a backup in addition to the datafiles, we should also take a backup of the controlfile,... read more
How can we see historical image of a table in Oracle Database with Flashback Query
Many times we will need to see what entries the table had some time ago. We may still have to restore it from a wrong update or even drop. In Oracle this is easily done using flashback query… read more
How do we return an Oracle database to the previous state of a restore point (Flashback Database to guaranteed restore point)
In the article we will analyze how we can use the flashback database function in a guaranteed restore point in an Oracle database. The flashback database belongs to the category of data protection and provides the possibility to freeze the… read more
How do we restore a specific page only in SQL Server
In the article we will analyze what we can do in the case of page corruption in SQL Server. It is possible to restore only the specific page and avoid restoring the entire database through the backups we have (just... read more