Disable archive logs

  • Before executing check whether HA is deploye and take necessary precautions (cluster freeze).
  • Consider impact on backup of the DB, full backup is required to restore data.
  • Data changes between full backups will be lost in case of restore

oracle@hostname:/oracle > sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on Mon Feb 6 01:36:08 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options

SQL> set line 9090
SQL> SHOW USER
USER is „SYS“

Step -1)
Check the Existing mode in your Database
SQL> SELECT LOG_MODE FROM V$DATABASE;

LOG_MODE
————
ARCHIVELOG

Step -2)
Shut Down Your Database Cleanly to Disable Archiving Mode .
SQL> SHUT IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.

Step -3)
Start up Your Database in Mount Stage .
SQL> STARTUP MOUNT;
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                  1250380 bytes
Variable Size             281021364 bytes
Database Buffers          314572800 bytes
Redo Buffers                7135232 bytes
Database mounted.

Step -4)
SQL> ALTER DATABASE NOARCHIVELOG;
Database altered.
SQL> ALTER DATABASE OPEN;

Database altered.

 

Jan D.
Jan D.

"The only real security that a man will have in this world is a reserve of knowledge, experience, and ability."

Articles: 672

Leave a Reply

Vaše e-mailová adresa nebude zveřejněna. Vyžadované informace jsou označeny *