Archivelog mode Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archivelog mode

  1. #1
    Join Date
    Jun 2001
    Hi all
    Now my company oracle db is NOARCHIVELOG mode.
    How do i change it to Archivelog mode if not destroy any data?

  2. #2
    Join Date
    Jun 2001
    If u want to change from no archive to archive log no data will be lost.for details go thru. this following documentation.
    To switch a database's archiving mode between NOARCHIVELOG and ARCHIVELOG mode, use the SQL statement ALTER DATABASE with the ARCHIVELOG or NOARCHIVELOG option. The following statement switches the database's archiving mode from NOARCHIVELOG to ARCHIVELOG:


    Before switching the database's archiving mode, perform the following operations:

    Shut down the database instance.

    An open database must be closed and dismounted and any associated instances shut down before you can switch the database's archiving mode. You cannot disable archiving if any datafiles need media recovery.

    Back up the database.

    Before making any major change to a database, always back up the database to protect against any problems.

    Start a new instance and mount but do not open the database.

    To enable or disable archiving, the database must be mounted but not open.
    Switch the database's archiving mode.

    After using the ALTER DATABASE command to switch a database's archiving mode, open the database for normal operation. If you switched to ARCHIVELOG mode, you should also set the archiving options--decide whether to enable Oracle to archive groups of online redo log files automatically as they fill.

    For enabling automatic archive mode channge it in parameter file.

    Hope this will solve the things u required.


  3. #3
    Join Date
    Feb 2001
    In order to change the database mode from ARCHIVELOG to NONARCHIVELOG mode perform the following steps:

    1) Shutdown the database
    2)Take a cold database backup of all the
    datafiles,controlfiles,logfiles(if possible,recommended)
    3) In init.ora parameter file add the following parameters

    %T = Thread Number,left zero padded
    %t = Thread number,not padded
    %S = Log sequence number,left zero padded
    %s = Log sequence number,not padded

    4) Start the instance and mount the database(dont open it) and at Server Manager enter the follwowing command
    SVRMGR> alter database archivelog;

    5)Open the database
    SVRMGR>alter database open;

    6)Check it whether archivelog is set or not with the follwing 2 queries:
    sql>select * from v$database;
    svrmgr>archive log list

    In case of any help please be free to ask me at

    Rohit Nirkhe,Oracle DBA,OCP 8i

Posting Permissions

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

Click Here to Expand Forum to Full Width