Questions tagged [recovery]

Reconstructing a database.

80 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
1answer
511 views

Database Stuck 'In Recovery' with command XTP_DB_RECOVERY

We recently converted a table to memory optimized data. Our backups have all ballooned (3x300GB files to 3x600GB files for Full, 3x50GB to 3x250GB for Diffs), and startup has been getting ...
6
votes
1answer
787 views

RDS MYSQL instance rebooted and won't load INNODB table

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
4
votes
1answer
5k views

Restore mongoDB by --repair and WiredTiger

We accidentally deleted the directory rm -rf /data/db which was our MongoDB path, and thanks to extundelete, we recovered it and got the directory /data/db. Here are our files in the directory, and ...
3
votes
0answers
54 views

Why recovery took longer time even though analysis phase is not that long

We are doing Volume Snapshot restoration from Production to Warm Stand-By Server on daily basis. Daily it takes around 10 mins for DB to recover. But yesterday it took 44 mins to recover. I am ...
3
votes
1answer
1k views

Cannot restore MySQL database from .frm and .ibd files

I have a bigger database with around 1000 tables. Unfortunately after a OS X update everything vanished, but I was able to recover all the file that now consists of only .frm and libd files. Following ...
3
votes
1answer
130 views

Table was deleted during ALTER, how to recover?

I tried to ALTER a table to add a FOREIGN KEY as: ALTER TABLE artists ADD FOREIGN KEY(country_id) REFERENCES countries(country_id) ON DELETE CASCADE; and I received an error of ERROR 2013 (HY000): ...
3
votes
0answers
1k views

InnoDB crashes on trx rollback

I have InnoDB assertion failure during the trx rollback 160316 10:47:31 InnoDB: Rolling back trx with id 5ADBE4173, 1 rows to undo 160316 10:47:31 InnoDB: Assertion failure in thread ...
3
votes
0answers
376 views

Recovery from Live to a new Slave Server - PostgreSQL - ERROR

I've started a new SLAVE PostgreSQL server set up. master: 192.168.100.1 slave1: 192.168.100.2 slave2(NEW SLAVE) 192.168.100.3 * NOTE: I run the pg_basebackup from another STANDBY SERVER. Not from ...
3
votes
1answer
5k views

How to restore database from /var/lib/mysql

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
3
votes
0answers
1k views

“InnoDB: error clustered record for sec rec not found” MySQL 5.5.28

We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD RAID 10 - running Ubuntu 12.04 with MySQL 5.5.28. During high load, randomly we got the below error. MySQLcheck, innochecksum shows no ...
2
votes
0answers
442 views

Database stuck in recovery pending but can't set to ONLINE or EMERGENCY

We have a database server who's data drive filled up see error log: Error: 17053, Severity: 16, State: 1. D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MyDb_log.ldf: Operating ...
2
votes
0answers
1k views

How to get records from corrupted ibd file

Ok, in the last two days I thoroughly searched through the internet, and found multiple propositions on how to handle this, but nothing worked so far. Here is what the problem is and what I tried so ...
2
votes
0answers
386 views

mysql innodb - strange data loss

I am running a mysql database on linux with several InnoDB tables. At some point, the ibdata1 file got quite big and I wanted to delete it. So I made a dump, deleted the file and restarted the server. ...
2
votes
0answers
1k views

Data Corruption - ERROR: could not open segment 2 of relation

