Where can I find the archive log?

Asked By: Virgie Buch | Last Updated: 7th April, 2020
Category: technology and computing databases
4.6/5 (151 Views . 39 Votes)
The following commands can be used to locate the Oracle archive logs:
  • Issue the archive log list command: SQL> archive log list.
  • Issue the show parameter command: SQL> show parameter db_recovery_file_dest.
  • Query the v$archive_dest view: SQL> select dest_name, status, destination from v$archive_dest;

Click to see full answer


Hereof, where are Oracle archive logs stored?

To get started, from the last article, remember that Oracle placed archive logs in a default directory of $ORACLE_HOME/dbs and, if flash recovery was enabled during installation, in the USE_DB_RECOVERY_FILE_DEST, which equated to the init. ora parameter db_recovery_file_dest.

Beside above, what is the difference between redo log and archive log? Archive logs are archived redo(online) log files. In redo log files are all changes that happened to your data. If your database is in archivelog mode, than redo logs can't be overwritten, they are archived in some other location when they are full. Redo and archive logs are used in various database recovery scenarios.

One may also ask, what is archive log?

Oracle Database lets you save filled groups of redo log files to one or more offline destinations, known collectively as the archived redo log, or more simply the archive log. The process of turning redo log files into archived redo log files is called archiving.

What if archive log destination is full?

What happens if a archive log destination is filled up in oracle. log destination disk space becomes full, the automatic archiving will stop. When this happens we will get errors like ORA-00257. ORA-00257: archiver error.

34 Related Question Answers Found

How do I delete old archive logs in RMAN?

In order to delete them you can do: RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; , you can also include the delete input clause when you back them up, and they will be deleted after they have been backed up (it is up to you).

What is archive log mode in Oracle?

ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. NOARCHIVELOG mode is basically the absence of ARCHIVELOG mode and has the disadvantage of not being able to recover to any point in time.

What is redo logs in Oracle?

Redo Logs consist of two or more pre-allocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has associated online redo logs to protect the database in case of an instance failure. Redo log files are filled with redo records.

How do I change the archive log destination?

Change Archivelog Destination In Oracle
  1. Description:-
  2. Step:-1 Check archivelog location before change.
  3. Check Current Archivelog Location:
  4. SQL> archive log list. Database log mode Archive Mode.
  5. Step:-2 Change archivelog location.
  6. Note:- 1st set the FRA value before changing.
  7. Step:-3 Check the status of archivelog location.
  8. SQL> archive log list.

How do I know if archive logs are applied to standby database?


  1. Step 1 : Check the status of database on both server.
  2. Step 2 : Check for GAP on Standby.
  3. Step 3 & 4: Check redo received and applied on standby.
  4. Step 5: Identify the missing archive log file.
  5. Step 6: Copy missing archive log file.
  6. Step 7: Register archive logfile with standby.

How do I list archive logs in RMAN?

RMAN List Command
  1. Database. The LIST command allows the backup data to be listed in the RMAN utility.
  2. Archive Logs. To list all archive logs use: RMAN> LIST ARCHIVELOG ALL;
  3. Backup sets. To list the contents of an individual backup set use: RMAN> LIST BACKUPSET <key>;
  4. Datafile Image Copies.
  5. Controlfile Image Copies.
  6. Tablespaces.
  7. Incarnations.

How do I read a redo log in Oracle?

LogMiner retrieves information from those redo log files and returns it through the V$LOGMNR_CONTENTS view. You can then use SQL to query the V$LOGMNR_CONTENTS view, as you would any other view. Each select operation that you perform against the V$LOGMNR_CONTENTS view causes the redo log files to be read sequentially.

What is password file in Oracle?

Oracle password file stores passwords for users with administrative privileges. Any OS user under dba group, can login as SYSDBA. Password file for an Oracle database is called a database password file, and the password file for Oracle ASM is called an Oracle ASM password file.

How do I view archive log mode?

Checking ARCHIVELOG mode status
  1. Log in as OS user oracle and enter the following commands: $ export ORACLE_SID=<MYDB> where <MYDB> is the name of the database $ sqlplus /nolog SQL> connect / as sysdba.
  2. To check the ARCHIVELOG mode status, enter the following SQL command: SQL> archive log list;

What archive means?


A. The Gmail app for Android gives its users two choices for discarding a new message: archive or delete. The Archive action removes the message from view in the inbox and puts it in the All Mail area, in case you ever need it again.

What is the difference between Archivelog mode and Noarchivelog mode?

ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. NOARCHIVELOG mode is basically the absence of ARCHIVELOG mode and has the disadvantage of not being able to recover to any point in time.

What is online redo log?

The most crucial structure for recovery operations is the online redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle database has an associated online redo log to protect the database in case of an instance failure.

How do I turn off archive?

Disable an archive mailbox
  1. Go to Recipients > Mailboxes.
  2. Select a mailbox.
  3. In the details pane, under In-Place Archive, click Disable. Note: You can also bulk-disable archives by selecting multiple mailboxes (use the Shift or Ctrl keys). After selecting multiple mailboxes, in the details pane, click More options.

How do I add database to Archivelog mode?

Putting the database in ARCHIVELOG Mode
Once you have shutdown the database, you will start the database in mount mode with the startup mount command. Then put the database in ARCHIVELOG mode, and finally open the database.

What are RMAN backups?


Installed with the database, Recovery Manager (RMAN) is an Oracle database client which performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering the database. This is the database to be backed up by RMAN.

What are Oracle control files?

Every Oracle database has a control file. A control file is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files. The timestamp of the database creation.

How do you change from Noarchivelog mode to Archivelog mode?

Step to change database from Archivelog mode to Noarchivelog mode
  1. Login by OS User (For windows as Administrator)
  2. Set ORACLE_SID to connect to required database.
  3. Login to Oracle by SYS as SYSDBA.
  4. Confirm connected database.
  5. Check current log_mode i.e. (Archivelog or Noarchivelog) of database (Before change) {output should be ARCHIVELOG}.
  6. Check current archive status.
  7. Shutdown database.