Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [standby]

80 questions
11
votes
1 answer

This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY

I am creating log shipping for two databases, db1 and db2. It will be from SQL Server 2008 R2 to a newer version, SQL Server 2012. On SQL Server 2008R2, they are both dbi_version = 661: DBCC TRACEON (3604); GO DBCC PAGE (db1, 1, 9, 3); GO DBCC…
ob213
  • 654
  • 1
  • 9
  • 19
8
votes
1 answer

Partial (filtered) replication in PostgreSQL

My setup looks something like this: I have a primary server (Postgres 9.6) that continually scrapes a bunch of data from the web. I'd like to be able to stream a subset of tables or databases from that primary into a secondary instance so I can read…
jeancochrane
  • 221
  • 2
  • 6
8
votes
1 answer

Can I recover a SQL database from Standby/Read-Only without a standby file?

Is there any way to recover a SQL database from Standby/Read-Only mode if the "standby file" is missing? (I see some references calling this a TUF file in a log-shipping scenario, but in my case, it was just a manual restore and the standby file…
BradC
  • 10,073
  • 9
  • 51
  • 89
6
votes
0 answers

Right way to set up a secondary citus worker

I am experimenting with the postgres-addon citus. So far I have setup a cluster with one coordinator and three worker nodes. Now I want to setup a secondary for one of the worker nodes. So far I have setup streaming replication from that worker node…
Nils
  • 149
  • 8
6
votes
2 answers

How do I configure AWS Aurora to separate write/read operations

I want to migrate my database instance from AWS RDS MySQL to Aurora, but I have a doubt about replication and how Aurora management the write/read operations. I have my application and I want to separate the write operations from the reads. I want…
Robert
  • 705
  • 3
  • 12
  • 20
4
votes
1 answer

Ship Standby Logs Without Datafiles

When building a new standby database, is it possible to have it start shipping archive logs from the primary without having the datafiles on the standby yet?
Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155
3
votes
1 answer

unable to start the standby postgres database

Situation I have 2 separate instances. Both running on Ubuntu 14.04 server. Both have installed postgres 9.5 the following way: sudo apt-get install software-properties-common python-software-properties wget --quiet -O -…
Kim Stacks
  • 215
  • 1
  • 5
  • 18
3
votes
0 answers

Cannot add standby database to the data broker configuration in oracle 11g

I have duplicated the primary database to standby database and then I added the primary database in data broker configuration. But when I'm trying to add standby database I'm getting following error: DGMGRL> add database 'orcl_standby' as connect…
Kenny
  • 377
  • 3
  • 8
  • 24
3
votes
1 answer

Data guard broker cascaded standby delay parameter is ignored

I have 3 databases: db01 primary, db02 standby cascading, db03 standby cascaded. I have configured broker parameters by the following way: DGMGRL> show configuration Configuration – DB_HQ_DR Protection Mode: MaxPerformance Members: db01 – Primary…
kupa
  • 1,737
  • 14
  • 39
  • 55
3
votes
1 answer

Can I bring a warm standby SQL Server database online and then return to standby mode?

What I'm trying to do falls outside of the normal SQL Server work flow so might be impossible. I'm implementing a system that serves out copies of a large production database to multiple test / dev / training systems. We're using a…
christutty
  • 133
  • 4
2
votes
3 answers

Can I have Oracle primary 11.2.0.1 and standby 11.2.0.3?

Can I have data guard system like: Primary: 11.2.0.1 Standby: 11.2.0.3 In logical standby ? In physical standby versions(releases) must be the same?
kupa
  • 1,737
  • 14
  • 39
  • 55
2
votes
1 answer

Strategy on Standby restore option for hourly log shipping file

I am trying to come up with a strategy of keeping up with daily database update process using "standby" restore mode. I am getting 24 log shipping files (for the previous day's each hour transaction log files) from a third party's FTP site. I would…
Java
  • 253
  • 3
  • 10
2
votes
1 answer

Postgres backup PITR strategies

Note:-Might be the question sounds too broad. But, I believe ,it's very good platform(stackexchange) and I can get advice from worldwide expert DBA here. Since, I'm not able to make decision or choose the right option. Que: I'm new to postgres and…
Shiwangini
  • 380
  • 7
  • 24
2
votes
1 answer

Postgresql - Hot standby vs Streaming

I'm trying to understand the various PostgreSQL replication technologies. But still I am unable to understand difference between Hot Standby and Streaming Replication. In this Blog the Hot Standby and Streaming replication is same. Can anyone help…
TheDataGuy
  • 1,986
  • 5
  • 36
  • 67
2
votes
2 answers

Re-map DB Users/Logins after Restore WITH STANDBY

This is related to my previous post.. Differential Backup Issue - Why? Is this Possible? Basically, the issue which I am having now is that in my restore process (as part of ETL), there are tasks to re-map db users to logins (because they are SQL…
iKnowNothing
  • 155
  • 7
1
2 3 4 5 6