Skip to main content

Questions tagged [disaster-recovery]

A set of policies and/or procedures that enable the recovery or continuation of vital infrastructure and systems. Please be sure to include what DBMS you are using.

42 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7 votes
1 answer
13k 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 ...
国贵棠's user avatar
3 votes
0 answers
494 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 ...
Lucas's user avatar
  • 31
2 votes
0 answers
37 views

Why would my MySQL replica server experience an sql integrity constraint error after losing connection and attempting to start again?

I have a master-master replication setup between two different servers using MariaDB. One is the primary server (server A) that is connected to my web applications, and the other is a replica that ...
Timothy Fisher's user avatar
2 votes
1 answer
99 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 ...
ajsdg's user avatar
  • 21
2 votes
0 answers
93 views

How To Roll Back DR Transactions Without Breaking Mirror

We have a full data center DR test coming up and will need to fail over all of our SQL Server databases to the DR site. The majority (>80%) of our databases are SQL Server 2008 R2 using Database ...
Michael Brule's user avatar
2 votes
1 answer
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 ...
unixmiah's user avatar
  • 156
1 vote
0 answers
55 views

DR - Missing binlogs in Maxwell

We have a standard db.r6g.2xlarge RDS MySQL instance running in production with 2 replicas. Maxwell CDC is setup to publish binlogs to a Kafka topic. From a RPO point of view: in the worst case (say ...
Amit Dalal's user avatar
1 vote
0 answers
39 views

Data retrieval from WAL since cluster init

Postgres documentation is very clear that to utilize the WAL archive for replication or restore, a base backup must first be in place, upon which later WAL records can be applied. Firstly, would it be ...
PinnyM's user avatar
  • 111
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
1 vote
1 answer
3k views

Corruption of files in postgres: The database subdirectory "base/13067" is missing

Right, my PostgreSQL database 11.1 is on top of a GlusterFS. My GlusterFS break, my backup was being done on another table and I don't have backups anymore. I started the database on a docker ...
Psycho Mantys's user avatar
1 vote
0 answers
83 views

Splitting file groups of large SQL Server database using FileStream

Background: I have a SQL Server database which is storing documents in the file stream. These documents are usually accessed via Web API by Mobile Apps and Modern JS Apps. The size of the database ...
Angry Coder's user avatar
1 vote
2 answers
4k views

Always On Availability Group Failover Issue

I'm testing a PowerShell Disaster Recovery script and trying to fail over to an off-site AG DR (asynch) replica with this command ALTER AVAILABILITY GROUP [MyAG] FORCE_FAILOVER_ALLOW_DATA_LOSS On ...
Mike Petrak's user avatar
1 vote
0 answers
264 views

Postgres not able to recover in replication mode

Because of manual cleanup of WAL files, my DB is corrupted. PostGres is throwing this error : 2017-08-10 20:44:41.887 UTC 2661 LOG: database system was interrupted; last known up at 2017-08-03 ...
Vineet's user avatar
  • 11
1 vote
0 answers
234 views

Start up replication after AlwaysOn failover

I have a 4 node AlwaysOn configuration with 2 nodes at the main site, 2 at the DR site and a FSW. The 2 main site nodes are configured for Automatic/Synchronous fail-over, the 2 DR nodes are Manual/...
Frank's user avatar
  • 11
1 vote
0 answers
58 views

Failover stragtegy for replicant db via 3rd party

We use a Multi-tenant SaaS product hosted in the providers network. They provide us a 3 replicate db for our data, updated approximately every 30 min. We used this replicant database for our read ...
Justin Homes's user avatar
1 vote
0 answers
137 views

How to sync incomplete replication records in MySQL

if replication breaks and you end up with a couple of records not pushed out to the slave, is there a way to update the slave without stopping locks on the master and manually transferring a new ...
doeJ's user avatar
  • 33
1 vote
0 answers
41 views

Replicating data from SQL Server 2014 to SQL Server 2005 - temporary solution

I will be installing a new SQL Server 2014 database system, which is based on our current SQL Server 2005 database system. The new system will be on a completely new infrastructure when we go live, ...
Joe's user avatar
  • 41
1 vote
0 answers
43 views

Looking for a DR-like solution to enable full data warehouse re-load while having secondary copy live

I am looking for suggestions/ideas to the following problem. We have a number of data warehouses for each of our clients (on SQL Server 2014). These data warehouses are maintained fairly fresh with ...
SQL_Guy's user avatar
  • 665
0 votes
0 answers
19 views

What purpose does SMK serve in a DR situation?

I have SQL server 2022 running under domain svc account (mydomain\sqlsvcacc) I setup linked server, couple of normal dbs, encrypted dbs, logins, roles and permissions. How to simulate DR I setup a new ...
variable's user avatar
  • 3,644
0 votes
0 answers
11 views

Is it possible to add a node which does not have private network connectivity with other nodes?

I have a 3 node replicaset setup Both have private connectivity with each other and resides on same DC (DataCenter1) 10.1.0.1 - Primary 10.1.0.2 - Secondary We are planning to have another ...
JRA's user avatar
  • 149
0 votes
0 answers
31 views

Always on availability group removing nodes

We have a SQL 2014 enterprise with 4 node availability group database with 2 Synchronous commit , 1 read only Asynchronous for reporting and 1 DR asynchronous. Due to space shortage we need to remove ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
0 answers
35 views

Data Loss and data redeundancy when forced failed over to secondary replica on DR Data Center in SQL Server 2016

We are using SQL Server 2016 Enterprise edition and planning to have 2 datacenters primary and the remote Disaster recovery(DR). We have 2 replicas (primary replica and secondary replica) in the ...
Manoj Jeganathan's user avatar
0 votes
0 answers
29 views

Migrate cold database (freebsd) to mariaDb on ubuntu

I have a little bit of a pickle: I have a freebsd based jail that ran nextcloud with mysqldb The machine running the jail is broken. I still have the jail with the data. Now I was wondering if I can ...
chas0r's user avatar
  • 1
0 votes
0 answers
38 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
0 answers
58 views

Postgres - how to manage losing a tablespace

I have a postgres 13 database installed on an SSD drive. 90% of the tables and indexes are in a tablespace on the SSD drive. I also have a 2nd hard disk (magnetic HDD) which contains a 2nd tablespace, ...
ConanTheGerbil's user avatar
0 votes
1 answer
983 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
0 votes
2 answers
2k views

SQL1273N - Missing log file "S0000000.LOG" in database partition "0"

I'm getting this error when trying to connect to a DB2 Database. This error started after the OS restarted. db2 => connect to cm SQL1273N An operation that reads the logs in database "CM" ...
PAULO CRISTIANO KLEIN's user avatar
0 votes
2 answers
285 views

Failing over to DR site Availability group

I have a 4 node cluster SQL 2012 availability group database with one witness server at the primary site. 3 nodes are in the primary site and one node in the DR site. Due to maintenance at the Primary ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
136 views

Sql server replication for HA and DR

1.)According to brent ozar's HA and DR chart,for Failover Cluster Instance - SQL Server minimum version supported and SQL Server minimum edition required is given as 'any'. Does that mean it works ...
IT Researcher143's user avatar
0 votes
2 answers
715 views

