New answers tagged recovery
3
I'm switching a lot of databases to SIMPLE recovery mode from FULL recovery mode (T-Logs and point-in-time recovery is not necessary). Will the existing transaction logs be truncated (when checkpoints are created)?
In simple recovery model, the database engine will issue automatic checkpoints and its frequency is determined by the recovery interval ...
1
Many of the question s can not be answered by us. How long is a piece of string?
Some of the existing transaction logs are 50-100GBs, what is the best approach in
determining what I should shrink them down to for the purposes of moving forward.
As long as they need to be. I suggest NO shrinking. Trunacate logs, come back in a week and see how much ...
1
I have answered questions like this before
Dec 21, 2011 : Table compression in InnoDB?
Feb 03, 2012 : How to recover MySQL table structure from FRM files
Apr 23, 2012 : MySQL: how to restore table stored in a .frm and a .ibd file?
I have referred to a blog from Chris Calendar on connecting .ibd files back to the data dictionary.
If you do not have the ...
2
If your database is in full recovery mode you can also try third party tools such as ApexSQL Log or SQL Log Rescue.
These tools will attempt to read your transaction log and reconstruct statements.
You can also try reading transaction log manually using fn_dblog function but it’s going to be complex since this is not a well-documented function.
0
I just noticed that you mentioned cold backups in your question. There's usually only one reason to make cold database backups – your database is in NOARCHIVELOG mode. If your database is in NOARCHIVELOG mode, you cannot use TSPITR, because it requires the database to be in ARCHIVELOG mode to perform incomplete database recovery using archive logs.
All you ...
2
You probably tried to restore and then recover the database. When you recover the database all the files should be in sync before you can open the database for work. The error shown tells you that some of your data files are not in sync with the rest of the database.
What your really need to use to recover a tablespace or a set of tablespaces is ...
1
Can you define "corruption" and explain exactly what happened to the files?
If the data is really valuable (in which case you'll hopefully be investing a lot more in your backup and recovery to make sure that you can't lose your database and all your backups simultaneously), there are tools that may be able to salvage some of your data. Oracle Consulting ...
Top 50 recent answers are included
