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.

Filter by
Sorted by
Tagged with
0
votes
1answer
38 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) ...
0
votes
1answer
846 views

MariaDB master-slave replication failover and failback

I'm trying to configure a DR instance of MariaDB (10.1.13) using master-slave replication. I was able to establish the master-slave relationship with GTID by locking the tables on master, backing up ...
0
votes
1answer
269 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
59 views

Restore MySQL tables with data folder only?

I have many MySQL databases with many tables and I’m trying to figure out if I can restore all of it only using the content of my MySQL data folder. Or should I just not bother and use the following ...
0
votes
1answer
1k views

Log Shipping Monitor Server Instance

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every few hours. ...
1
vote
1answer
1k views

Log Shipping Backup and Destination Folder Location [closed]

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every four hours. ...
3
votes
1answer
377 views

SQL Snapshot Redirect

Company is implementing Database Mirroring Asynchronous with Snapshot. This provides some Disaster Recovery with Reporting area. Server A Principal contains database which mirrors to Server B, ...
1
vote
1answer
493 views

SQL Mirroring Locking/Blocking Contention

We want to setup Mirroring High Performance Asynchronous. Server A Principal contains database which mirrors to ServerB. Mirroring does not allow read-queries unless snapshot is created. 1) If we ...
3
votes
1answer
5k views

Always On FCI vs Always On Availability Groups

What is the advantage of Always On Failover Clustering vs Always On Availability Groups? Basic Always On Failover Clustering provides server level protection, (eg: 2 servers with 1 shared disk space; ...
1
vote
1answer
229 views

Failover Cluster, Availability Group, and Disaster Recovery

We have an active/passive Windows Failover Cluster setup as an HA solution. Here is an example of what that might look like: Cluster1: [Node1 'active', Node2 'passive'] We're looking to set up a DR ...
0
votes
1answer
144 views

Can we reconstruct/reset a broken Postgresql data directory without losing data? [closed]

I'm trying to restore a database from a broken data directory that have lost many of its files accidentally. I have tried unsuccessfully to install new instance of the same Postgresql version and ...
0
votes
1answer
178 views

Can you implement DR in cloud using Async AG, logshipping with an on-premise FCI solution?

What are my options for building DR in cloud if I implement FCI for HA on-premise. The goal is to have a Hybrid on-premise HA + DR in cloud solution. Can I configure Async AG/logshipping in Azure ...
0
votes
2answers
68 views

all of the databases recovery models changed

i logged into a client's server today(which had log shipping for all of its db's), and found that someone changed all the databases recovery models to simple. so now i need to reconfigure the log ...
3
votes
1answer
1k 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
1answer
86 views

Unistalled MySQL 5.6 and installed MySQL 5.7 - Restore Database and Tables

All of the data resides in "C:\ProgramData\MySQL\MySQL Server 5.6\data". There are 46 folders inside of this folder. There is one folder for every old database I had. For example the first three ...
5
votes
1answer
999 views

SQL Server rollback schema update

Say I have a hand-written script which performs a bunch of schema changes, eg: (plucked from air): Adds 2 columns to an existing table Creates a new stored procedure Alters an existing stored ...
1
vote
1answer
725 views

Mirroring and log shipping together

We are using SQL Mirroring as an HA solution and Log Shipping as a DR solution. Recently, the mirror database has been configured as a log shipping primary (the mirror/primary database) to allow log ...
4
votes
1answer
6k views

How to restore corrupted InnoDB tables?

We have a data loss: the MySQL database is dropped and we have to restore the tables from ibd files. The backup is too old so we have to undelete the deleted database files. Most of the tables are ...
0
votes
0answers
1k 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 ...
1
vote
0answers
215 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 ...
1
vote
1answer
105 views

High availability SharePoint farm with restricted conditions

Currently, our SharePoint farm has restricted conditions as below Shared folder is not allowed FTP/SFTP is not allowed SQL FILESTREAM is not allowed SMB protocol is not allowed Using Windows Server ...
1
vote
1answer
2k views

SQL Server Multi-Site HA/DR Solution

I want to deploy Multi Site SQL Server HA/DR Solution. I am not sure if I use FCI/AG. In my case whenever the wan link is down at Site1 my ISP is redirecting my wan traffic to Site2. I was thinking ...
2
votes
1answer
1k views

v$ or rc views to report on RMAN restore database preview

