Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [standby]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
25 views

WAL file lifecycle and standby promotion

I'm encountering difficulties automating Postgres 12 standby promotion. I've noticed that Postgres typically writes and archives a .partial WAL (Write-Ahead Log) file upon promotion, but there's one ...
Roberto Iglesias's user avatar
0 votes
0 answers
29 views

Issues with v$archived_log - Oracle 19c

I have a standby database, on which I executed the command: alter database recover managed standby database cancel and it was executed successfully - The complication I am facing is: When I execute: ...
datascinalyst's user avatar
0 votes
1 answer
46 views

How to recover the standby database after opening

If I have standby which is db role is PHYSICAL STANDBY and it is MOUNTED. So, when I open it read/write the standby will be destroyed. (I have DataGuard) So, basically do I need to mount it again and ...
paganini's user avatar
  • 118
0 votes
0 answers
51 views

Performance issues after activating second remote Data Guard

I have a primary database that has two remote data guard. Second data guard was configured for a DC migration on new DC. Second remote data guard was installed on the same DC (and subnet) with primary ...
skalkanci's user avatar
0 votes
1 answer
184 views

What could be the cause of the ORA-12638 error when setting up Oracle Data Guard?

I'm configuring Oracle Data Guard and I'm experiencing ORA-12638. I have the Oracle 19c database on a Windows Server 2019. In the DR site, I can connect to the primary with no problem. But connecting ...
Poco Ocop's user avatar
-1 votes
1 answer
1k views

I want to change the location of redo files on standby db

my db is generating redofiles to a certain path, lets call it 'old/path', and i want to move it to a new path, lets call it 'new/path' in oracle can somebody help?
dbafix's user avatar
  • 62
0 votes
2 answers
259 views

PostgreSQL 12 streaming replication standbys timing out due to autovacuum tasks

We have PostgreSQL 12.9 running on Ubuntu 20.04.3 LTS in a streaming replication setup with 1 primary and 3 standbys where the following options have been configured on all servers: hot_standby=on ...
Diane's user avatar
  • 151
6 votes
0 answers
276 views

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 ...
Nils's user avatar
  • 149
0 votes
1 answer
414 views

Oracle Data Guard - Wrong Path with new created Data Files

I've created a Standby Database with the following duplicate command: run { duplicate target database for standby from active database spfile parameter_value_convert 'ORCL','ORCLSTBY' set db_name='...
msak85's user avatar
  • 3
0 votes
2 answers
176 views

in PostgreSQL REPMGR Master-Slave environment is it necessary to have same H/W config for HOT STANDBY setup?

I have a PostgreSQL repmgr Master-Slave setup with HOT standby enabled. In such repmgr configuration isnt it possible to configure the postgresql.conf in Primary and secondary DIFFERENTLY WHILE HOT ...
fahad_dba's user avatar
0 votes
1 answer
4k views

PostgreSQL 12 dropped replication slot but standby is still trying to contact the primary

We have recently decommissioned a standby that was experiencing some hardware issues from our streaming replication cluster. We were able to successfully stop the PID on the primary and then drop the ...
Diane's user avatar
  • 151
0 votes
0 answers
132 views

Sql Error Message ID 3013 & 4305 for Standby / Read-Only database that we use for import data heavily

Sorry. I am not a DBA, but a SQL Developer, so I am trying to get some general support/feedback on my case (and when I Googled the issue, remedy seems so scattered so I decided to post here). I got ...
Java's user avatar
  • 233
0 votes
1 answer
155 views

Enabling standby node Wal streaming without pg_basebackup