Connect two Percona XtraDB Clusters in two data centers

I have been trying to figure this out the past couple of weeks. We used to have a five-host Percona cluster at different providers. When it started acting up I read that it is a bad idea to have ...
Les's user avatar
  • 1
0 votes
0 answers
512 views

Deleted Postgresql Data Directory

PostgreSQL data directory was accidentally deleted. Right know I'm using photorec to recover all the files in the disk. I also know from the docs the structure of that directory. There are text files ...
cachique's user avatar
  • 231
0 votes
1 answer
84 views

SQL server Log Shipping

I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can ...
mukki's user avatar
  • 11
0 votes
2 answers
475 views

SQL server alwayson 3 Node Primary Down

I am using three node alwayson Availability Group SQL 2012 Enterprise Edition. 2 Node in DC with File Share Witness quorum also in DC and third node to be setup in DR I need to perform a DR switchover ...
mukki's user avatar
  • 11
0 votes
1 answer
46 views

Failover from Primary to Asyn Secondary Replica

In my environment we have 1 Primary 1 Synchornous Secondary and 1 Asynchronous Secondary Replica (Off site). We are planning to do a manual failover to the Asynchronous Secondary Replica (Off site) ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
0 answers
2k views

How to restore Oracle 11g database without controlfile and spfile for a new server?

Hello everyone I have made a backup to my Oracle 11g dtabase with SID=ORCL using the command backup database plus archivelog this my output after performing this command Starting backup at 10-SEP-17 ...
Osama Al-Banna's user avatar
0 votes
1 answer
729 views

Safe method to rename a crashed myisam table

I have a large MyISAM table which has crashed. Repairing the table will take some time. The table only INSERTed to and SELECTed from, never updated. To allow the application to continue working, ...
symcbean's user avatar
  • 339
0 votes
1 answer
59 views

How can SQL server AlwaysOn AG can be used as a DR feature?

I'm using AlwaysOn ag feature as a HA feature where automatic failover is possible.. I was thinking to log shipping as DR but there is potential data loss in that.. thinking of using ag as a dr(async)....
tesla747's user avatar
  • 1,896
0 votes
1 answer
1k 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 ...
SoftTimur's user avatar
  • 151
-1 votes
1 answer
35 views

Backup and Restore Disaster Recovery

I am using PowerShell to write a script for DR, assuming that we only have backup files of all the databases. If i have a latest sql server version and i want to restore some database from backup ...
LearningSQL's user avatar
-1 votes
1 answer
81 views

What is the equivalent of on prem ha dr solutions in the azure cloud PaaS and SaaS?

On prem ha dr solutions are: Log shipping Mirroring Replication FCI AG What is the equivalent of each of the above in the azure cloud PaaS (azure sql managed instance) and SaaS (azure sql ...
variable's user avatar
  • 3,644
-1 votes
1 answer
40 views

SQL alwayson AG Disaster Recovery

Need advise on below: I have 2 node alwayson AG on Primary Sync mode in the current configuration and fsw is in Primary DC only Actually during Switchover the entire DC 2 node and fsw will be down ...
mukki's user avatar
  • 11
-2 votes
2 answers
50 views

Does a DR plan need to be in place for an AlwaysOn availability group

I have two SQL servers 2022 in a normal availability group. I have heard that AG is capable of disaster recovery. Is this true or do I need to make an extra plan? Another question: Why is Failover ...
Hector234's user avatar