Setup: We take an Incremental level 0 backup weekly using: RMAN> backup as compressed backupset incremental level 0 database; RMAN> backup check logical as compressed backupset (archivelog all ...
2
votes
1answer
48 views

AAG expansion between datacenters

We have a 2 node AAG setup in the DC data center, and due to an application requirement, it requires a third node to be created at the DR site and the only option I have is at the Data center in San ...
2
votes
1answer
450 views

Getting past corrupted binary log "Error in Log_event::read_log_event():"

I have a binary log that mysqlbinlog chokes on with the error in the title. The file itself has much more activity after the cited position. Doing some basic confirmation it's not all garbage by ...
6
votes
3answers
2k views

SQL Server Always On Node and File Share Majority

I am looking for some guidance on architecting our SQL Server 2016 SP1 Always On Availability Groups HADR solution on Windows Server 2012 R2. We have a primary site A with a primary replica and a ...
2
votes
1answer
2k views

How to recover an overwritten SQL Server database

We have SQL Server Standard Edition with several databases. We backup via a Windows Task that executes the sp_BackupDatabases procedure. We have a case where a database got replaced by a backup from ...
3
votes
2answers
571 views

SQL Backup/Restore and Disaster Recovery solutions with VMware

Is vSphere Replication safe for SQL databases? We are a virtual environment (Cisco hardware + VMware hosts + HP san). We have a primary and disaster recovery datacenter, with SAN-level replication ...
1
vote
1answer
2k views

How to configure multi-site SQL Server 2014 Always On Availability Group for DR

We have a two-node SQL Server AlwaysOn Availability Group cluster configured in one of our datacenters, Datacenter A, and for disaster recovery we are looking to expand this to two additional nodes in ...
1
vote
1answer
2k views

Failover and Failback SQL Server Log Shipping [closed]

I had a question on Log shipping Manual Fail over Let me explain about environment, Primary Server A (with Cluster setup A-P Mode) Secondary server B(DR server standalone). We had enabled Log ...
25
votes
1answer
3k views

PostgreSQL DELETE FROM fails with `Error: attempted to delete invisible tuple`

The error Trying to delete tuples containing invalid timestamps with DELETE FROM comments WHERE date > '1 Jan 9999' OR date < '1 Jan 2000' OR date_found > '1 Jan 9999' OR date_found < '1 ...
0
votes
1answer
121 views

Adding a geographically dispersed third node to an AAG cluster

We have a 2 node Always setup in our data center at DC and I have been tasked to setup a third node in this cluster in San Jose. What are the considerations I need to take to make this happen? I read ...
1
vote
2answers
232 views

Transaction log uses (not backups of transaction logs)

Working with an interesting scenario that quite frankly, I have not had the time to test, and would love some expert insight. I have a question concerning transaction logs, and their possible use for ...
1
vote
0answers
221 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/...
1
vote
1answer
39 views

Doubt in Log Shipping

Currently, I have setup log shipping from production server to DR server. Now, the doubt is that whenever my production server goes down or lets say data center crashes, I will switch it to DR site. ...
1
vote
0answers
53 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 ...
1
vote
1answer
622 views

AlwaysOn Availability Groups - Proper Quorum across WAN

I am evaluating the usage of AlwaysOn Availability groups with one node located in one data center, and another node located in a DR site. Both nodes are running in vmware on the same domain. I've ...
1
vote
1answer
309 views

Service Broker - DR

Our developers are currently working on Service Broker and will be implementing in production soon. What do I need to worry about with Log Shipping in regards to DR? The environment they are ...
0
votes
1answer
535 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, ...
0
votes
3answers
71 views

Problem installing SQL Failover cluster

Let me first tell you my current environment in which there is one windows cluster on which there is sql cluster with two nodes, i.e, A and B in it. Of which, one A is active and B is passive. So, ...
0
votes
1answer
60 views

Why do we need BCP Node in AOAGs

I have PROD Site and DR Site. If PROD site is completely down.I have backups of PROD site for Databases which are in SYNC and backups using a Third party tool.So I have copied the latest backups to DR ...
0
votes
1answer
103 views

AlwaysOn Async mode

I have forced manual failover AOAGs to BCP node.I tested my application and data is reflecting in tables very late.Is it expected behavior or I need to take care of anything permissions,firewall ...
0
votes
1answer
573 views

Business Continuity Plan for web application and database [closed]

I have been asked by work to set up a business continuity/disaster recovery plan for two similarly implemented web applications and associated databases. Not something I'm familiar with doing. What ...
1
vote
1answer
212 views

Business Continuity Plan -- How can I connect to DR Server if PROD site is completely Down

I have two servers in one DataCenterA (PRODUCTION SQL SERVERS AOAGs) and one server in another DatacenterB (DR BCP AOAGs).What if DataCenterA is completely Down.Now how can I let the Application stay ...
0
votes
1answer
239 views

Rebuild system databases to a different location

Firstly, forgive my poor question title. I couldn't think of the best way to summarise this. Essentially I'm putting together some scenario based DR documentation, with this specific scenario being ...
5
votes
1answer
51 views

Recover Instance after Log File disk error

This is mainly theoretical, but I would like to have a documented list of options if this happens in the future. Today we had a critical disk error on the SAN, meaning the disk holding the ...
2
votes
1answer
80 views

SQL Server AG in primary site with separate WSFC AG in secondary site

I would like some feedback from those experienced with SQL Server Availability Groups (AGs) in multiple sites. We have a scenario where there are five SQL Server 2012 Enterprise Edition servers in a ...
2
votes
1answer
4k views

SQL Server AlwaysOn Error:35250

I am configuring AlwaysOn in my test environment but getting the following error. Msg 35250, Level 16, State 7, Line 1 The connection to the primary replica is not active. The command cannot be ...
0
votes
1answer
737 views

Corrupt Transaction Log on database

I have reason to believe the transaction log file on my database is corrupt. This database is involved in transaction based replication (both subscription and publishing), and I'm unable to start ...
4
votes
1answer
197 views

New SQL Server from backup; application has successful login on 1 database, but fails on another: 0x80040e4d

Our SQL Server crashed and burned, the hard drives destroyed. No hope of recovery. We need to get a very important application working again; this is on a different server. We've set up a new SQL ...