Disable database in NOARCHIVELOG mode in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 13th, 2018
Disable database in NOARCHIVELOG mode in Oracle database 11gR2
Check the database Instance Name & Version
sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME VERSION ---------------- ---------- testdb 11.2.0.4.0
Check the status of the database in archive mode or not
sys@TESTDB> select log_mode from V$database; LOG_MODE ----------- ARCHIVELOG
Shutdown the database
sys@TESTDB>shu immediate Database closed. Database dismounted. ORACLE instance shut down.
Comment the below parameters in parameter file by putting ” # ” .
(vi $ORACLE_HOME/dbs/inittestdb.ora)
#*.log_archive_format=’%t_%s_%r.arc’
#*.log_archive_dest_1=’location=/u01/app/oracle/oradata/archive’
If case you want you can specify second destination, assign below given loc
#log_archive_dest_2=’location=/u02/oradata/archive’
Startup database in mount mode
sys@TESTDB>startup mount ORACLE instance started. Total System Global Area 2455228416 bytes Fixed Size 2255712 bytes Variable Size 771753120 bytes Database Buffers 1660944384 bytes Redo Buffers 20275200 bytes Database mounted.
Set the database in Noarchivelog
sys@TESTDB>alter database noarchivelog; Database altered.
Open the database
sys@TESTDB>alter database open; Database altered.
Verify:
sys@TESTDB>select log_mode from V$database; LOG_MODE ------------ NOARCHIVELOG