Questions tagged [recovery]
Recovery is the rebuilding of a database or table space after a problem such as media or storage failure, power interruption, or application failure. If you have backed up your database, or individual table spaces, you can rebuild them should they become damaged or corrupted in some way.
432
questions
0
votes
0
answers
12
views
Table 'any table' doesn't exist in engine without moving anything
I have odd problem
today after I guess month or so I rebooted my server and now I get Table 'ANY TABLE' doesn't exist in engine in every innodb table that i want to open in phpmyadmin, MyISAM tables ...
0
votes
0
answers
14
views
Issues with v$archived_log - Oracle 19c
I have a standby database, on which I executed the command:
alter database recover managed standby database cancel
and it was executed successfully - The complication I am facing is:
When I execute:
...
0
votes
0
answers
53
views
Why does a DPM protection group configured for Sync work for some databases in simple recovery model but not others?
I'm using System Center Data Protection Manager 10.22.197.0 to back up SQL Server 2022 CU 10 on Windows Server 2022. DPM agent is also 10.22.197.0 on these SQL servers.
The SQL Server instance was ...
- 203
0
votes
1
answer
34
views
Reading data from data directory
We have a data directory in MySQL, we want to read data from it. We don't have any username or password and hence is there any method for how can we read the data stored in tables?
- 1
0
votes
0
answers
139
views
Recover a database accidentally deleted in phpmyadmin
I have accidentally deleted a dztabase from phpmyadmin plateforme that had no backup copy anywhere. Is there any solution to bring back this database ?
Mohamed Ait Ahmed
0
votes
1
answer
425
views
how can I view deleted records in an ibd file?
I'm in a situation with a wordpress site where a table wp_options keeps increasing in filesystem size really fast even though it only has 10000 records and we have to constantly optimize it to reduce ...
- 159
0
votes
0
answers
35
views
Cascading DR - Switchover issue in Oracle
I have 3 databases:A, B, C.
A is the primary database, and the log_arhive_dest_2 parameter is set accordingly:
log_arhive_dest_2=service='A' ASYNC valid_for=online_logfile,PRIMARY_ROLE
B is the ...
0
votes
1
answer
79
views
Restore SQL Server deleted files (.mdf, .ldf) (no backup)
In SQL Server Management Studio, I made database file attached with files (.mdf, .ldf).
I mistakenly deleted the database file and then mdf & ldf files also were deleted.
Unfortunately, I did not ...
0
votes
0
answers
38
views
Monitoring VLF File
Good Morning ,
Should we continue to monitor the number of VLF files for the SQL database log if we activate the
Accelerated Database Recovery option
0
votes
0
answers
118
views
Cann't start SQL Server after replacing master.mdf and mastlog.ldf
As you know, after installing SQL Server, there will be a master db with physical files master.mdf and mastlog.ldf.
I had an old version of MSSQL and there are some testing data in the master db. So I ...
- 101
0
votes
1
answer
219
views
What will happen when SQL Server log drive is full?
One of my production database log file drive filled up and I noticed below messages in SQL Server error log.
2022-02-13 03:16:24.500 spid72 Error: 9002, Severity: 17, State: 4.
2022-02-13 03:16:24....
- 1,169
0
votes
1
answer
312
views
How to reinstall MariaDB with an old data directory
I have the data directory of an older MariaDB installation, containing various databases. I don't have MariaDB installed, and I don't know which version of MariaDB was installed before, but it's ...
- 103
1
vote
2
answers
115
views
Is there a way to recreate lost SSTable index and other component files?
In Cassandra, in addition to the main sstable file, which ends with big-Data.db, there appear to be 7 other files, namely:
big-CompressionInfo.db
big-Digest.crc32
big-TOC.txt
big-Summary.db
big-...
- 11
0
votes
2
answers
176
views
Why does Mariadb fail to run, claiming the redo log is ancient if I have been running a newer version for a long time?
After a power outage, my Mariadb 10.5.10 server fails to start, saying this:
Jun 23 17:35:38 heater mysqld[1260999]: 2023-06-23 17:35:38 0 [Note] /usr/sbin/mysqld (mysqld 10.5.10-MariaDB) starting as ...
- 243
0
votes
0
answers
54
views
after restroring tablespace table or view not exists
I've Oracle CDB with PDB
In the PDB I created a tablespace
then I created a table over this tablespace
after that, I login into RMAN for the CDB database then I make a backup using
backup database ;
...
- 103
0
votes
0
answers
79
views
can I recovery specific table from .DBF files in oracle?
I have oracle 19c on windows10, I accidentally corrupted my System TABLESPACE file(Description). But my USERS tablespace Not damaged, Can I recovery my tables from this file on windows?
I haven't any ...
- 121
0
votes
1
answer
763
views
Mysqld won't start although lower_case_table_names is 0 and match the data dictionnary
I copied a mysql 8.0.26 database from a Linux server to my Windows box but mysqld won't start. Either it's this (with lower_case_table_names=1):
[ERROR] [MY-011087] [Server] Different ...
- 111
4
votes
1
answer
268
views
Is it safe to wipe out pgsql_tmp while the database is not running?
I've had a couple of instances recently of being forced to shut down my PostgreSQL 13.10 database uncleanly, and it taking a few hours to come back up afterwards.
In both cases, strace revealed that ...
- 143
0
votes
1
answer
196
views
How is the current sequence number in the control file used during recovery?
During recovery, how is the current sequence number used to determine the redo log files used to re-construct the database as well as the order in which to apply the changes recorded in them?
- 131
0
votes
1
answer
162
views
Restoring One Node From an Availability Group With Recovery Pending
I have an availability group that is no longer valid (one node is gone). If I connect directly to the remaining node, the databases are all shown as recovery pending. In the Availability Group, the AG ...
- 23
2
votes
2
answers
480
views
Recovery attempt for database corruption of catalog, corruption of internal tables
The issue was noticed when we ran dbbc checkdb.
EDIT: I looked up altering system tables and was successful in deleting
the internal table from sys.sysschobjs$ from its id.
https://www.sqlskills.com/...
0
votes
1
answer
56
views
Recovering RMAN Backup Into a New Database
I have a RMAN backup from an old oracle DB that I need to open on a new PC with a new instance of oracle installed.
I am unsure how to go about this as from what I can see in the documentation ...
William Glover
-1
votes
1
answer
368
views
General questions about write ahead logs and recovery
I've recently learned about write ahead logs and failure recovery in the context of key-value stores like Cassandra and have some follow-up questions:
Do WALs get persisted into smaller snapshots so ...
- 101
0
votes
1
answer
718
views
How to change from "Read-Only" mode to "Standby / Read-Only" mode?
I changed the database (foo) mode from "Standby / Read-Only" to Active by using the following statement:
restore database foo with recovery
After that, I changed the mode back to Active by ...
- 233
0
votes
2
answers
69
views
Why does (In Recovery) indication show up?
I just noticed that this database is currently in "In Recovery" mode.
How do I change back to normal mode (without (In Recovery))?
This is very active database, and I am trying to be very ...
- 233
0
votes
0
answers
132
views
PostgreSQL 9.6 recovery process stops earlier
Run into a strange issue using PostgreSQL 9.6 database on Windows OS
Using the recovery process with WAL files. Everything works fine - database starts up properly after recovery, no error message
BUT....
- 1
0
votes
2
answers
658
views
How to fix MySQL replication when duplicated key problem appears?
I have data logger software that writes data to master database. There are just 2 tables. If this database is locked or stopped for more than 1 minute I will loose some data that should be stored.
...
- 123
0
votes
0
answers
178
views
"Trying to read" "bytes at“ "outside the bounds of the file"
I have a slight issue.
Yesterday we had a power outage while we were importing data into the MySQL server inside a Docker container.
I'm trying to perform data recovery because this is what the log ...
1
vote
1
answer
651
views
Unable to Repair MariaDB Database Because It Is Read-Only
A recent incident corrupted my MariaDB database and I'm trying to repair it. I followed the instructions on the MariaDB site and successfully started my database at innodb_force_recovery=5. I have ...
- 13
0
votes
1
answer
28
views
extract a corrupt or delete table
What is the correct way and what is the steps to just recover and restore one big table from sqlserver 2019 backup in production server in an emergency situation?
0
votes
0
answers
559
views
Unable to Recover MySQL Database [Missing FILE_CHECKPOINT]
Using MariaDB 10.7.3 via Homebrew on MacOS Monterey 12.6.1
While trying to recover the database after a system crash, I am stuck with the following situation.
[Note] mysqld (server 10.7.3-MariaDB) ...
- 11
0
votes
1
answer
465
views
Recover deleted redo log files
I have the following problem: all redo log files from an Oracle 19C database have been deleted while the database was running. The database is running on a Linux server. When I try to connecting to ...
- 228
0
votes
1
answer
242
views
How does sql server know whether the dirty pages have been written to the data file?
I understand sql server writes the updates to the data pages (making them dirty) in memory and writes the tlog onto the disk before sending the commit notification to the user.
This question is to ask ...
- 3,593
2
votes
1
answer
739
views
Databases in Recovery Pending or Suspect Mode after SQL Server service restart
This issue applies for SQL Server 2019 Always on environment with the latest CU applied.
When SQL service needs a restart or the entire OS needs a reboot, some of the DBs come back in recovery pending/...
- 21
-1
votes
1
answer
136
views
How to restore a Oracle Database if i only have the datafiles?
My Oracle database Test server crashed, I have no rman backups but I still have the datafiles because they are on a SAN Storage, so if I have datafiles, how can I restore my Oracle database?
- 29
0
votes
1
answer
183
views
PostgreSQL stops continuous recovery without error
I have some Postgresql 10 instances running on Windows Server that are in continuous recovery mode. Once in a while they just stop recovering without giving any errors, like in this example log file (...
- 43
3
votes
4
answers
1k
views
How do I restore multiple transaction log backups after restoring a full backup SQLSERVER 2019
I am creating my DR strategy, and my full back-up recovers fine.
The full backups are taken with a modified version of the Ola Hallengren scripts.
The file timestamp of the full backup shows 07/26/...
- 37
1
vote
1
answer
2k
views
How to recover Postgresq data from $PGDATA/base files after system crash
I was working on my Ubuntu machine and left it on to grab food. Upon returning, I found it had shut itself down. It was not power failture because I have a home backup system and lights never go off ...
- 111
-2
votes
1
answer
49
views
How do admins manage RTO for sql server with large number of dbs? [closed]
Assuming I have 140 dbs and daily full and log backups.
The crash recovery process would be to restore each db one by one using the backups.
Therefore the RTO to get the system up ready will be high ...
- 3,593
-2
votes
1
answer
254
views
What is the general recommendation for sql server crash recovery from mdf/ldf vs backups for least data loss? [closed]
I'm learning steps to recover from sql server OS or OS disk crash. Assuming the OS or OS disk is corrupted and unrecoverable.
I know that a HA solution like fci or ag is better suited to prevent such ...
- 3,593
1
vote
0
answers
143
views
Data in one or more tables corrupt after recovering tables with alter table discard/import tablespace
I accidentally dropped my schema and had to recover all the tables per the steps in this post; Recover schema and the data in it from accidentally deleted schema
However, I notice that all of the ...
- 19
0
votes
1
answer
2k
views
Recover schema and the data in it from accidentally deleted schema
I did something careless. I deleted a schema. I have backups of the \mysql...\data\refadmin folder so I (hope) I have all the tables and data. That's backed up daily.
When I look at work bench, I ...
- 19
1
vote
0
answers
55
views
Database deployment rollback
I am looking for documentation on how this is done in MS SQL. I've done some searches and haven't found how to do this. There is documentation on how to set up HA and DR... But this specific process I ...
- 173
-1
votes
1
answer
82
views
Recreate broken Database
Here is the scenario - I have a Database that is suffering from Error 824, dbcc checkdb repair_allow_loss has not rectified it and unfortunately the Backups are also corrupt.
However, I am able to ...
- 193
2
votes
1
answer
726
views
Fix mysql replication crashed due to underlying storage corruption
we have critical database server running on two virtual machines. one virtual machine crashed due to underlying storage problem and we had to move it to different storage medium and recover the xfs ...
- 123
0
votes
1
answer
162
views
Postgres (9.6) hangs on start after storage upgrade
I have been running Postgres on a Linode with the data directory mapped to an external volume. Yesterday Linode prompted me to upgrade my storage to NVMe so I did. Unfortunately, following that, ...
- 101
3
votes
2
answers
1k
views
Estimating the best restore time from saved backups in SQL Server
I am looking for guidance and any advice on how to estimate the restore time for SQL Server databases once copied locally to the server.
This is just to layout a strategy what will happen if in future ...
- 784
2
votes
1
answer
3k
views
How to revert Postgres to some time ealier?
Consider this scenario, I made some update to a running Postgres database, and some bad things happen.
Now I want to rollback the database to 1 hour earlier, what's the process to achieve this?
I was ...
- 21
0
votes
0
answers
1k
views
Oracle Rman recovery to another database on different location
We had production user facing data loss from production Oracle database and only wanted to recover just one schema in the test database from a week ago. Backup team was able to retrieve the physical ...
Color Senz
0
votes
2
answers
400
views
Does only a full backup (and no tlog backup) of a db in full recovery model allow for point in time recovery?
I have a database in full recovery model.
Full backups are configured to run every Sunday and log backups run every day.
Log backup files are destroyed after 30 days. Full backups are destroyed after ...
- 3,593