Questions tagged [standby]
The standby tag has no usage guidance.
60
questions
1
vote
1answer
493 views
Postgres backup PITR strategies [closed]
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 ...
0
votes
1answer
91 views
Dataguard the datafiles are created in another diskgroup
I have a recently made physical dataguard configuration and everything works correctly so far, but I've noticed that the datafiles that are created in the primary are created in the standby in a ...
0
votes
0answers
219 views
Oracle trigger starting services in standby
I'm using Oracle 18.3 with pluggable database and I have an architecture like this:
host 10.0.0.1 has two instances: 1 PRIMARY and 1 STANDBY SYNC
host 10.0.0.2 has one instance: 1 STANDBY ASYNC
I ...
0
votes
1answer
696 views
RMAN Duplication - Oracle Data Guard - Syntax error(s) RMAN-01009 / RMAN-01008 / RMAN-01007
New to DB. Interested in Oracle Data Guard. New working with RMAN.
All of this is for testing only and does not involve any kind of production env.
Making use of ORACLE documentation:
Step by Step ...
1
vote
0answers
198 views
postgresql 10 - standby flips to read/write
I am trying to setup a primary/standby for failover; however, the standby flips to read/write and no longer functions as a replication database after the copy from the primary. Additionally, the ...
0
votes
1answer
166 views
If the standby server is promoted to master, will it work without any replica?
If I have 1 master and 1 standby server, and my master server is down and the standby server is promoted to master. Does my new master work fine without a replica?
Does it act like a standalone server?...
-1
votes
2answers
117 views
RESTORE hourly transaction log to every 10 min interval
I have an hourly transaction log backup running for my production database.
I have to implement the below scenario to check for a deleted data.
I have two tlogs.
tlog1.trn at 10 AM
tlog2.trn at 11 ...
0
votes
1answer
52 views
Wal position to wal archive number
I want to manage the copy of archiving to remote location.
For that I want to delete all the archives I copied unless they are required by the standby.
So, for running pg_archivecleanup $ARCLOC $...
0
votes
1answer
41 views
PostgreSQL recovery file syntax, ver 8 vs ver 9
In postgreSQL version 8.4 it seems that you can place the db server into warm standby mode with the following setting in recovery.conf
restore_command = 'pg_standby archiveDir %f %p %r'
In ...
0
votes
1answer
594 views
PostgreSQL warm standby: sync WAL files
I'm new to PostgreSQL (using ver 8.4.20) and need to setup a master and standby SQL server setup. I am planning to use warm standby setup. I have read the docs on PG and understand the basics, but a ...
2
votes
1answer
4k views
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-...
1
vote
0answers
108 views
RMAN corrupts passwordfile
please, can you clarify this?
My configuration is RAC 12c on ASM on SLES 11 SP 4 on SystemZ.
The nodes rac11 and rac12 are the server nodes of the primary database, named "primdb", uniq_name is "...
0
votes
1answer
2k views
PostgreSQL slave failed after master failure; unable to promote
I just encountered a problem with a PostgreSQL 9.6 warm standby architecture: by mistake, we stopped the master and destroyed its data, so, some tens of minutes later, when we noticed the problem, we ...
0
votes
1answer
1k views
Postgresql failback without resync the data directory
Im using Master slave streaming replication in PostgreSQL. Repmgr is configured to handle automatic failover.
Once the failover happened I need to make the old master as a slave without doing any ...
1
vote
1answer
2k views
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 ...
3
votes
0answers
300 views
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:
...
2
votes
2answers
2k views
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 ...
1
vote
1answer
675 views
What is the standard time delay taken for the data to get reflected in standby database when a new data is inserted in primary database
I've configured Data guard setup using data broker. When I'm inserting new data to the tables in primary database which is suppose to reflect in standby database. When I checked those data's in ...
2
votes
3answers
717 views
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 ...
1
vote
1answer
814 views
Unable to start listener of standby database
As part of data guard configuration, I've installed standby database using Oracle Software only and configured .ora files/folders as required. But while trying to start the listener or check the ...
5
votes
1answer
2k views
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 ...
4
votes
1answer
279 views
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?
0
votes
1answer
327 views
Standby logshipping fails when user is doing read operations on the database
I have a SQLSERVER 2008 instance with a standby configuration using log shipping.
The production server runs a LSBACKUP job every 30 minutes, ships it to the standby server and the standby will then ...
1
vote
1answer
402 views
How real-time apply works in logical standby oracle?
I am a little bit confused about real-time apply services.
I've read a documentation about the services and I still have a question.
Does archived redo logs required for logical standby or not?
I've ...
0
votes
1answer
32 views
Force standby de-synchronisation for script testing
Two databases are configured in a production-standby configuration with Oracle Dataguard.
I want to test a script that supposedly detects whether the dataguard observer is in the status SYNCHRONIZED ...
3
votes
1answer
793 views
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
...
0
votes
0answers
227 views
sqlserver lsalert job does not update it's out-of-sync counter
I am getting 14421 error messages and ended up reading the following KB
Here is the part I'm referring to :
Problems either with the Backup job or Copy job are most likely to
result in "out of ...
2
votes
0answers
109 views
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 ...
0
votes
1answer
1k views
Long queries on PostgreSQL hot standy
Is there a way to convince PostgreSQL to execute long queries on a hot standy?
It kills the query with User query might have needed to see row versions that must be removed. I understand that, but I ...
1
vote
1answer
3k views
Log shipping secondaries in STANDBY stuck in 'Restoring…' - SQL Server 2012 SP3
Yesterday, I configured Log shipping between 2 SQL Server 2012 SP3 servers for a total of 13 databases.
Some specifics:
I'm using 'Azure files' to transfer the log files (CIFS accessible BLOB ...
1
vote
1answer
1k views
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 / ...
1
vote
1answer
2k views
ORA-01031: insufficient privileges connecting to standby
I configured a standby database and it worked for a while, but now I noticed that the redo logs thread on standby is far behind the primary. After researching alert log and trace files, I figured out ...
-1
votes
2answers
2k views
Standby archive deletion
I have a primary database with a standby in data guard configuration running in a RHEL host. Thing is the storage assigned to this DR is very less, meaning the archive logs file system gets full in no-...
1
vote
1answer
2k views
Oracle standby databases monitoring
I have many databases for which I have configured data guard setup. When it comes to monitoring the standby's, I use OEM to check the lag and I have enabled mail alerts as well as and when gap is more ...
1
vote
0answers
487 views
Fail to perfom static registration of nomount instance
I'm trying to make standby to database.
I've insalled Oracle 11g database on virtual machine (host - oratest). Standby is on virtual machine too (standbysrv).
When I'm trying to connect from source ...
8
votes
1answer
3k views
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 ...
0
votes
1answer
412 views
Activating standby DR after opening it in read-write mode
I have a primary and a standby database. Both two node RAC database.
As some testing had to be done in standby database, I had to open it in read-write mode.
I cancelled the recovery in standby and ...
2
votes
2answers
491 views
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 ...
1
vote
2answers
487 views
Oracle standby database recovery stopped
I have a primary and an standby database.
Because my file-system became full in standby database, the recovery has stopped in standby.
This is the present state of sequences in primary and standby:
...
5
votes
2answers
15k views
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 ...
2
votes
1answer
638 views
Differentiating physical standby to cascaded standby
Why is it that for non-real time apply from cascading to cascaded standby that we have to mention as SYNC as the redo transport mode? Ideally we mention SYNC for real time apply right?
Also, should ...
1
vote
0answers
38 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 ...
2
votes
1answer
141 views
Postgres 9.1.16 Hot Standby
I am using PostgreSQL 9.1.16 (and I cannot upgrade) with Hot Standby.
We have a few batches that perform some heavy writes, resulting in a lot of WAL bein produced in a short period of time.
The ...
1
vote
1answer
7k views
Oracle DataGuard: Find primary from standby DB
I have SYS access to a data guard standby DB, but i need to find the primary one. I was searching in Oracle Docs but couldn't find anything that could help.
1
vote
0answers
148 views
Can PostgreSQL with synchronous streaming replication get behind on the WAL logs?
I have 2 Postgres 9.4 servers running on 2 identical VMs that I am using to learn how to setup replication before it gets used in production. Hot standby isn't required but it would be preferred. I ...
1
vote
1answer
790 views
Oracle 11g Sync Standby Database
Currently, I synchronize the standby database from primary database by copying archive logs from primary server to the secondary server. I do this activity daily. I have heard that there are automated ...
0
votes
1answer
482 views
Oracle selective redo log shipping
We are planing to setup an Oracle 12c RAC with a Logical standby in the DR site.
Since data consistency is extremely important, we our planning to setup redo log shipping to be in SYNC mode.
Our ...
2
votes
1answer
1k views
Strange error in trace file for NSAn standby process
One of the Oracle databases I help manage is the primary in a standby configuration, with two standby databases. I started finding repeated entries in the alert log on the primary for a failure to ...
0
votes
1answer
5k views
How to change password of user in physical standby database Oracle 11g?
Hi I am new to Oracle 11g, I have a physical standby database and a primary database of Oracle 11g on two different servers.
I have changed the passwords of users(schemas)like sys, sysman, system, ...
1
vote
0answers
63 views
choosing between the slaves on streaming replication
We are building a new streaming replication setup on postgres 9.3 integrated with pgpool for load balancing and failover, and repmgr for replication business. We have seperate daemons running on all ...
