Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [recovery]

Reconstructing a database.

0
votes
1answer
8 views

Permanently delete SQL server database - anti recovery

I rent a server from a server provider. And one day I'm no longer rent it. I have some important database on the server need to wipe out so no one can see it. Is that safe to just right click on the ...
7
votes
2answers
109 views

Accidental DBA: Unsure why I have a broken log chain?

First of all, thanks for having a look at this - We've got a large database in our production environment (1.26 TB), it's got a few hundred corrupt pages in it and has done for months, so the same ...
2
votes
1answer
19 views

Recover a broken or damaged database from the transaction file or “journal”

A greeting fellow, I would like to know if in MySQL (I understand that all engines must have), you can recover from damage to the database using some kind of file "journal" transactions, if so, what ...
0
votes
1answer
23 views

InnoDB ibdata1 corrupted, innodb_force_recover not working

I think I have checked every post in the internet. Thing is my MySQL (MariaDB) won't come up and after much testing I have seen it is because of the InnoDB files. I have tried with different ...
0
votes
0answers
202 views

Please help, lost data SQL server [duplicate]

I accidentally dropped several tables from a database on sql server with a command from laravel artisan (php artisan migrate:fresh), there is no recent backup but there is a log. Can I recover the ...
0
votes
0answers
36 views

how to recover database if redo logs are deleted and I have no archives

I'm working on oracle 11g database, I accidentally removed all redo logs and it happens that I don't have archive logs, I've tried to recover the database using the steps in this link https://asktom....
0
votes
0answers
15 views

How works the flash recovery area

Im working with QGIS and Im trying to save a Mapinfo map to Oracle Spatial. The map file is around 1GB and has 700k road segment. The issue is when copy the segements from the source map to the db ...
0
votes
1answer
26 views

Move a Postgres 9.3 database to a new server and update to 9.6 with minimum downtime

I have a PostgreSQL 9.3 database, which I have to move to a new server and update to 9.6 with minimum downtime. I thought I could : on the old Postgres, activate archive_command to copy WAL to a NFS ...
1
vote
1answer
48 views

Under what conditions could restore of a huge database get delayed, in SQL server 2016, hosted on VM?

I have system where my database gets restored every night, and off late the restore is taking a lot longer from past few days. Here is server config: ES 2637 XEON @ 3.5 Ghz Windows virtual server ...
1
vote
2answers
101 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
23 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 ...
0
votes
0answers
51 views

pgPool online recovery doesn't execute command

I'm configuring pgPool to manage online recovery for two database servers. The idea is that they should be able to "flip back and forth" seamlessly such that if the primary goes down, pgPool promotes ...
0
votes
2answers
25 views

In pgPool-II 3.7.5 configuration pgpool.conf, is recovery_user a role or a system user?

I'm having trouble configuing pgPool-II 3.7.5 for online recovery. In pgpool.conf, there is a parameter called recovery_user along with a recovery_password that are somehow used to run ...
1
vote
1answer
68 views

recover postgresql database after removal with --purge

