As we have seen in previous articles, in older versions of PostgreSQL before version 17 there was no possibility for block level backup, as a result we could not do differential and incremental backups and we would have to take them every day... read more
How to Point in Time Restore a PostgreSQL database without using 3rd party tools
In a previous article we saw how to take full and log (WAL) backups without using 3rd party tools. In this article we will now see how we can restore the database with Point in Time Restore (PITR). The… read more
How to Backup a PostgreSQL Database Without Using 3rd Party Tools
In this article we will see step by step how to do a backup without using 3rd party tools full backup and log backup so that we can do PITR (Point in Time Recovery) if needed in the future. Finally we will see… read more
How to restore an Oracle Database that is in archive-log mode with RMAN Restore
In a previous article we saw how to backup an Oracle database with RMAN, in this article we will see a simple case of recovering data with RMAN Restore. There are many subcases with different steps each… read more
How to roll back an Oracle Database using a restore point in a Data Guard environment
In a previous article we saw how we can roll back an Oracle Database through flashback database to guaranteed restore point. In this article we will see what procedure we follow in case we have primary and standby databases… read more
How to Flashback an Oracle Database (Flashback Database)
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
