Alter Database Archivelog Enable

 admin



In this is the article we are going to see Enabling Archive Log Mode In Oracle 19c RAC Database Step:-1 Before Changing the archivelog mode check the status. SQL select logmode,name from v$database. By Ahmed Abdel Fattah This is a quick post about the steps required to enable the ARCHIVELOG mode for an oracle database (Single Instance or RAC) To check if the archive log mode is enabled or not, use the following command: SYS@XPS 01-SEP-18 SQL archive log list.

To enable archivelog mode in RAC perform the below steps.

Step 1) Taket he sqlplus connection and verify the mount state of the RAC DB

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME STATUS
—————- ————
PRDDB1 OPEN
PRDDB2 OPEN

Step 2) check the archivelog mode

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled

Step 3) Add the archive log location to the database

Titanic 2 full movie hindi dubbed download filmyzilla. SQL> alter system set log_archive_dest_1=’LOCATION=+ARCH’ SCOPE=SPFILE SID=’*’;

Step 4) Add the archive log format this is optional step

SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT=’%t_%s_%r.arc’ SCOPE=SPFILE SID=’*’;

Step 5) Stop the DATABASE

[oracle@prddb01 ~]$ srvctl stop database -d PRDDB

Step 6) Start the database in mount stage

[oracle@prddb01 ~]$ srvctl stop database -d PRDDB -o mount

[oracle@prddb01 ~]$ srvctl status database -d PRDDB
Instance PRDDB1 is running on node prddb01
Instance PRDDB2 is running on node prddb02

Step 7) verfiy the db instance state from SQLPLUS

[oracle@prddb01 ~]$ sqlplus sys as sysdba

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME STATUS
————— ————
PRDDB1 MOUNTED
PRDDB2 MOUNTED Usb sound card for dj laptop.

Step 8) Enable Archivemode on DB

SQL> alter database archivelog;

Database altered.

Step 9) Stop and Start the DB.

[oracle@prddb01 ~]$ srvctl stop database -d PRDDB
[oracle@prddb01 ~]$ srvctl start database -d PRDDB
[oracle@prddb01 ~]$ sqlplus ‘/ as sysdba’

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH


****Enable Archive Log Mode***

Please find the below steps required to enable archive log mode on an 11g database.
Verify the database log mode.
[oracle@ngqa ~]$ sqldba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 27 19:01:01 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 25
Current log sequence 27Alter database remove file
SQL>
The log mode is No Archive Mode. Note that Archive destination is USE_DB_RECOVERY_FILE_DEST. You can determine the path by looking at the parameter RECOVERY_FILE_DEST.
SQL> show parameter recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /orabin/ora11gR2/flash_recovery
_areaAlter Database Archivelog Enable
db_recovery_file_dest_size big integer 3852M
SQL>
By default, archive logs will be written to the flash recovery area. If you do not want to write archive logs to the flash recovery area you can set the parameter LOG_ARCHIVE_DEST_n to the location in which you wish to write archive logs.
SQL> alter system set log_archive_dest_1='LOCATION=/oradata/oraarch/MMINDQA/' scope = both;
System altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oradata/oraarch/MMINDQA/
Oldest online log sequence 25
Current log sequence 27
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 511708752 bytes
Database Buffers 331350016 bytes
Redo Buffers 5132288 bytes
Database mounted.
SQL>
Lastly all that is needed it set archive log mode and open the database.

Alter Database Open

SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/oraarch/MMINDQA/
Oldest online log sequence 25
Next log sequence to archive 27
Current log sequence 27
SQL>
We can now see that archive log mode is enabled. Notice that Automatic archive is enabled as well.
You can switch to the log file to see that an archive is written to archive log location.
SQL> alter system switch logfile;
System altered.
SQL> host
[oracle@ngqa ~]$ ls /orabin/oraarch/arch
1_27_711369564.dbf
[oracle@ngqa ~]$ exit
exit

Alter Database Archivelog Enable Command


SQL>

Alter Database Archivelog Compress Enable

***Disable Archive Log Mode***

Note: It is recommended to perform a backup of the database (after a shutdown normal or immediate) prior to changing the archive status of a database.
The following are the steps required to disable archive log mode on an Oracle 10g or 11g database.
Verify the database log mode.
[oracle@ngqa ~]$ sqldba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 27 19:01:01 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/oraarch/MMINDQA/
Oldest online log sequence 26
Next log sequence to archive 28
Current log sequence 28
Mysql alter databaseSQL>
The Database log mode is Archive mode. Next we shut down the database and bring up back up in mount mode.
SQL> shutdown immediate
Database closed.
OracleDatabase dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 511708752 bytes
Database Buffers 331350016 bytes
Redo Buffers 5132288 bytes
Database mounted.
SQL>
All that is left is to disable archive log mode and open the database.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> Mysqlarchive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oradata/oraarch/MMINDQA/
Oldest online log sequence 26
Current log sequence 28
SQL>
As you can see, ARCHIVELOG mode has been disabled.