I noticed, after a while, that when I got new versions of postgresql (I'm using debian testing) they were being installed while keeping older versions of the DBMS running in parallel (one listening on ...
0
votes
0answers
25 views

How to recover the database after mysqld --initialize?

I have a problem with my database, today I suddenly can't login using root. So I look for solution on the web and made a terrible decision, I used the command mysqld --intialize. Now I can login to ...
9
votes
2answers
495 views

What is an orphan incarnation?

Incarnations are explained in an answer to another question on this site. The answer mentions 'orphaned' incarnations: …There are other factors that result in ORPHANED incarnations and OBSOLETE ...
0
votes
0answers
28 views

MySQL8 Restore from Physical Files - Innodb

I recently had one of my VM's go down (MS Server 2016) and the only version I am able to get up and running is two weeks old. However, I do have a backup of my C:/ drive from last night that has my C:/...
0
votes
0answers
24 views

How to restore a mysql database

I have to re-build a mysql database (some tables were truncated), Is it possible? What logs do I need? My mysql is 5.7 running on ubuntu 18.4
0
votes
0answers
23 views

Change Data Capture between two DB versions after recovery

I want to capture the changes made between two database versions in Microsoft SQL server. When I restore my database from one version to another using transaction logs, I want to know what changes are ...
0
votes
0answers
117 views

Recovering data into truncated table

I accidentally truncated data from 8 tables. I am new to MySQL and was wondering if someone could help me with step by step instructions to restoring the data. Also, I have no experience with ...
0
votes
1answer
40 views

Recover Mysql data from formated hard disk [closed]

One of my machine got crashed last day and i ended up reinstalling windows on that machine. It had a mysql server in it. Is there a way to recover mysql data from that machine now . There are couple ...
1
vote
1answer
62 views

Check status of SQL restore with NORECOVERY before RECOVERY

We are going to move some 100+ databases and some of them are 1 TB each. To save time on Friday, we are going to perform restore from sunday's Full backups using with norecovery. And we do this ...
0
votes
1answer
596 views

InnoDB: Error: log sequence number is in the future!

Hi I have 2 node cluster where recently went offline not sure why. Node1 started fine and all the traffic is on node 1 but node 2 still down due to below error. I tried set the inodb recovery to 3 and ...
1
vote
2answers
52 views

Importing tablespace files - Length mismatch error for DATETIME field

We are currently trying to import some old historic data tables. Unfortunately, the data is in exported tablespace files (.ibd and .cfg) - there are no dump files available and the server they came ...
13
votes
2answers
1k views

Online page restore hitting 1000 limit

I've been tasked to try to recover a database which suffered from corruption (due to I/O failure, which has been fixed since). I'm not familiar with the database or what it contains. I've been given ...
0
votes
1answer
431 views

How to Restore MongoDB Database After Having Deleted DB Files From Directory

I'm running MongoDB 2.6 on Ubuntu 14.04 and I accidentally deleted db file in /var/lib/mongodb. I cannot restart the MongoDB instance: mongo: error SEVERE: unable to open file number 5. If I ...
1
vote
2answers
57 views

How to recover data from a corrupted /base/ directory? [closed]

I have deleted all directory by mistake except from the given link /var/lib/postgresql/9.5/main/base/18686 and so on. I have 4 such directories, now I want to get data back from those folder as they ...
2
votes
3answers
409 views

`SHOW EVENTS` fail with `Error Code: 1545. Failed to open mysql.event`

I have a MariaDB 5.5.56 install (The default CentOS 7 package). The VM was running on a host that had some problems reaching its storage. This resulted in the OS remounting some filesystems read-only....
2
votes
1answer
69 views

My cluster disappeared, but data is still there

I was tasked with recovering data from an old, unmaintaned server, where its main purpose application was no longer working. Basically just want to get a postgres db dump before burning the server to ...
2
votes
1answer
49 views

Is there something to rescue from an Oracle Data Modeler design just with the 'logical' folder?

First of all, I even don't know how naive is the question, we start studying this not long ago. A friend of mine was working on Data Modeler, he saved the design and he only got the "logical" folder, ...
0
votes
1answer
85 views

corrupted Oracle 11g database

At a client site with a development Oracle 11.2.0.3/linux DB power outage and crash - no archivelog mode - no backups - Don't know how this was even running select file#,substr(name,1,70) name, ...
2
votes
1answer
298 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 ...
0
votes
1answer
27 views

PostgreSQL recovery file syntax, ver 8 vs ver 9

In postgreSQL version 8.4 it seems that you can place the db server into warm standby mode with the following setting in recovery.conf restore_command = 'pg_standby archiveDir %f %p %r' In ...
3
votes
1answer
83 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): ...
2
votes
1answer
337 views

How to get archive re-do log file name containing the given SCN in Oracle?