I am getting the below error for a production database. I am new to PostgreSQL databases. I need help to get this fixed. 2015-10-28 10:25:04,154 [monitor-thread-pool1-thread-6] ERROR [org.hibernate....
2
votes
1answer
84 views

Recover mysql using data folder

One of our MySQL servers died but somehow we were able to recover all the files from it. This server was a slave at one time however we stopped it being a slave so we could use it for housekeeping ...
2
votes
0answers
107 views

Postgres Replication From Different Masters?

I'm getting a Postgres 9.3.3 install sorted out. My application is Drupal (so read/write), but low-traffic, so all application traffic is sent to the primary master. I have two sites (main and ...
2
votes
0answers
2k views

Analyzing MySQL crash due to corrupt InnoDB page. Failed page checksum

Lately we have been pestered by infrequent sporadic database crashes on one of our MySQL instances. Each time it is due to a failed page checksum. It happens on a specific database but spans multiple ...
2
votes
0answers
306 views

What is an incremental checkpoint (in the context of indirect checkpoints)?

I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this: And the details of the selected event are: The description ...
1
vote
0answers
61 views

Database in suspect mode

I'm experiencing a tough issue for me. When I was updating some columns into the database I have previously installed, the main memory corruption led the database jump into the suspect mode. I follow ...
1
vote
0answers
129 views

MySQL Won't Start - InnoDB Table Corruption

I've found lots of articles and questions related to this issue, but none that seem to apply or work in my situation. MySQL will not start after I had to do a fsck repair on my server's hard drive (...
1
vote
0answers
55 views

Unable to recover MySQL 5.6 (InnoDB) database

I've tried multiple different suggestions from other questions on here, with no luck... This is a MySQL database running version 5.6.41, using the InnoDB engine, and the instance is running out of a ...
1
vote
0answers
173 views

MySQL: why undo log is required in the processes of database recovery?

Let's imagine that an incident happens when you updates. start transaction; update users set gender = 1 where id = 3; Undo log space is allocated. Previous values are copied to undo log Record of ...
1
vote
2answers
1k views

Repair/Recover data from MySQL database

I have a big problem with a MySQL database stored on my raspberry (InnoDB engine). I'm not very expert in this field but I'll try to explain to you the problem. MySQL crash everytime that I try to ...
1
vote
0answers
138 views

Unable to drop table/database when using innodb_force_recovery = 3

I'm attempting to follow several guides to recover a corrupted database, by setting innodb_force_recovery to 3, dumping the database, dropping the database, and then importing it back in. I'm able to ...
1
vote
0answers
128 views

I am using Db2 Recovery Expert and having error with adding Managed Databases

I have Db2 11.1 installed in my windows machine and created a Linux 32 bit in my virtualbox (unfortunately my intel doesn't allow me to change the virtualization method..anyway). I installed ...
1
vote
0answers
727 views

MySQL MyISAM corrupted table repair failure

My MyISAM tables got corrupted(I guess due to fs corruption) filesystem_cstor.MDS_DATA warning : Table is marked as crashed warning : Table is marked as crashed error : Key in wrong position at ...
1
vote
2answers
4k views

My mysql database crashed, how to recover

I have a mysqldump of all databases, including mysql. I'm using mysql 5.6 on Windows 2008 R2. How can I restore my backup ? The problem is that I cannot start the server when the database mysql is ...
1
vote
1answer
31 views

Lost entire MySQL Server. Unsure if “master-slave” or “master-master” - How to tell?

Yup - my db02 server lost a disk, and the array itself is corrupt (RAID5, yet corrupt data.) I was able to get the OS back online, but the corruption is severe. I have zero documentation about the ...
1
vote
0answers
1k views

SQL Server: DB STARTUP blocking processes

I am trying to run DBCC CHECKTABLE (or CHECKDB, same result), but I keep getting this error: Check statement aborted. Database contains deferred transactions. I've made some researches and found ...
1
vote
0answers
754 views

Will I have to restore controlfile in RMAN level 1 backupset before recover database?

For example, I have a level 0 and level 1 RMAN backupset files like inr00_0413_* inr01_0413_1_* Is it necessary to do this when recover from RMAN level 1 backup: restore controlfile from ...
1
vote
0answers
422 views

Three Vital Postgres Columns Corrupted

I run a small website which uses a Postgres database. There are regular back ups based on the amount of traffic we have every few days but there was a recent surge of activity just before a power cut ...
1
vote
0answers
36 views

How “relatively safe” is the data which was salvaged from corrupted MySQL InnoDB database?

I encountered the corruption like the following. 150208 14:27:52 InnoDB: Error: page 443375 log sequence number 8941 870477908 InnoDB: is in the future! Current system log sequence number 5968 ...
1
vote
0answers
228 views

Corrupted Filesystem: Possible to restore databases from the contents of /var/lib/mysql?

Using CentOS 6.4 x64. Not sure what happened but somehow my VPS filesystem got corrupted and it is now in a permanent read-only state. I've been working with my hosting provider's sys. admin. but ...
1
vote
0answers
895 views

InnoDB: error: space object of table

131212 10:35:18 InnoDB: error: space object of table 'main/wp_m_membership_levels', InnoDB: space id 119 did not exist in memory. Retrying an open. 131212 10:35:18 InnoDB: error: space object of ...
1
vote
0answers
3k views

MySQL installation broken after Windows crash - how to repair MySQL and recover data?

recently my PC powered off abruptly for no apparent reason, leaving my Windows 7 installation severly damaged. I can still log onto the machine, but tons of Windows system files have been corrupted ...
1
vote
1answer
121 views

How to recreate Oracle db from .ora and .dbf?

I have a number of files left from a previous Oracle db and I would like to create a new one from the files. The files include: init_locdb.ora 16 .dbf files spfilelocdb.ora log files .ctl Could you ...
1
vote
1answer
469 views

Oracle PLSQL code recovery

I cannot connect to my database as admin, even using connect descriptor neither via RMAN. I am getting TNS-12514 error. I consider to install new instance. Questions: 1) Can I restore/recover PLSQL ...
0
votes
0answers
27 views

PITR Restore on Postgresql Windows

I have Postgresql 11 running on Windows server and master/slave replication working perfectly. I have enable the wal_archiving and also i have enabled automatic backups using pg_dump I need to ask if ...
0
votes
0answers
12 views

Point-In-time-recovery in Greenplum Database

We have recently setup greenplum. Now the major concern is to setup strategy for PITR. Postgres provides PITR capability but I am a little confused as how will it work in greenplum as each segment ...
0
votes
0answers
19 views

High RAM usage during Postgres PITR

We're currently running Postgres 10 in our infrastructure with Barman managing weekly full backups and holding onto the WALs. Because of the size of our DB, the WAL volume, and resource constraints ...
0
votes
0answers
143 views

Why can mysqlfrm not read from my .frm file? See debug output

I'm working on a project at home and learning databases as I go. Because of my inexperience I've just learned the hard way that cut/pasting .ibd files is an extremely bad idea. The tables have ...
0
votes
0answers
20 views

Carving deleted records from MyIsam Engine

I researched on the internet for a long time. According to my research, I found that it is not possible to bring back the deleted row in MyIsam. MYD, MYI, FRM files are available. I can only repair ...
0
votes
0answers
76 views

Import Sybase SQL Anywhere 8 DB into SQL Server without access to Sybase

This is my first post here and its a doosy. I am facing what seems to be a unique situation at the moment. I am in the process of moving my client to a new environment which includes decommissioning ...
0
votes
0answers
21 views

Restoring MySQL databases from var directory files backup?

I have no known sqldumps of these databases but have the files recovered from my AMPPS installation on a crashed computer. I cannot recover them in AMPPS on this one as I have Laravel Valet installed (...
0
votes
0answers
60 views

Attempting to Restore Database From ibd Files but Receiving Errors on Tablespace Import

Recently, a customer (who didn't take backups of their system for whatever reason) had a database disaster so their production database had all of its files removed EXCEPT its ibd files. I have ...
0
votes
0answers
175 views

SQLite: Extract data from the `-wal` file

Yesterday I accidentally deleted an SMS banking notification thread on my Android device. A classic case: I didn't backup the messages for very long time. After flashing the recovery and rooting the ...
0
votes
0answers
66 views

Is it possible to extract text from an .ibd file?

I had a small mediawiki installation that became corrupt. The MySQL installation is no more, I only have the data directory. Long story short, I'd like to dump the raw page content from the text.ibd ...
0
votes
1answer
31 views

Restore from .db folder for Analysis Services

There is an objective to recover cube from long time ago retired MSAS instance. Issue I'm currently standing with is that actual .abf backups are now in a cold storage and recovering them would take a ...
0
votes
0answers
88 views

Recover InnoDB tables with FRM, ibdata1 and log files, but without ibd files (innodb_file_per_table = OFF)

I have spent three days investigating how to recover my database. I have the ibdata1, the FRM, and the ib_logfile0 and ib_logfile1 files (It seems I don't have the ibd files since my configuration ...
0
votes
0answers
16 views

RMAN restore / recover

this is probably a simple question, but I'm not finding an answer which I deem correct. So at this organization, they take a weekly backup using RMAN, ship those to a standby server, and perform a ...