The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
24 views

Query on Standby redo logs - Oracle

I have a oracle 11g (11.3) database running with two standby databases (at different locations) in Maximum performance mode. The platform is Linux. Log transport parameters are: log_archive_dest_5 ...
1
vote
0answers
19 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 ...
1
vote
1answer
44 views

Postgresql - Point in Time recovery using recovery.conf and trigger. How to minimize the time waiting for .history files

Following http://www.postgresql.org/docs/9.1/static/continuous-archiving.html, I copy the WAL archives to another machine and apply them regularly. Recently due to pg server crash at my main server I ...
2
votes
1answer
23 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 ...
0
votes
0answers
29 views

Oracle DB - DR corruption

One of my databases in my DR is fully corrupted ( I have checked running validate database using RMAN). Now to recover all the data files which are corrupted I need to copy the data files from my ...
0
votes
1answer
42 views

what exactly does an RMAN backup do?

I have a database with multiple schemas and data in the tables. I create an rman backup and backup archivelogs. I drop 90% of the tables. I do rman restore and recovery with controfile from ...
1
vote
0answers
17 views

Oracle far sync in 12c [closed]

How efficient is far sync feature when it comes to dr? Does it really provide zero data loss with very less compute?
1
vote
0answers
16 views

Oracle DataGuard [closed]

Maximum performance and Maximum Availability modes has only difference right? Former is async mode and the latter is sync mode wherein it waits for acknowledgement for up to a time and after that it ...
0
votes
1answer
20 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 ...
2
votes
2answers
66 views

Hyper V replication - vs - sql replication solutions

I need to establish an offsite copy of a number of production servers, including SQL server. Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
6
votes
2answers
180 views

SQL Server 2012 Standard Edition Disaster Recovery Options?

Suggest me the best method for My DR plan. Currently we have set of databases (6) used for our application and we in the process of building DR and HA plan. As we are into small business we are using ...
2
votes
0answers
28 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 ...
1
vote
1answer
60 views

Oracle: Recover source code/table structures from “utterly wiped out” development database

Given an Oracle 11.1 database used for development, running in NOARCHIVELOG mode, where all datafiles (including undo) have been wiped out; and only SYSTEM and SYSAUX datafiles and control file remain ...
1
vote
1answer
92 views

LSCopy job fails on SQL Server 2005 - Insufficient space

I'm having some trouble getting my LSCopy job of Log-Shipping on my SQL Server 2005 server, to work. The LSBackup job is configured so the backup is made locally (D: drive) The LSCopy job is ...
1
vote
2answers
132 views

Why is Full Recovery model a requirement for AlwaysON? [closed]

We have all our production databases in simple recovery model, and are very happy about it because it fully satisfies our RPOs and RTOs. Now we want to implement AlwaysON DR solution for our ...
1
vote
5answers
94 views

Getting Data Back after Wrong Data Restore in SQL Server

I would like to inquire if there is an possible way to return lost data that stored in a Sql server Database after making a wrong database restore? I know it is extremely hard to get a positive ...
0
votes
1answer
55 views

Operating system disaster recovery strategies

I have read a lot about disaster recovery planning of databases (mainly SQL Server). There are multiple articles/book chapters about backing up databases and recovering them from backup. But what if ...
0
votes
1answer
65 views

Ubuntu broken need to recover mysql db

With a recent Ubuntu upgrade it has broken my system. I now only have access to the filesystem through a live CD. I had a MySQL database on the system with many objects and views I would hate to lose. ...
1
vote
1answer
249 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 ...
0
votes
1answer
81 views

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ...
0
votes
0answers
53 views

How can I run a SQL Server 2000 database on SQL Server 2005 Express with a different location for files

I am trying to help a client out after a server crash. The temporary replacement server has different drive letters and data file locations. Here are the system details as I understand them: ...
0
votes
1answer
53 views

DB2 Transaction Logs - can they be COPY-PASTE on another Disaster Recovery Server?

We have Server1 with Online Backup1, Archive Logs 1,2,3 for example and Transaction Logs from 1 to 10. We are interested in next scenario: If Server1 fails completely and we want to move everything ...
1
vote
2answers
56 views

RMAN backup set, nothing else, how can I duplicate?

I have what appears to be an RMAN backup set, it has been multiplexed in 32 files, each containing 2-3 dbf's inside. The backupset refers to an SPFILE file, but it was not included in the set, the ...
1
vote
3answers
136 views

Recover deleted table from the database

Currently I deleted one table from the database. But now I want some of the information from that table. Please suggest how to restore or get back the table. I am using SQL Server 2008 R2.
1
vote
2answers
235 views

Best DR strategy for MS SQL Failover Cluster [closed]

I have... 2 database servers 1 shared SAN storage 2 MSSQL 2012R2 (Standard) server instances (2 SQL Failover Cluster) Server A is the primary node for SQL Instance A Server B is the primary node for ...
0
votes
3answers
122 views

Problem to access the SQL Server

I have SQL Server 2005 which is installed on server machine. I was working fine on SQL server before I change the server machine IP. I changed server machine IP to host the Web Service on it. But ...
0
votes
0answers
60 views

Postgres 9.0 recovery from inadvertent drop-all-tables event

Due to a accidental config file check-in, a unit test wiped out our entire production database (did a drop, then re-created the tables). Trying to restore from backup revealed the recent backups were ...
0
votes
1answer
941 views