Scenario: Let us consider oracle 3 node RAC. RMAN Managed Recovery is configured between production and standby DBs. Let us assume that the SCNs of 3 nodes are S1, S2, S3 at some point of time ...
0
votes
0answers
24 views

Redoing an Aborted Transaction

When I have already performed an abort to transaction Ti in log file, for that transaction Ti, what does it mean to Redo(Ti) after that? What are the changes brought to Disk containing the data and ...
0
votes
1answer
25 views

Need only single table from ibdata1 file

I currently have a corrupt database on my live site, because a single Table that has gone missing. Table 'test1.catalog_product_index_price' doesn't exist I logged onto my server and downloaded a ...
3
votes
2answers
80 views

Change database file path with SQL not running

I've an urgent problem. Due to some heavy delete queries, my database transaction log has grown and it has filled the disk (126GB). I've found out that backup plan wasn't working during last month. ...
0
votes
0answers
51 views

Can't recover mysql server

I have a really big problem with my database: There was an electrical failure, a hard drive got damaged, whenever I tried to start the mysql server I got the error "I/O ERROR", I found that the ...
3
votes
1answer
82 views

Oracle DBAI Theory : is it REALLY not possible to have Oracle Database Corrupted after Instance Crash?

I'm studying a little DBA stuff and I've come across instance failure/recovery. Let's say User A does DML and User B also does DML. At this point, I believe it's safe to assume DB buffer cache ...
3
votes
1answer
401 views

Archivelog file deleted, resulting in 'ORA-01113: file 1 needs media recovery'

(This is not a production database. I'm practicing in a staging enviroment.) I'm trying to set up RMAN for backup/recovery. I did a full backup, which seems to be in a good state. I then did an ...
0
votes
0answers
73 views

how to recover oracle-xe recover datafile? (oracle-xe 11g)

I have installed Oracle-XE on my Ubuntu laptop and it was working at the beginning and then after I restart I noticed the database is not open. I believe I did shut down my laptop in an unexpected ...
0
votes
1answer
54 views

Cleaning up archives in Postgres after using systemd

I'm using Postgres 9.3 and I have a master database and a hot standby one that is following the master. The operating system is CentOS 7. I've changed the way of starting Posgres from SysV to systemd....
2
votes
1answer
475 views

cannot recover mysql idb file

I recently have an hdd failure and I try to restore Griffith (https://github.com/micjahn/Griffith) database from a /var/lib/mysql/griffith file copy. My new computer uses a more recent version of ...
1
vote
1answer
2k views

ORA-01196: file 1 is inconsistent due to a failed media recovery session [closed]

I have 3 database 1 primary and two standby, The storage of one the standby was abruptly removed without shutting down the database. Few Days later the storage was returned, I restart the whole ...
1
vote
1answer
125 views

Mysql ibdata1 is broken

I was importing an old SQL into existing schema. But the MySQL service was stopped suddenly. Now I'm not able to start the service. It seems that the ibdata1 file is somehow corrupted. Here are the ...
1
vote
1answer
282 views

Transaction log records in sql server

Based on Silberschatz's Database system concepts book, log file for a transaction has 3 records, 1 record for transaction start: T_i start, 1 for transaction changes on write(x) operation: T_i,X,...
1
vote
2answers
290 views

How to decrese MySQL Innodb crash recovery time (force MySQL to do it faster)

I'm running MySQL 5.7 with 1GB of innodb_log_file_size on CentOS 7 x64 and I can't change the value of that parameter right now. In the case of crashes, it takes about 20 minutes to recover, but ...
1
vote
2answers
56 views

Recovery and Shrink [closed]

I am trying to change the Recovery Mode from Full to Simple if the database doesn't have any Full or T.Log backups setup from past week days. The problem I am facing with the below script is it's ...
1
vote
1answer
613 views

High delay lag between master/slave in Postgres 9.3

I have a Postgres 9.3 database server with this configuration: # grep archive_ postgresql.conf archive_mode = on # allows archiving to be done archive_command = 'rsync -a %p postgres@...