#archivelog

Disabling ARCHIVELOG mode is usually done in test or development environments where backups and point-in-time recovery are not required. Never disable ARCHIVELOG mode in production databases, because recovery options will be limited. Now let’s start step by step. STEP 1: Check Current Archive Log Mode SQLPLUS / as sysdba ARCHIVE LOG LIST; Example: SQL> archive log list; Database log mode…

#oracledatabase #oracledba #archivedlogs @oracle

-------------------------------------------------------------------------------- -- -- Name: obtain_archlog_from_snc.sql -- Purpose: Find which archlog file a specific SNC is written -- -- Author: Alex Lima -- -- -------------------------------------------------------------------------------- set pages 100 lines 100 col name for a70 col first_change# for 9999999999 col next_change# for…

RMAN-06059: expected archived log not found

Sometimes our RMAN archive log backups hit with following RMAN-06059 error.

sent command to channel: Disk1 Starting backup at 26-JAN-2000 11:04:32 current log archived released channel: Disk1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:…

How to find Archivelog destination?

If archivelog destination is 100% full then backup fails, which can be resolved by moving archivelog files to other location. Each and every database have unique archivelog destination.

The archive log location can be found by below commands. Either the directory name mentioned directly or stored in parameter file.

Scenario 1: IF archive location is mentioned in DB_Recovery

UNIX…

How to enable or disable Archive log mode in Oracle database 11g?

How to enable Archivelog mode in Oracle database 11g Mode of Logging

There are two types of logging modes in Oracle database :-

ARCHIVELOG :- In this type of logging whatever oracle writes in a redo log file related to transactions in database, saved to another location after a log file has been filled . This location is called Archive location. if database is in Archive log mode then in…

Oracle DataGuard and Standby Database Archive Logs

Users see your wonderful DataGuard implementation like this:

Simple Oracle Dataguard Architecture courtesy of https://appsdbatraining.files.wordpress.com

And yet, you know the actual picture looks more like this:

A map of Oracle DataGuard Architecture components

High-availability – the concept behind it makes every DBA shudder because every time it seems you deal with one element and have it…

Oracle Database Express: come abilitare la modalità ARCHIVELOG

Oracle Database Express come abilitare la modalità ARCHIVELOG

se durante il backup dei dati di Oracle Database Express Edition in modalità Shell (prompt dei comandi) avviata attraverso lo script presente nelle applicazioni installate di Oracle Database Express Edition dovesse comaprire il seguente messaggio:

 Warning: Log archiving (ARCHIVELOG mode) is currently disabled. If you restore the…