Check the Status of Archive mode in Oracle

Check the location or Status of the archive log in Oracle

Check the Status of the Archive mode is on or off in Oracle

Select NAME, LOG_MODE from V$DATABASE

NAME     LOG_MODE
----     -----------
ORCL     NOARCHIVELOG

Note:
NOARCHIVELOG means its disable or off.
ARCHIVELOG means its enable or on.

Check the location and status of the archive log in Oracle

SQL> Archive log list;

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     22
Next log sequence to archive   24
Current log sequence           24

Note: It show enabled or Disabled , with archive destination.

Check the location with the following parameters also:
LOG_ARCHIVE_DEST: Destination of archive files.
LOG_ARCHIVE_FORMAT: Define the format or naming convention of archive files.

SQL> Show parameter LOG_ARCHIVE_DEST

On or Off the archive mode for Oracle

1. Shutdown the database
Shutdown immediate;

2. Start the database in mount state:
startup mount

3. On or Off the archive mode, choose one of the following commands:
-- For enable or on
alter database archivelog;
--For disable or off
alter database noarchivelog;

4. Open the Database.
alter database open;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.