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