Skip to main content

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
16 views

Postgres Barman archive command failed

For production environment, I am using this archive command in my postgresql server. barman-wal-archive backup pg /var/lib/edb-pge/15/data/pg_wal/%f Now when I manually run this command on my ...
Lai Ba's user avatar
  • 1
0 votes
0 answers
18 views

Restoring of OLTP In-Memory DBs in SQL 2022 on Ubuntu really slow

We've started using OLTP In-Memory tables (schema durability only) in a small DB (DB properties show 137 MB of Row data, 1GB of In-Memory data, BAK size of 152MB) and the recovery times (either ...
Hugh Clark's user avatar
0 votes
1 answer
56 views

Restore deleted filegroup from detached database

Unfortunately, one of the file groups of my database that was detached has been deleted and the database cannot be attached anymore. Do you have a solution to attach? With recovery software, the file ...
user avatar
0 votes
1 answer
48 views

Oracle database backup recovery

Just startet to study Oracle, i need to restore database backup. Log file said it was made in Oracle Database 10g Enterprise. I have Oracle XE 18, is it even possible to make it for XE version usind ...
Артем Павлов's user avatar
3 votes
1 answer
179 views

Restoring a broken SQL Server database - combining old DB+TL backup with new

I have run into a SUSPECT database (SQL Server) for the first time. It is apparently due to disk failing. I have recent full DB and transaction log copies but additional data was entered since then. I ...
user avatar
0 votes
0 answers
29 views

mysql data recovery from Time Machine

Because of some unfortunate events I had to remove mysql from my Mac Ventura completely. There was only one database I was using. Let's call it my_db. Time Machine has backed up this database with all ...
gbohus's user avatar
  • 1
3 votes
0 answers
72 views

Are Innodb redo logs written atomically?

When flushing dirty pages from buffer pool to disk pages, it uses double write buffering to avoid half written pages. But redo logs do not have such mechanism. So, how does it prevent redo logs from ...
William's user avatar
  • 135
1 vote
1 answer
44 views

Why does PostgreSQL accept connections during recovery?

Why does PostgreSQL accept connections during recovery? I wanted to use ps_isready to determine if my database is done recovering from a backup and ready to accept connections. But it says the ...
toydarian's user avatar
  • 213
0 votes
1 answer
319 views

Table 'any table' doesn't exist in engine without moving anything

Today after I guess a 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. My ISAM tables are fine and ...
user1772630's user avatar
0 votes
0 answers
50 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: ...
datascinalyst's user avatar
0 votes
0 answers
71 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
37 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
459 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
450 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
  • 161
0 votes
0 answers
44 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
101 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
125 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
326 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
504 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
154 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
244 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
1 answer
1k 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 ...
Cybercartel's user avatar
4 votes
1 answer
408 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
237 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
212 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
603 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
71 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
442 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
1k 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
  • 233
0 votes
2 answers
80 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
  • 233
0 votes
0 answers
136 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
813 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
208 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
977 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
29 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
783 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
533 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
291 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,476
2 votes
1 answer
1k 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
160 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
253 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
2k 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
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 ...
TheRealChx101's user avatar
-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 ...
variable's user avatar
  • 3,476
-2 votes
1 answer
270 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,476
1 vote
0 answers
145 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
58 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
89 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

1
2 3 4 5
9