Principal › Blogs › mario's blog ›

Activar/Desactivar ARCHIVELOG en Oracle

Submitted by mario on Mié, 09/10/2008 - 8:06am
en

Son tres pasos:

  • Bajar la base de datos
  • Montar la base de datos
  • Desactivar archive logs
  • Abrir la base de datos

    • Conectarse como sys


    $ sqlplus '/ as sysdba'

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 10 08:00:48 2008

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    SQL>

    Para desactivar:


    shutdown immediate;

    startup mount;

    alter database noarchivelog;

    select log_mode from v$database;

    alter database open;

    exit;

    Para (re)activar:


    alter database archivelog;