4 ms·
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
by aidenn0 5y ago
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.
- professoretc 5y agoI'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.
- aidenn0 5y agoI 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