I was trying to load database from an RMAN backup (duplicate database until …), and the restore process died after some time, and gave me the following error messages (I have tried it several times, with different backups, these repeated randomly):
ORA-19502: write error on file “/path/to/datafile.dbf”, blockno 1669073 (blocksize=8192)
ORA-27072: File I/O error
Linux Error: 2: No [...]
If you have accidentaly locked out yourself, or just forgot your password for the admin (root) user of the MySQL, here is a quick-and-dirty solution.
First you have to shut down the MySQL server, next you need to start it in safe mode with no priviliges table loaded, update the password to a new one, and [...]
Today I have faced with a crashed SQLite database. Actually, I am not totally sure it was crashed, but the sqlite process had not shut down properly, and (after this) to select anything from it has taken more than an hour, anyway it was damn slow, and has eaten a lot of CPU time, and [...]
