Author Archives: SandeepSingh DBA

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

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;