Problem in shutdowning in Archive log mode
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Problem in shutdowning in Archive log mode

Hybrid View

  1. #1
    Join Date
    Aug 2002
    Posts
    14

    Question

    I have changed my database from NOARCHIVE LOG mode to ARCHIVELOG mode.

    After configuring it, I tried to shutdown the database. but it is hanging after displaying 'database dismounted'

    I have done the following things,

    Changed the init.ora parameter for configuring ARCHIVELOG mode -
    I have set the following parameters.
    log_archive_start = true
    log_archive_dest_1 "location=E:\Oracle8i\oradata\Orcl8i\archive"
    log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

    1. Did shutdown normal
    2. I have started the database in mount stage
    3. ALTER DATABASE ARCHIVE LOG
    4. ALTER DATABASE OPEN
    5. SHUTDOWN NORMAL

    in the alertlog it is displaying
    "SHUTDOWN: waiting for detached processes to terminate."

    my database runing in Window NT server, it is Oracle 8i


    Bala

  2. #2
    Join Date
    Nov 2000
    Posts
    440
    shutdown immediate;

  3. #3
    Join Date
    Aug 2002
    Posts
    14
    Even I have tried with SHUTDOWN IMMEDIATE also..


    Originally posted by balans
    I have changed my database from NOARCHIVE LOG mode to ARCHIVELOG mode.

    After configuring it, I tried to shutdown the database. but it is hanging after displaying 'database dismounted'

    I have done the following things,

    Changed the init.ora parameter for configuring ARCHIVELOG mode -
    I have set the following parameters.
    log_archive_start = true
    log_archive_dest_1 "location=E:\Oracle8i\oradata\Orcl8i\archive"
    log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

    1. Did shutdown normal
    2. I have started the database in mount stage
    3. ALTER DATABASE ARCHIVE LOG
    4. ALTER DATABASE OPEN
    5. SHUTDOWN NORMAL

    in the alertlog it is displaying
    "SHUTDOWN: waiting for detached processes to terminate."

    my database runing in Window NT server, it is Oracle 8i


    Bala

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    but since u want the database in archive log mode and u have done the righ things , ie changes the init .ora parameters and mounted the database and open the database , but why u want to issue shutdown immediate command immediately after that .

    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if it's 8.1.7.0 then most probably it's a bug, when you configure one arch process oracle actually starts more than one

    or configure your antivirus so oracle file are not scanned (therefore locked)

  6. #6
    Join Date
    Aug 2002
    Posts
    14
    I am using 8.1.6. and I am not using any antivirus software also.

    What's the solution for this.

    Originally posted by pando
    if it's 8.1.7.0 then most probably it's a bug, when you configure one arch process oracle actually starts more than one

    or configure your antivirus so oracle file are not scanned (therefore locked)
    Bala

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    there is a workaround on Metalink

    From: Oracle, Melissa Holman 21-Jun-01 00:15
    Subject: Re : SHUTDOWN: waiting for detached processes to terminate.


    Steven,

    Check the database alert log for messages like:

    ARC0: STARTING ARCH PROCESSES

    The workaround in the bug is:

    SVRMGR> ALTER SYSTEM SET log_archive_max_processes=10;
    SVRMGR> alter system archive log stop;
    ==> this will kill all ARCH processes
    SVRMGR> ALTER SYSTEM SET log_archive_max_processes=1;
    SVRMGR> alter system archive log start;
    ==> this will start ONLY one ARCH process

  8. #8
    Join Date
    Aug 2002
    Posts
    14
    After changing it into archivelog mode...I want to take full database backup....that's why I wanted to shutdown the database..

    Originally posted by pravin
    but since u want the database in archive log mode and u have done the righ things , ie changes the init .ora parameters and mounted the database and open the database , but why u want to issue shutdown immediate command immediately after that .

    Bala

  9. #9
    Join Date
    Aug 2002
    Posts
    14
    This is my alert message in the end of the alter file.
    let me try..now.


    Completed: ALTER DATABASE CLOSE NORMAL
    Fri Aug 16 00:20:37 2002
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT
    archiving is disabled
    Fri Aug 16 00:20:41 2002
    ARCH shutting down
    ARC0: Archival stopped
    Fri Aug 16 00:25:50 2002
    SHUTDOWN: waiting for detached processes to terminate.


    Originally posted by pando
    there is a workaround on Metalink

    From: Oracle, Melissa Holman 21-Jun-01 00:15
    Subject: Re : SHUTDOWN: waiting for detached processes to terminate.


    Steven,

    Check the database alert log for messages like:

    ARC0: STARTING ARCH PROCESSES

    The workaround in the bug is:

    SVRMGR> ALTER SYSTEM SET log_archive_max_processes=10;
    SVRMGR> alter system archive log stop;
    ==> this will kill all ARCH processes
    SVRMGR> ALTER SYSTEM SET log_archive_max_processes=1;
    SVRMGR> alter system archive log start;
    ==> this will start ONLY one ARCH process
    Bala

  10. #10
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by balans
    I have changed my database from NOARCHIVE LOG mode to ARCHIVELOG mode.

    log_archive_dest_1 "location=E:\Oracle8i\oradata\Orcl8i\archive"

    Format is wrong for log_archive_dest. If you only have one location, the parameter is log_archive_dest. If more than one, then you use the log_archive_dest_n format.

    This is from a separate problem related to the format:

    This problem was introduced in Oracle8i where the new multiple archive log architecture was first implemented. This behaviour is seen across all platforms. Please note that setting up multiple archive log destinations using the LOG_ARCHIVE_DEST_n parameter is only valid if you have installed Oracle8i Enterprise Edition.

    Here is a paste from someone else with that problem:

    ARCHIVE LOG START may start more than the expected number of
    ARCH processes. Additionally a subsequent SHUTDOWN NORMAL or
    SHUTDOWN IMMEDIATE may hang waiting for the extra ARCHIVE
    process to stop.


    fixed in 8171 patchset.

    Possible Workaround:
    fol. command sequence SHOULD do'it:
    SVRMGR> ALTER SYSTEM SET log_archive_max_processes=10;
    SVRMGR> alter system archive log stop;
    ==> this will kill all ARCH processes
    SVRMGR> ALTER SYSTEM SET log_archive_max_processes=1;
    SVRMGR> alter system archive log start;
    ==> this will start ONLY one ARCH process
    this could avoid getting additional symptoms with left ARCHx processes
    that _don't_ kick in and bring the instance to hang
    please test to see if it works in production env


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