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

Questions tagged [archive-log]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
28 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
96 views

RMAN: restore not done; all files read only, offline, excluded, or already restored

I did a hot RMAN backup of a server running Oracle 19c database, then moved the backup to a new server. This is the backupscript BACKUP AS compressed BACKUPSET INCREMENTAL LEVEL=0 FORMAT '...
datascinalyst's user avatar
0 votes
0 answers
80 views

Querying V$ARCHIVE_DEST_STATUS

-- Oracle 19c when querying v$ARCHIVE_DEST_STATUS, I get the following output: SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#,APPLIED_SEQ#,APPLIED_THREAD# FROM V$ARCHIVE_DEST_STATUS ...
datascinalyst's user avatar
0 votes
1 answer
56 views

Problem in Oracle 19c Replication

Replication is working fine on the other servers, however on DB_B there's some problem; It is unable to receive archives. Can someone help me out? If I have missed any parameters, please do let me ...
datascinalyst's user avatar
2 votes
1 answer
418 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 ...
dokaspar's user avatar
  • 123
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
1k 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]{...
padjee's user avatar
  • 187
0 votes
0 answers
615 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 ...
padjee's user avatar
  • 187
0 votes
3 answers
2k 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 ...
Dominique's user avatar
  • 521
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 ...
Dominique's user avatar
  • 521
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 ...
Troy Meyerink's user avatar
0 votes
1 answer
476 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 ...
Phillip's user avatar
  • 11
0 votes
0 answers
305 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 ...
Phillip's user avatar
  • 11
0 votes
1 answer
424 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
0 votes
2 answers
258 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'; ...
ultimo_frogman's user avatar
0 votes
1 answer
221 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 ...
BongSey's user avatar
  • 119
0 votes
1 answer
106 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 ...
Vinodkumar Madhavan's user avatar
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 ...
raring-coffee20's user avatar
5 votes
3 answers
6k 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 ...
kaizenCoder's user avatar
2 votes
1 answer
10k 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/...
Neeraj Bansal's user avatar
0 votes
1 answer
338 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). ...
Gumuliokas's user avatar
0 votes
0 answers
352 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 ...
Patricio's user avatar
0 votes
1 answer
81 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' ...
diziaq's user avatar
  • 131
1 vote
0 answers
148 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-...
GP92's user avatar
  • 155
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 ...
Enthusiastic learner's user avatar
2 votes
1 answer
18k 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) ...
Rachid B.'s user avatar
  • 123
2 votes
2 answers
3k 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 ...
Ashish Virmani's user avatar
1 vote
1 answer
294 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 ...
rookie099's user avatar
  • 358
0 votes
5 answers
26k 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 ...
johnny's user avatar
  • 602
1 vote
1 answer
4k 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 ...
Rahman Khost's user avatar
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 ...
Dave Smylie's user avatar
9 votes
1 answer
14k 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 ...
Joe J's user avatar
  • 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 ...
user avatar
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 ...
sgargel's user avatar
  • 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 ---------------...
azardin's user avatar
  • 55
1 vote
1 answer
14k 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 ...
sgargel's user avatar
  • 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?
sgargel's user avatar
  • 337