Forgot your password?    
+ Reply to Thread
Results 1 to 4 of 4

Thread: Changing the Archivelog Mode on 9i and earlier

  1. #1
    Oracle DBA
    Join Date
    Oct 2011
    Location
    Noida
    Posts
    4

    Changing the Archivelog Mode on 9i and earlier

    Databases are by default created in NOARCHIVELOG mode. After you build the database, create the application tablespaces, and load the initial data, you should put the database in ARCHIVELOG mode.

    To put a database into ARCHIVELOG mode, do the following:

    1. Shutdown the database
    SQL> SHUTDOWN IMMEDIATE

    2. Edit the initSID.ora file to contain the following values:
    log_archive_start = true
    (start the ARCH process automatically)
    log_archive_dest = “/u01/oracle/admin/dev1/arch”
    (define the archive dump destination)
    log_archive_format = arch_dev1_%t_%s.arc
    (define the naming format of each dump file)

    3. Start up the database in mount mode
    SQL> startup mount
    ORACLE instance started.

    4. Put the database in ARCHIVELOG mode.
    SQL> alter database archivelog;
    Database altered.

    To verify the status of the database.

    SQL> archive log list;
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination /u01/oracle/admin/dev1/arch
    Oldest online log sequence 37
    Next log sequence to archive 39
    Current log sequence 39

    Now open the database for normal use :
    SQL> alter database open;
    Database altered.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Thanks you Sandeep for the valuable information.
    Regards,
    -Amit

  3. #3
    Oracle Administrator
    Join Date
    Dec 2011
    Posts
    92
    Hi Sandeep your article is brilliant.
    The "log_archive_start" parameter has been deprecated.

    So if you are working on a pre 10g release database its ok but from 10g (10.1) onwards this parameter is not required.
    Last edited by Hemant; 01-11-2012 at 01:15 AM.

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    For Additional details on Archivelog and Noarchivelog modes , refer to this post : Achivelog Mode vs No Archivelog Mode

+ Reply to Thread

Similar Threads

  1. Archivelog Mode On RAC
    By devesh_ocp in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 04-25-2012, 03:28 PM
  2. Changing the DBID - DBNEWID utility
    By Sandeep Sharma in forum Core Database Administration and Monitoring
    Replies: 4
    Last Post: 04-11-2012, 01:07 PM
  3. Script to check blocking lock in DB (9i and earlier)
    By RohitB in forum Database Scripts
    Replies: 0
    Last Post: 01-10-2012, 06:33 PM
  4. Changing Oracle Database from Noarchivelog to Archivelog mode
    By Pradeep in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 12-14-2011, 05:10 AM
  5. Archivelog gets full
    By ajaysingh in forum Core Database Administration and Monitoring
    Replies: 7
    Last Post: 11-01-2011, 11:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics