Questions tagged [archive-log]
The archive-log tag has no usage guidance.
33
questions
1
vote
1
answer
39
views
Why does PostgreSQL want max_wal_senders equal to 0 and greater than 0 at the same time?
We're running a backup process based on pg_basebackup of a Postgres 14.5 database that creates a lot of WAL archive files and using up huge amounts of disk space. As we don't really need the WAL ...
- 113
0
votes
0
answers
25
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 ...
0
votes
1
answer
695
views
understanding pg_wal and archiving
So I inherited this database. At the very beginning, there were already some files on pg_wal.
Then, after some weeks, I do count SELECT COUNT(*) FROM pg_ls_dir('pg_wal') WHERE pg_ls_dir ~ '^[0-9A-F]{...
- 157
0
votes
0
answers
420
views
Postgres archiving not running
I am using logical replication. Currently I am using stored procedure to pump 3K data per hour to see if the WAL files increase. It does increase by 1 file every 12k records. But the WAL archiving is ...
- 157
0
votes
3
answers
1k
views
Is it possible to show all modifications, done at one particular table entry in MS-SQL?
I'm working on an application, which uses different DLLs, each of them doing something on an MS-SQL database. After a while, some entries in the database don't look as I would want them, and I would ...
- 523
7
votes
2
answers
2k
views
When did this SQL request yield results?
I'm working on an SQL server database, containing orders and machines, executing those orders. Not more than one active order can be assigned to a machine at the same time. In other words: this SQL ...
- 523
0
votes
1
answer
3k
views
How do I stop WAL streaming in BARMAN cron?
I am having an issue "resetting" or fixing a backup server I have in BARMAN:
-bash-4.2$ barman check *server-name*
Server *server-name*:
PostgreSQL: OK
superuser or standard ...
0
votes
1
answer
249
views
Changed DB_RECOVERY_FILE_DEST path, but RMAN still backs up to the old path?
I just recently changed the DB_RECOVERY_FILE_DEST parameter to point to a new directory path. However, I noticed only some archivelogs and backup sets are going to this new directory path and some are ...
- 11
0
votes
0
answers
181
views
RMAN archive logs are no longer automatically being generated?
To preface... I have mentioned this before in a previous question, but I'll add it again: Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just ...
- 11
0
votes
1
answer
340
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 ...
- 21
0
votes
2
answers
222
views
Flash Area Full - Actions
I have seen some recommendations in the Oracle Docs about what to do if the FRA is full.
For example I have this config also:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
...
0
votes
1
answer
184
views
PostgreSQL 9.6, Disable archive log or minimal archive log size when do a pg_restore
I have a production DB PostgreSQL 9.6 that is on master/standby structure. Every at 1 AM I restore a few huge tables(from the other DB server) to the master node during restore till finished the ...
- 109
0
votes
1
answer
100
views
Enable archivelog
I'm trying to enable archivelog mode in Oracle database. For that I shutdown the services and used startup mount. Instead of database getting mounted, I'm getting error ORA- 12528 TNS - All instances ...
3
votes
1
answer
1k
views
multiple archive_command in PostgreSQL
I have replication with PostgreSQL, so I want to set archive_command = 'cp %p /var/lib/postgresql/11/main/archive/%f' but I also want to save WAL files to another safe place: S3.
So is it possible to ...
- 149
5
votes
3
answers
5k
views
Does Postgres automatically rotate WAL files out (pg_xlog) if archive_mode is off?
I'm relatively new to PostgreSQL administration and I'm attempting to pick up the nitty gritty details as I go. My question is, assuming I have no need for disaster recovery and I don't turn on ...
- 153
2
votes
1
answer
8k
views
archive command repeatly failing for one particular file
I am seeing many pg_log files full of following errors
2019-07-08 00:04:06 CEST DETAIL: The failed archive command was: copy "pg_xlog\000000010000002100000025" "D:/Programme/OmniBack/server/db80/pg/...
- 145
0
votes
1
answer
305
views
resuming server replication on PostgreSQL servers
I got one main server and other two servers are replicating from the main.
I got full disk space on the main server (I have an archive_command that put wal archives into the /wal_archive/ directory).
...
- 59
0
votes
0
answers
331
views
Restore database using old control file
Our environment has a full daily DB backup system, including the control file at 11 pm.
We had a case to restore the database in different environments but with maximum data to recover. Archivelogs ...
- 1
0
votes
1
answer
80
views
Dealing with Oracle ARCHIVELOG during huge updates
It's required to update columns with metadata globally in all rows of all tables in DB. Let's say every table has a column MY_META and the aim is roughly
update ANOTHER_TABLE set MY_META = 'HELLO'
...
- 131
1
vote
0
answers
134
views
How to keep only those archivelogs that are created after a latest db backup in oracle 11g?
I am little confused with oracle db backup.
I have configured my Oracle 11G DB with ARCHIVELOG in Fast Recovery Area (NFS mount).
I only need latest backup to restore in case of failure, but no point-...
- 145
0
votes
1
answer
2k
views
Oracle 11g database archive log got increased suddenly in production server
My production db archivelog got increased suddenly one night. Around 200 MB of archivelog were generating in FRA within a minute. It got into normal condition after 15 hours from the start of this ...
2
votes
1
answer
16k
views
clean flash recovery area archive logs
I have an Oracle 11g on RHEL server. My /oradata volume reach 95% disk usage :
[ora11g@bocc7-1-qrec-01 ~]$ df -h
/dev/sdb1 689G 571G 84G 95% /oradata
The Flash Recovery Area (FRA) ...
- 123
2
votes
2
answers
2k
views
Unable to start oracle database after trying to enable archive log mode on
I am facing this unusual issue. I wanted to enable archive log mode from noarchivelog mode and used alter command for the same as ALTER SYSTEM SET log_archive_dest='LOCATION=D:\Oracle\Redo Log ...
1
vote
1
answer
251
views
File creation dates of archived WAL files not in line with archive_timeout in PostgreSQL 9.6
I have configured archive_timeout = 5 (i.e. 5 seconds) for a PostgreSQL 9.6 database in order to conduct tests around point-in-time recovery. My archive_command invokes cp into a local archive ...
- 348
0
votes
3
answers
22k
views
How can I use RMAN to show if there are archive logs that need to backed up?
My main concern is knowing if the Oracle Archive Logs haven't been backed up in a while because something is broken that I may not know about.
When I query v$log it appears to be good with First_Time ...
- 552
1
vote
1
answer
3k
views
Changing Fast Recovery Area destination
My database is running in archive log mode, but flashback is disabled because I do not need it.
The FRA is set to /flasharch mount point.
Now, I am going to change the FRA location to /flasharch01 ...
- 69
1
vote
2
answers
4k
views
Old archivelog files present on disk, but not in RMAN
I recently spotted 3 very old archivelog directories on disk that do not appear within RMAN.
[oracle@ORACLE01 archivelog]$ du -sh *
122M 2017_02_25
4.9G 2017_02_26
2.5G 2017_02_27
1.6G ...
- 135
9
votes
1
answer
13k
views
postgres: what is the archive_command and when to use it
I have a master/slave postgresql configuration where the slave is a hot standby and is used as a readonly backup. Currently, the archive_command is set to "cd ." (a noop as I've read). My ...
- 193
3
votes
3
answers
3k
views
Why are my backups using so much space? ORA-19804
I had a backup job that was failing like this:
RMAN-03002: failure of backup plus archivelog command at 10/20/2016 01:16:23
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim ...
user41720
1
vote
1
answer
6k
views
Understanding Oracle "LOG_ARCHIVE_START" parameter
I've enabled ARCHIVELOG mode on a Oracle 12c multitenant instance:
SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;
LOG_MODE
------------
ARCHIVELOG
I understand that REDOLOGS are correctly archived by ...
- 337
0
votes
1
answer
6k
views
Difference between Archive destination & db_recovery_file_dest
What is exact difference between Archive destination & db_recovery_file_dest on Oracle Database?
SQL> show parameter reco
NAME TYPE VALUE
---------------...
- 55
1
vote
1
answer
12k
views
Oracle USE_DB_RECOVERY_FILE_DEST filesystem path
As stated in oracle doc
The keyword USE_DB_RECOVERY_FILE_DEST to indicate the Fast Recovery Area
I know it's setted during dbca but how can identify the Fast Recovery Area filesystem path on ...
- 337
6
votes
1
answer
7k
views
ARCHIVELOG in Oracle 12c multitenant PDB
In a Oracle 12c multitenant DB instance with multiple PDBs, is it possible to enable ARCHIVELOG mode on a single PDB?
- 337