Stack Exchange Network

Stack Exchange network consists of 175 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.

1
vote
1answer
33 views

Access oracle database from control file

When I asked a client for a copy of his database he sent me a .ctl file, it seems it is a control file of an Oracle database. I have no experience in Oracle, I'm a SQL Server guy. I have installed an ...
2
votes
0answers
35 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 ...
0
votes
0answers
39 views

RMAN restore error to restore archivelogs

I have this backup piece with the archivelogs: BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 54 1.01M DISK ...
1
vote
0answers
18 views

Which PgBackRest policy for differential backups in PostgreSQL

I set up pgBackRest and PostgreSQL configuration in two differents servers. I set up with crontab one full backup a week and one differential backup a day. 0 1 * * 0 pgbackrest --type=...
0
votes
1answer
28 views

MySQL 8.0.15 starts normally but any connection hangs

I dropped a large table (80G) Friday morning and got a crash: InnoDB: ###### Diagnostic info printed to the standard error stream 2019-04-19T18:48:55.445507Z 0 [ERROR] [MY-012872] [InnoDB] Semaphore ...
3
votes
3answers
70 views

Is there a problem creating only differential backups every hour?

I have three databases which are not big. Every differential backup is roughly 50MB, then we have a full backup at midnight. Is there any problem doing this? I could take the full backup then logs, ...
4
votes
1answer
504 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 ...
0
votes
1answer
179 views

Recover a mongo database deleted by rm

My developer accidentally lost our database by a bash script, which turned out to run rm -rf /* (see this thread). Thanks to extundelete, he just recovered the /data/db/ folder: However, he could not ...
0
votes
1answer
43 views

Sql Server Database 2008 R2 is in recovery mode still after 16 hours

Sql Server 2008 R2 Database is in recovery mode still after 16 hours for one of the database which is is Simple Recovery model. The data file is 200 GB and Log file 90 GB. We have to do Crash ...
0
votes
0answers
25 views

Find when tables were deleted historically

We've had an issue where data tables have been deleted from a client applications SQL Server Database (Dynamics Navision). Unfortunately we had an outage and the SQL Servers were affected by this, ...
0
votes
0answers
18 views

Tables missing from MySQL database after removing then restoring the mysql data direcory

I Carried out the following operations. make mysqldump of testdb # Stop service /etc/init.d/mysql stop # Create copy of directory cd /var/lib cp -R mysql mysql.backup # Delete datafile on disk rm -...
0
votes
2answers
94 views

Using Ola Hallengren's full backup but database option is for simple?

Each database on the server is set for simple recovery. I'm using Ola's script with 'full' in the script. I tried looking on Google, but it seems backup and recovery are almost synonymous. Is there ...
0
votes
1answer
149 views

Error recover database RMAN-06054

I deleted the test database, and now I want to restore it back, when I try to recover the database I get this error. Everything I had at the database is there and everything works fine. How can I fix ...
0
votes
0answers
41 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
1answer
385 views

MySQL Crashed, innodb trying to access page number which is outside the tablespace bounds

I am running MySQL (5.7) on a Windows 2012 server. One of the table (> 1 million records) seems to be corrupted. The mysql error log shows 2019-01-16T09:41:09.256990Z 0 [Note] InnoDB: Buffer pool(s) ...
0
votes
0answers
22 views

Mongo Collection Mysteriously unavailable

We are running a mongo on single EC2 instance, we were not able to connect to it , upon debugging we saw CPU usage was spiking , this was the problem we faced previously we then restarted the instance ...
3
votes
2answers
317 views

How does the recovery strategy of PostgreSQL exactly work?

I'm testing and trying to figure out how the backup and recovery strategy in PostgreSQL 11 works but it does not work as expected. When I recover the backup, I don't get the correct state. I get any ...
1
vote
3answers
64 views

InnoDB: will uncommitted transaction produce redo log?

Before MySQL commit a transaction, it will write REDO log first, then commit the transaction, that is write ahead log. start transaction; update users set uuid = UUID() from user where id = 1 update ...
0
votes
0answers
95 views

Restore single database (or table-space) using PITR with PostgreSQL?

Is there any possibility restore a single database with WAL files.
0
votes
1answer
30 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
125 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
29 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
270 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
1answer
55 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
53 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
388 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
88 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
2answers
42 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
241 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
40 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
1k 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
62 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
26 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
1answer
44 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
84 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
885 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
95 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
747 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
107 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
946 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
132 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
125 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
93 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
767 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
35 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
98 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
549 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
1answer
37 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
157 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. ...