Questions tagged [archive-log]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
49 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/...
0
votes
1answer
12 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). ...
0
votes
0answers
104 views

Can I to clear v$archived_log where name is null?

I have noticed that when I exclude some archivelogs with rman the view v$archived_log still keep the registers and when I gonna restore I receive this errors: RMAN-00571: =============================...
0
votes
0answers
94 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 ...
0
votes
1answer
43 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' ...
1
vote
0answers
62 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-...
0
votes
1answer
442 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 ...
1
vote
1answer
5k 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) ...
2
votes
2answers
678 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
1answer
42 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 ...
0
votes
3answers
7k 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 ...
1
vote
1answer
2k 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 ...
1
vote
2answers
2k 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 ...
2
votes
1answer
4k 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 ...
2
votes
3answers
2k 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 ...
1
vote
1answer
3k 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 ...
0
votes
1answer
2k 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 ---------------...
1
vote
1answer
2k 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 ...
5
votes
1answer
3k 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?