Questions tagged [standby]
75 questions
9
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
- 624
- 1
- 9
- 18
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
- 9,504
- 8
- 43
- 82
6
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
- 101
- 1
- 6
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
- 605
- 2
- 11
- 19
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,534
- 16
- 75
- 147
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
- 105
- 1
- 3
- 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…
Joe Joy Valiyaveettil
- 377
- 2
- 7
- 22
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,667
- 13
- 39
- 53
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,667
- 13
- 39
- 53
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
- 195
- 1
- 6
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
- 6
2
votes
3 answers
User mapping to a standby database
I have a standby database that is being restored in standby mode using log-shipped transaction files downloaded from a vendor's sFTP site on a daily basis.
Now, I am required to give a read-only access on this database to someone else, outside our…
Lilly
- 41
- 5
2
votes
0 answers
Architecture to scale Postgres read capacity for a limited time each day?
We run a postgreSQL (9.4) server to store data for a web application. Our next feature will require a very data intensive processing on the server requiring a lot of db queries and computation over these data.
As we update our database daily, the…
zrz
- 21
- 1
2
votes
2 answers
Add standby database on different OS version?
Primary database is installed on RHEL 6.1. Standby database software is installed on RHEL 7.0. I am trying to add new standby database by using Grid Control. Database versions are same 11.0.2.0.3.
I was able to add standby database on RHEL 6.1…
babuuz
- 71
- 3
- 10