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.
132
questions
1
vote
1answer
27 views
Log Shipping between 2 AGs
I'm having one AG with two nodes (active-passive) in one data center and another AG with two nodes (active-passive) in a different data center.
I need to have log shipping enabled between these two ...
6
votes
2answers
251 views
What is the best option for High availability on a data warehouse?
I have a customer who have an existing 1.5Tb data warehouse and are currently planning for a complete refresh of the DW on a new environment. Their infrastructure manager has organised 2 servers with ...
0
votes
2answers
45 views
Transaction Replication as DR solution
I have a production database server and a failover database server set up.
All the transactions from the primary production db server is being replicated(transactional replication with initialize ...
0
votes
0answers
172 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 ...
0
votes
1answer
44 views
How to setup a SQL Cluster between 2 sites in active passive mode without shared storage
we need to install SQL at 2 sites, 1 primary and 1 DR. We don't to pay for license for the DR and need to know how will we setup a SQL cluster/replication/alwayson/bag or any other method that will ...
-1
votes
1answer
93 views
Accidentally overwrote mysql database with empty data [closed]
I accidently imported an empty database backup file into the same database, using mysql-workbench. Is there any way to undo this and get the data back? The backup available is 4 months old which is ...
2
votes
1answer
54 views
What are the potential issues after data or log disk failure?
Scenario:
A client recently had an issue with an Azure VM where the (non-OS) 'premium' storage disks were erroneous removed without warning by Microsoft. This is the virtual equivalent to the hard ...
1
vote
2answers
162 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 ...
4
votes
1answer
1k 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
284 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
35 views
I am trying to achieve a Disaster recovery for Mongo DB
Right now i have a MongoDb HA in site one and i need another site with asynchronous replication enables in another location.This is a base plan of mine to achieve a disaster recovery .
I dont have ...
3
votes
1answer
128 views
Attach ldf more current than mdf
Is it possible to create a database where the ldf is more current then the mdf? Or to attach the older (more mature) ldf to the younger mdf (less mature)?
I am working on Steve Stedman's Week 3 ...
0
votes
1answer
23 views
Domain Controller on Multi Subnet Always on Availability Group
This is will be my first big project. We have 4 Replica Always on availability group with 3 Replica on site and another replica offsite (different subnet) the File share witness will be placed on ...
7
votes
1answer
142 views
PostgreSQL ANALYZE execution time over 24h (still running)
I upgraded a Postgres DB 9.3.2-->10.5 using pg_upgrade (in place). I did everything according to the documentation and the instructions given by pg_upgrade. Everything went fine but then I realized ...
3
votes
1answer
96 views
Need help with SQL Server 2014 and disaster recovery
I am tasked with building a highly available SQL Server 2014 Enterprise environment for our new policy admin system. This database will eventually grow to 1TB +.
Background
Our normal method of ...
1
vote
1answer
61 views
Standard process during a disaster [closed]
In our environment we have a 2-node Failover cluster instance and log shipping for disaster recovery. Failover cluster is the primary site and log shipping is on DR. 2 node: same data center; log ship ...
4
votes
2answers
1k views
Is there a way to back up agent jobs?
I can't find documentation about whether agent jobs in SQL Server can be backed up. If not, how can I back them up in order to restore during the future recovery in case of an instance failure?
1
vote
1answer
350 views
Quorom Configuration for 3 Node Windows cluster
We have 2 node onsite and the 3rd node on DR and there is no disk witness. Due to maintenance I set the DR site to be primary and the other 2 nodes to be manual in asynchronous mode and after both ...
1
vote
1answer
424 views
Pausing the secondary Replicas for a day in always on availability group
We are planning to make the DR as primary and do maintenance on the secondary site(Formerly Primary Site) and hence pausing both the secondaries in always on availability group for a day. I am aware ...
1
vote
1answer
108 views
Problems of having DR as Synchronous Commit
In our always on set up we have One Primary and One Secondary as Synchronous Commit and the DR as asynchronous commit. If i want to change the DR to Synchronous Commit will there be any performance ...
0
votes
1answer
33 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
490 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
48 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
45 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 ...
-1
votes
1answer
546 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
723 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
227 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
259 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 ...
2
votes
1answer
2k 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
148 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
99 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
51 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
62 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
591 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
67 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
348 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
481 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
3answers
3k 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
933 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
127 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
79 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
962 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
687 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
43 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 ...
1
vote
1answer
158 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
1k 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
942 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
372 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
1k 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 ...
