News for hackers. Stuff that matters.
Re:Correct Backups Require Filesystem Snapshots by aidenn0 on Monday May 16, 2022 @04:03PM (#31402556)
It's been a while, but with e.g. Oracle 10, it was specifically stated in the docs that backing up the data-file(s), followed by the archive-logs, you would end up with a recoverable backup. I'm not sure if other databases are designed that way.
Re:Correct Backups Require Filesystem Snapshots by professoretc on Monday May 16, 2022 @07:07PM (#31404129)
I've done it with SQL Server, but it wasn't automatic. I had to manually repair or remove the DB pages that were in use when the backup was made.
Re:Correct Backups Require Filesystem Snapshots by aidenn0 on Monday May 16, 2022 @09:40PM (#31405096)
I think with Oracle you needed to replay the archive log; not sure if that was via rman or just a mount option.

Either way it was identical to crash recovery