Not receiving archivelogs from production to remote side

I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote ...
0
votes
1answer
18 views

MySQL recovery procedure

After the server die, I have "old" HD (it is external now) with sock file and data files in mysql directory. Where I should find information how to restore the data in fresh installed MySQL? What ...
1
vote
1answer
59 views

Dual site active-active highly available database

I have an application that is being run on two separate sites. Ideally they would share a database, because each application needs to see what the other is writing to the database. However, the sites ...
0
votes
1answer
73 views

Replication Madness

Summary We were contracted to build a "Hot-Standby" for a company which keep their data in the cloud. The through-put is relatively low. Database availability/accuracy is a matter of life or death. ...
0
votes
2answers
371 views

Disaster Recovery Options for Sql Server

I wanted to see what suggestions you might have for Disaster Recovery Options based on the following criteria. Currently running SQL 2012 standard edition We have 18000 databases (same schema across ...
2
votes
1answer
341 views

Disk Crashed, NDF(Index) file lost

I have database with : -two filegroups (PRIMARY and INDEX) -three files .mdf(data), .ndf(index) and .ldf(log) every file is on different disk, yesterday disk where was NDF file crashed so I lost ...
1
vote
1answer
139 views

Best practice for testing database disaster recovery [closed]

This is regarding database disaster recovery testing. The production server has 20+ databases. I'm developing procedures for regular testing of disaster recovery and am wondering what is the best ...
2
votes
1answer
293 views

Log shipping - failed over to secondary, how to fail back

SQL 2012 I've been researching and testing Log Shipping as a DR solution. I got the two servers setup. Log shipping is in place and verified to be working correctly. I failed over by restoring the ...
0
votes
1answer
45 views

Oracle Recovery

Oracle server died. Built a new VM and mapped out the volumes to the SAN. Installed the same version of Oracle on the new server and applied the same patches. How can I "register" or "attached" the ...
0
votes
2answers
552 views

Recovering mysql innodb table from table.ibd backup file

Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups every half an hour (on our slave server). Now for a scenario, where some how a table has been ...
0
votes
1answer
362 views

Mysql trying to recover from Hard disk failure [duplicate]

Am trying to get a database up and running after having a hard disk crash, got the data recovered. mysql can only start with the innodb_force_recovery set as 5 or 6. When started I can get a table ...
3
votes
1answer
198 views

Can you restore log file backups to a mirror database after failure?

Purely a theoretical question as I've been considering possible DR scenarios... In this scenario: The link between a principle and a mirror server becomes unavailable for a period of time (e.g. ...
1
vote
1answer
204 views

Database Recovery Model - Simple vs. Full [duplicate]

Does the SIMPLE Recovery Model perform the same transaction logging as FULL Recovery Model? i.e. keep record of each insert/update/delete transaction? If this is the case, then why should FULL ...
1
vote
2answers
180 views

Recovery from datafiles

Thanks to the recent weather/floods, we lost many of our servers. This included our central database server as well as the server that holds our backups. The database server was running Oracle 12c ...
7
votes
1answer
2k views

Broken tempdb location and can't recover

Made a mistake and mistyped an alter database command for tempdb. Now the instance won't start. I can't start in single user mode using -m as it states the tempdb could not be found. I tried using: ...
0
votes
1answer
906 views

FATAL: catalog is missing 1 attribute(s) for relid 2662

I have a server with PostgreSQL9.1-903 (Windows 7 Professional). After a power cut my database is inaccessible (I presume that the database is corrupted). The postgreSQL service starts but the ...
3
votes
0answers
259 views

Why are we suddenly getting time-outs on multiple transactions? [closed]

Two days ago the transaction log filled up and my user's couldn't update or insert. One of my techs truncated the log, shrank the db, then did a full backup. The next day (Monday) we noticed that ...
3
votes
1answer
3k views

Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster

SQL Server 2008 R2 multi-instance cluster (on VMware vSphere 5.1) 2 nodes, each running 2 instances 16GB RAM per node. The only time the instances are on the same node is when I am patching the ...
2
votes
2answers
189 views

Get missed transactions from slave

I'm trying to write a disaster recovery plan, I have one way replication with 1 master(A) and 3 slaves(B,C,D) A /|\ / | \ B C D Let's say my master crash, and I loose all data on ...
0
votes
1answer
336 views

Disaster Recovery for PostgreSQL 9.0

We have a number of PostgreSQL 9.0 servers. We use binary replication to have a host standby instance of those. The only problem is that is someone drops the master, with or without intentions, this ...
0
votes
3answers
284 views

Oracle DB Recovery

Before I start, I just want to mention that I am not a DBA, I am a programmer/developer who also happens to look after the database. So if I say something wrong, my apologies in advance. We recently ...
1
vote
3answers
157 views

Master/Slave without populating tables

So I have some Zabbix instances which are using MySQL for their backends. What I would like to do is, for DR purposes, backup the DBs for each instance using a Master/Slave configuration, with the ...
0
votes
1answer
169 views

RavenDB - Disaster Recovery on a Replicated Instance

EDIT: I'm encountering precisely the same issue. Assume that I have two RavenDB instances. Instance 1 contains one document: users/1. Instance 2 contains three documents: users/2, users/3, and ...