9
votes
How do I configure AWS Aurora to separate write/read operations
I just wanted to point out that AWS has updated and now have a cluster Read endpoint that does load balancing in case anyone runs into this from Google.
https://aws.amazon.com/blogs/aws/new-reader-...
- 99
6
votes
Accepted
Strategy on Standby restore option for hourly log shipping file
Do I restore each transactional log file as "standby" all the time and just leave them as "standby" mode?
Either will work, but it is faster to apply all the logs except the last ...
- 176
5
votes
Accepted
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 think what you want is real time apply, but for that, you'll have to create standby redo logs on your standby database first. As a side note, to make role transitions easier, it is considered best ...
- 1,153
4
votes
Accepted
Partial (filtered) replication in PostgreSQL
Multiple people suggested using the pglogical extension, which turned out to work really well for this use-case.
- 221
3
votes
Accepted
Strategy for standby reporting with different database versions
The easiest options are to either upgrade the source instance to the same version as the target (or otherwise ensure the database engine versions are compatible), or perform a restore from a full ...
3
votes
Accepted
Error "RMAN-04006: error from auxiliary database" in the middle of duplicate executiion
Your tnsnames.ora entry:
MNTDB19 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = monta19-cluster-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ...
- 40.9k
3
votes
Accepted
Re-map DB Users/Logins after Restore WITH STANDBY
Your users from db on server A will be moved to the database on server B with the backup. Then all you need is to recreate the logins with the same sid. You do this using WITH SID option:
CREATE ...
- 11.1k
3
votes
User mapping to a standby database
If I change the database to online status and created a mapped user to
the database, would that be okay to bring it back to a standby again
and continue the restoring process without hassle?
No, ...
- 42.6k
3
votes
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.
I am required to give a read-only ...
- 2,288
3
votes
Accepted
Ship Standby Logs Without Datafiles
Yes! we can do that.
Which can be observed from the following demo.
I have two hosts Server1(192.168.30.132) and Server2(192.168.30.142) and ORCl database is on Server1.
I skipped some of the ...
- 8,642
3
votes
How to copy “Standby / Read-Only” database from one VM to other VM?
is it even possible?
No, you cannot attach a database in norecovery mode. You can work it around by
creating empty database with the same mdf and ldf files
backup empty database and restore it with ...
- 1,076
2
votes
How to Start DB2 10.5 HADR on the Standby Database
I got the exactly same error message and logs in db2diag.log, what I did to solve this issue is don't do the roll forwarding after the restore, must keep the restored DB in roll forwarding pending ...
- 21
2
votes
Force standby de-synchronisation for script testing
Just disable sending redo to the standby on the primary (replace with actual dest number):
SQL> alter system set log_archive_dest_state_2=defer scope=memory;
To re-enable (replace with actual ...
- 40.9k
2
votes
Accepted
Standby logshipping fails when user is doing read operations on the database
When you use secondary database for query processing, you have to check
database users disconnected when transaction log backups are being restored.
- 62.4k
2
votes
User mapping to a standby database
You should create a login on your primary, create a corresponding user in log shipped database and wait until this user "flows" on your secondary, at this point you can drop the login on primary.
If ...
- 11.1k
2
votes
Accepted
RESTORE hourly transaction log to every 10 min interval
You should be able to code up a series of restore logs (with standby) and specify the STOPAT with 10 minute increments
--Full database restore with standby
USE master
GO
RESTORE DATABASE [StandbyTest]...
- 23.9k
2
votes
Strategy for standby reporting with different database versions
Jonathan Kehayias' article Database Version vs Database Compatibility Level brings some interesting info related to that error message:
When a database is opened for the first time on a newer version ...
- 5,791
1
vote
in PostgreSQL REPMGR Master-Slave environment is it necessary to have same H/W config for HOT STANDBY setup?
There are only a few settings that must not be lower on the standby than on the primary:
max_connections
max_worker_processes
max_wal_senders
max_prepared_transactions
max_locks_per_transaction
...
- 54.8k
1
vote
PostgreSQL 12 dropped replication slot but standby is still trying to contact the primary
Hey I solved this myself. The problem was that the data directory was not in the expected location and we removed/checked the standby.signal file from the wrong location. Using SHOW data_directory; ...
- 151
1
vote
Data Guard 12.2 without Force Logging
Maybe you missed this part from the referenced note:
This command fetches the required blocks from Primary.
Meaning if you have to perform a failover becasue the primary becomes inaccesible, this ...
- 40.9k
1
vote
Problem connection to a standby database during the create proccess
The error was in the service used in tnsnames.
- 95
1
vote
Accepted
Postgres backup PITR strategies
There are many possibities!
PITR vs STANDBY
PITR & Standby are complementary solutions:
Standby is interesting to recover from:
physical problem: server crash, datacenter unavailabity
and ...
- 213
1
vote
If the standby server is promoted to master, will it work without any replica?
Definitely, Your new primary will act like a standalone. If your configuration file is good, you'll even be able to add the old-primary as a new secondary without any restart.
Just be sure your old ...
- 1,580
1
vote
PostgreSQL recovery file syntax, ver 8 vs ver 9
One benefit of the new syntax is that your restore_command doesn't need to implement its own polling for newly arrived log files, and doesn't have to check for failover triggering, because the core ...
- 40.6k
1
vote
PostgreSQL warm standby: sync WAL files
If you use log shipping, then the archive_command on the master and the restore_command on the replica are responsible for copying the logs. The contents of those commands is up to you. You can use ...
- 40.6k
1
vote
unable to start the standby postgres database
You should not have started the database and then stopped it before creating the recovery.conf file. Once you start the database without a recovery.conf, it opens for write usage, or tries to, and ...
- 40.6k
1
vote
Accepted
Postgresql failback without resync the data directory
Fundamentally, you can't without some kind of reset of the old master. Unless the old master is shut down before the new master is promoted and you ensure all WAL is synced from old to new master, the ...
- 57k
1
vote
Unable to start listener of standby database
Here are the steps I follow when creating a standby for a dataguard environment on windows server, please confirm in comments at which step you currently are to help identify your issue here.
(prd1 is ...
- 1,364
1
vote
Accepted
How real-time apply works in logical standby oracle?
Does archived redo logs required for logical standby or not?
Yes, it does.
https://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ls.htm#g105412
The archived redo logs (archivelogs, ...
- 600
Only top scored, non community-wiki answers of a minimum length are eligible