recovery's questions - English 1answer

297 recovery questions.

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 ...

I have a web application setup where there are separate Apache-Wordpress containers for development and production. Database is hosted externally on a virtual host. When setting up development ...

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 ...

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 ...

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 ...

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 ...

I had a server fail (disk failure, old server; no raid) at the weekend and am unable to recover the MySQL databases from the backup. After exhausting all the usual recovery options, I've performed a ...

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 ...

We have an Oracle database, one data file (users tablespace) of the instance got corrupt and another data file (containing application data) was deleted due to some issue. The database is in ...

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 ...

So I've been building up over time a database, and unfortunately I was using MyISAM which didn't have any problems until the database became huge. After massive CPU spikes, I created a script to ...

This night my hosting provider made a "hard reset" on my VPS hosted in their farm. And one of most important databases (SQL Server 2008R2 database) is now in Suspect mode. My provider has backups (...

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 ...

To give a bit of background, I was looking for the occurrence of specific text from within multiple SQLite DB files. I initially tried a simple grep of the text on the multiple files and grep found ...

i have probleme with mysql data base in wamp ; i droped my base from phpmyadmin now i traynin to recover i creat a new one whith the same name and i import some data to croorect but its was not enough ...

I have oracle 11g that runs on Linux serve. I have a Flash Recovery Area, I backup my archive logs to another location. presently I have very little space left in my Flash Recovery Area (FRA) thereby ...

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, ...

I had to recover a database with a some months old full backup. I have however in my possession a most recent but unfortunately incomplete SQL dump for this same database done with mysqldump. Is ...

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 ...

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....

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): ...

I've made a stored procedure restoredatabase that returns code to restore a database. The output script looks like this: restore database [DB] from disk='F:\FULL1.bak' with norecovery restore ...

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, ...

I have a database that is stuck in recovery mode for few days already. There are multiple threads about this, but the solutions there don't work for me. Here is what I tried already: RESTORE ...

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 ...

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 ...

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 ...

When starting up automatic instance INSTANCE: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-...

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 ...

I'm testing a procedure via RMAN backup to retore/recover at recover-point, but it fails. Exactly I've executed the first time and it works: Backup: RMAN> backup database INCLUDE CURRENT ...

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 ...

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 ...

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. ...

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 ...

I have a pretty big PostgreSQL 9.1.3 running on Ubuntu 10.04. The data is spread over multiple tablespaces = physical drives. One of these drives is gone, so the directory of that tablespace doesn't ...

(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 ...

I have a Mongo replica set with a few secondaries. A box, which hosts a secondary instance, crashed and lost the database. I started the secondary Mongo instance again and now it's stuck in STARTUP2 ...

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 ...

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....

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 ...

I have a database with the following tablespaces: pgwb=# \db List of tablespaces Name | Owner | Location ------------+-------+-----------------------------------...

I have the .frm and .ibd files from an old, non-working MySQL server (on Windows). I took out the hard drive and was able to get the data directory copied to my machine. How would I get them into ...

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 ...

I crashed all my 3 nodes. After all nodes have been started I noticed that mariadb is dead. An I couldn't run it again. I am using CentOS 7 on all servers I tried to start first node and then others ...

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,...

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 ...

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 ...

I am aware that this question has been asked before (like here) and is documented, but my situation is a bit different. Right now, I only have access to the folders of each database (named according ...

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@...

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 ...

Related tags

Hot questions

Language

Popular Tags