So currently i'm planning to do a migration to RDS where i'm using a snapshot of our master and doing a pg_upgrade on a new machine(reasons being so that if the upgrade fails for whatever reason, we ...
Apprentice Programmer's user avatar
0 votes
1 answer
852 views

Data Guard 12.2 without Force Logging

I would like to know your opinion and experience in a specific setup I want to apply to a Production Database that is configured in Oracle Data Guard with one Standby. It is not an active data guard ...
Roberto Hernandez's user avatar
2 votes
1 answer
2k views

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 ...
Java's user avatar
  • 233
1 vote
2 answers
355 views

Strategy for standby reporting with different database versions

I am trying to come up with solution for restoring database with one full backup file and then with hourly transaction logs that are going to be created each hour thru FTP site. So, here is a scenario....
Java's user avatar
  • 233
0 votes
1 answer
428 views

Archive logs Pg_archive cleaner

I have Postgres installed on windows 10. I have master-slave replication ( 1 pc is master and 2 other pc are slaves). I have archive logs saved on a file on master pc and slaves are connected to that ...
Anisa Ibro's user avatar
1 vote
0 answers
109 views

TDE error when attempting to encrypt a datafile

I'm encountering error ORA-28374: typed master key not found in wallet when attempting to run alter database datafile '+DATA/testdb/datafile/users.2514.1233355332' encrypt; against an 11g database ...
Franco's user avatar
  • 51
0 votes
0 answers
1k views

Oracle 19c with SAP System - ORA-12154: TNS:could not resolve the connect identifier specified For Physical Standby

Oracle 19c + SAP system. On primary side I have a problem when transporting logs to Data Guard side. Outputs from primary side: SQL> select status, error from v$archive_dest where dest_id=2; ...
jrdba123's user avatar
1 vote
1 answer
14k views

Error "RMAN-04006: error from auxiliary database" in the middle of duplicate executiion

I'm trying to create a standby database with duplicate command. Primary : tntdb19 Standby : mntdb19 The duplicate command begins but fails after some time [oracle@monta191 admin]$ rman target sys/...
estonolose's user avatar
0 votes
1 answer
405 views

Problem connection to a standby database during the create proccess [closed]

I'm trying to install an Oracle Standby Database 19c. I have a Rac Database 19c and now I'm with the firsts steps to create de standby. I have in nomount state the standby database SQL> startup ...
estonolose's user avatar
0 votes
0 answers
161 views

path on ASM for standby database after switchover

The question is quite complicated for me to describe so please be patient and ask for more details of needed. I have a primary database (ABC) and a standby one (STBABC). Both are located on ASM. For ...
user3863616's user avatar
2 votes
1 answer
929 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 ...
Shiwangini's user avatar
0 votes
1 answer
511 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 ...
Arnaldo Raxach's user avatar
0 votes
1 answer
5k 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 ...
Iris Catharina's user avatar
1 vote
0 answers
638 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 ...
thePetester's user avatar
0 votes
1 answer
763 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?...
vyshu Ysh's user avatar
-1 votes
2 answers
250 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 ...
user9516827's user avatar
  • 1,315
0 votes
2 answers
187 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 $...
Nir's user avatar
  • 533
0 votes
1 answer
57 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 ...
TSG's user avatar
  • 183
0 votes
1 answer
1k 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 ...
TSG's user avatar
  • 183
3 votes
1 answer
7k 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-...
Kim Stacks's user avatar
1 vote
0 answers
153 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 "...
Isaac's user avatar
  • 21
0 votes
1 answer
4k 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 ...
Penegal's user avatar
0 votes
1 answer
2k 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 ...
TheDataGuy's user avatar
  • 1,950
2 votes
1 answer
5k 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 ...
TheDataGuy's user avatar
  • 1,950
3 votes
0 answers
507 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: ...
Enthusiastic learner's user avatar
2 votes
2 answers
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 ...
iKnowNothing's user avatar
1 vote
1 answer
1k 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 ...
Enthusiastic learner's user avatar
2 votes
3 answers
2k 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 ...
Lilly's user avatar
  • 41
1 vote
1 answer
1k 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 ...
akr's user avatar
  • 141
7 votes
1 answer
4k 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 ...
jeancochrane's user avatar
4 votes
1 answer
393 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?
Leigh Riffel's user avatar
  • 23.9k
0 votes
1 answer
582 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 ...
A_V's user avatar
  • 1,364
1 vote
1 answer
584 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 ...
kozlone's user avatar
  • 31
0 votes
1 answer
46 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 ...
A_V's user avatar
  • 1,364
3 votes
1 answer
1k 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 ...
kupa's user avatar
  • 1,707
2 votes
0 answers
134 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 ...
zrz's user avatar
  • 121
0 votes
1 answer
2k 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 ...
Yves Dorfsman's user avatar
1 vote
1 answer
4k 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 ...
H. Lowette's user avatar