-
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
-
-
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
-
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
-
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)
-
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
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|