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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
42 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 ...
M Herbener's user avatar
0 votes
1 answer
31 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?
0xD4rky's user avatar
0 votes
0 answers
84 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 ?
user avatar
0 votes
1 answer
419 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 ...
gabtzi's user avatar
  • 149
0 votes
0 answers
21 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 ...
datascinalyst's user avatar
0 votes
1 answer
69 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 ...
HYEONKYU LEE's user avatar
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
Abdallah Mehdoini's user avatar
0 votes
0 answers
106 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 ...
Zhang's user avatar
  • 101
0 votes
1 answer
153 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....
Fajela Tajkiya's user avatar
0 votes
1 answer
237 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 ...
Svish's user avatar
  • 103
1 vote
2 answers
105 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-...
ranban282's user avatar
0 votes
2 answers
153 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 ...
Johannes Ernst's user avatar
0 votes
0 answers
52 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 ; ...
Tariq Hajeer's user avatar
0 votes
0 answers
70 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 ...
henrry's user avatar
  • 121
0 votes
1 answer
572 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 ...
Micromega's user avatar
  • 111
3 votes
1 answer
197 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 ...
Ben Millwood's user avatar
0 votes
1 answer
173 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?
Mehdi Charife's user avatar
0 votes
1 answer
138 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 ...
Soma Holiday's user avatar
2 votes
2 answers
380 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/...
Rajin Tamrakar's user avatar
0 votes
1 answer
53 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 ...
user avatar
-1 votes
1 answer
327 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 ...
ejtt's user avatar
  • 101
0 votes
1 answer
547 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 ...
Java's user avatar
  • 223
0 votes
2 answers
64 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 ...
Java's user avatar
  • 223
0 votes
0 answers
121 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....
Arpad's user avatar
  • 1
0 votes
2 answers
561 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. ...
Kamil's user avatar
  • 123
0 votes
0 answers
167 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 ...
Mark Esterhuizen's user avatar
1 vote
1 answer
557 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 ...
Peter Li's user avatar
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?
user1028832's user avatar
0 votes
0 answers
531 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) ...
Rawkon's user avatar
  • 11
0 votes
1 answer
433 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 ...
József Kökény's user avatar
0 votes
1 answer
229 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 ...
variable's user avatar
  • 3,541
2 votes
1 answer
648 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/...
JOHNMARSTON's user avatar
-1 votes
1 answer
123 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?
arodp's user avatar
  • 29
0 votes
1 answer
167 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 (...
Norba's user avatar
  • 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/...
Thomas's user avatar
  • 37
1 vote
1 answer
1k 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 ...
TheRealChx101's user avatar
-2 votes
1 answer
48 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 ...
variable's user avatar
  • 3,541
-2 votes
1 answer
244 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 ...
variable's user avatar
  • 3,541
1 vote
0 answers
137 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 ...
Citizen1138x's user avatar
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 ...
Citizen1138x's user avatar
1 vote
0 answers
54 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 ...
greektreat's user avatar
-1 votes
1 answer
78 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 ...
TheDemonLord's user avatar
2 votes
1 answer
685 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 ...
rafalefighter's user avatar
0 votes
1 answer
159 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, ...
Cory's user avatar
  • 101
3 votes
2 answers
994 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 ...
Newbie-DBA's user avatar
2 votes
1 answer
2k 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 ...
John Doe's user avatar
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 ...
user avatar
0 votes
2 answers
370 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 ...
variable's user avatar
  • 3,541
0 votes
1 answer
590 views

PITR with barman fails - is my understanding even accurate?

I mange to take backups and recover them to my postgres-server. Now I want to see what PITR is able to do with these steps create a backup (20220111T062908) wait a minute create a new database (at 06:...
vrms's user avatar
  • 175
0 votes
1 answer
381 views

Should databases be dumped to SQL format or custom archive?

I am wondering, what is the industry standard regarding dump formats, when making and storing the database dumps? Is it better to dump it to a custom-format compressed and unreadable archive, or just ...
weno's user avatar
  • 115

1
2 3 4 5
9