DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Disable archive log mode for 11g

  1. #1
    Join Date
    Oct 2009
    Posts
    30

    Disable archive log mode for 11g

    Hi,

    I want to disable archive log mode for my 11g database.

    The steps I think should be followed are:

    1. shutdown immediate;
    2. Change the init.ora parameter related to the instance
    In pfile:
    log_archive_start = false
    3. startup mount pfile='';
    4. alter database noarchivelog;
    5. alter database open;

    What should the step 2 be, in case I have an SPFILE???? Please suggest.

    Thanks in advance

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    log_archive_start parameter is deprecated from 10g. Please use the below procedure.

    SHUTDOWN;

    STARTUP MOUNT;

    ALTER DATABASE NOARCHIVELOG;

    ALTER DATABASE OPEN;

    No need to change any init parameter.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Oct 2009
    Posts
    30
    Thank you.

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