Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    3

    Unanswered: Unable to make connection, ora-01033: oracle initialization or shutdown in progress.

    Hi All,

    I'd like to start by apologising in case I'm posting this and there already is a solution. Unfortunately I don't have the luxury of time, the san has hit the fhit.

    I am currently using:
    BANNER
    --------------------------------------------------------------
    Oracle Database 10g Release 10.2.0.1.0 - Production
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production

    Last month our Oracle DBA switched from Enterprise to standard edition while I was away. When I arrived this Monday everyone was screaming because they couldn't run applications or reports accessing Oracle. They and I kept getting this error:

    00257: archiver error. Connect internal only, until freed.

    I did the following steps:

    Shutdown immediate;
    Startup mount
    Alter database clear unarchived logfile <'My redo log files 1 to 3'>
    shutdown immediate
    startup

    This seemed to do the trick until the next morning when the same thing happened again. I then found this website Oracle in World: ORA-00257: archiver error. Connect internal only, until freed. and tried the second method. I increased the size of db_recovery_file_dest from 2g to 5g then I reset the archive destination to use db_recovery_file_dest.

    Again everything was fine until this morning when I started getting this:

    Unable to make connection, ora-01033: oracle initialization or shutdown in progress.

    Once again I cleared the unarchived logs and found that db_recovery_file_dest's space limit had reverted to 2g again and the space used was now 2g as well. I changed it to 5g again. Then I started getting the following error:

    Database mounted.
    ORA-01113: file 2 needs media recovery
    ORA-01110: data file 2: 'F:\ORACLE\ORADATA\...\UNDOTBS01.DBF' and the application throws the

    "Unable to make connection, ora-01033: oracle initialization or shutdown in progress." error at me.

    I looked on the web for a solution and went onto the oracle online manual and they talk about RMAN and Complete and Incomplete recovery. It's all just flying over my head and everyone is looking at me like I should be Einstein. I have no idea how to go about fixing this problem as I'm a lowly programmer and have never had to do this before. I would really appreciate some help in fixing it or at least holding the fort until the real DBA who gets back.

    Oh and I do know that I have Archivelog mode on.

    Thank you kindly
    Last edited by Wolfdrone; 01-07-10 at 06:02.

  2. #2
    Join Date
    Jan 2010
    Posts
    3
    My probem has been partially solved: ORA-00257: archiver error. Connect internal only, until freed tips

    I increased my flash recovery area size, but for some reason my archive logs are not being switched automatically so I've written a small script to run every 15 minutes that does it. At least users are able to work now. Pheew...thanks anyway to all.

  3. #3
    Join Date
    Jan 2010
    Posts
    3
    Alright I'm back again. I've had a look at my alert log and this is what I found:

    ARC0: Archival started
    ARC1: Archival started
    ARC1 started with pid=17, OS id=...
    Thu Jan 07 13:15:07 2010
    LGWR: STARTING ARCH PROCESSES COMPLETE
    Thread 1 opened at log sequence 8838
    Current log# 3 seq# 8838 mem# 0: F:\ORACLE\ORADATA\MANU_HP\REDO03.LOG
    Successful open of redo thread 1
    Thu Jan 07 13:15:07 2010
    SMON: enabling cache recovery
    Thu Jan 07 13:15:07 2010
    ARC0: STARTING ARCH PROCESSES
    Thu Jan 07 13:15:07 2010
    ARC1: Becoming the 'no FAL' ARCH
    ARC1: Becoming the 'no SRL' ARCH
    Thu Jan 07 13:15:07 2010
    ARC2: Archival started
    ARC0: STARTING ARCH PROCESSES COMPLETE
    ARC2 started with pid=18, OS id=4836
    Thu Jan 07 13:15:07 2010
    ARC0: Becoming the heartbeat ARCH
    Thu Jan 07 13:15:08 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc0_4856.trc:
    ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 bytes is 100.00&#37; used, and has 0 remaining bytes available. (I don't get how this is possible since when I check the space used it says 1.5g)
    ************************************************** **********************
    You have following choices to free up space from flash recovery area:
    Thu Jan 07 13:15:08 2010
    ************************************************** **********************
    1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
    You have following choices to free up space from flash recovery area:
    then consider changing RMAN ARCHIVELOG DELETION POLICY.
    1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
    2. Back up files to tertiary device such as tape using RMAN
    then consider changing RMAN ARCHIVELOG DELETION POLICY.
    BACKUP RECOVERY AREA command.
    2. Back up files to tertiary device such as tape using RMAN
    3. Add disk space and increase db_recovery_file_dest_size parameter to (My disk space is about 33G and I've increased the recovery size to 10g)
    BACKUP RECOVERY AREA command.
    reflect the new space.
    3. Add disk space and increase db_recovery_file_dest_size parameter to
    4. Delete unnecessary files using RMAN DELETE command. If an operating
    reflect the new space.
    system command was used to delete files, then use RMAN CROSSCHECK and
    4. Delete unnecessary files using RMAN DELETE command. If an operating
    DELETE EXPIRED commands.
    system command was used to delete files, then use RMAN CROSSCHECK and
    ************************************************** **********************
    DELETE EXPIRED commands.
    ************************************************** **********************
    Thu Jan 07 13:15:08 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc0_4856.trc:
    ORA-19809: limit exceeded for recovery files
    ORA-19804: cannot reclaim 439296 bytes disk space from 10737418240 limit

    Thu Jan 07 13:15:08 2010
    ARC0: Error 19809 Creating archive log file to 'F:\BACKUP\MANU_HP\FLASH_RECOVERY_AREA\MANU_HP\ARC HIVELOG\2010_01_07\O1_MF_1_8834_U_.ARC'
    Thu Jan 07 13:15:08 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc1_4668.trc:
    ORA-19809: limit exceeded for recovery files
    ORA-19804: cannot reclaim 997888 bytes disk space from 10737418240 limit

    Thu Jan 07 13:15:08 2010
    ARC1: Error 19809 Creating archive log file to 'F:\BACKUP\MANU_HP\FLASH_RECOVERY_AREA\MANU_HP\ARC HIVELOG\2010_01_07\O1_MF_1_8833_U_.ARC'
    Thu Jan 07 13:15:08 2010
    ARC0: Failed to archive thread 1 sequence 8834 (19809)
    ARCH: Archival stopped, error occurred. Will continue retrying
    Thu Jan 07 13:15:08 2010
    ARC1: Failed to archive thread 1 sequence 8833 (19809)
    ARCH: Archival stopped, error occurred. Will continue retrying
    sksasmowrt WriteConsole error 6
    sksasmowrt WriteConsole error 6
    Thu Jan 07 13:15:08 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc1_4668.trc:
    ORA-16038: log 5 sequence# 8833 cannot be archived
    ORA-19809: limit exceeded for recovery files
    ORA-00312: online log 5 thread 1: 'F:\ORACLE\ORADATA\MANU_HP\REDO5.ORA'

    Thu Jan 07 13:15:08 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc0_4856.trc:
    ORA-16038: log 4 sequence# 8834 cannot be archived
    ORA-19809: limit exceeded for recovery files
    ORA-00312: online log 4 thread 1: 'F:\ORACLE\ORADATA\MANU_HP\REDO4.ORA'

    Thu Jan 07 13:15:08 2010
    Successfully onlined Undo Tablespace 1.
    Thu Jan 07 13:15:08 2010
    SMON: enabling tx recovery
    Thu Jan 07 13:15:08 2010
    Database Characterset is WE8MSWIN1252
    replication_dependency_tracking turned off (no async multimaster replication found)
    Starting background process QMNC
    QMNC started with pid=19, OS id=3664
    Thu Jan 07 13:15:10 2010
    Completed: alter database open
    Thu Jan 07 13:16:06 2010
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive thread 1 sequence 8833 (4)
    ARCH: Archival stopped, error occurred. Will continue retrying
    Thu Jan 07 13:16:06 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc0_4856.trc:
    ORA-16014: log 5 sequence# 8833 not archived, no available destinations
    ORA-00312: online log 5 thread 1: 'F:\ORACLE\ORADATA\MANU_HP\REDO5.ORA'

    Thu Jan 07 13:17:06 2010
    ARC1: Archiving not possible: No primary destinations (This I seriously also don't get since I have specified the flash recovery area)
    ARC1: Failed to archive thread 1 sequence 8833 (4)
    Thu Jan 07 13:18:06 2010
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive thread 1 sequence 8833 (4)
    Thu Jan 07 13:19:16 2010
    Cleared LOG_ARCHIVE_DEST_10 parameter default value
    Using LOG_ARCHIVE_DEST_1 parameter default value as E:\oracle\product\10.2.0\db_1\RDBMS
    Thu Jan 07 13:19:16 2010
    ALTER SYSTEM SET db_recovery_file_dest='' SCOPE=BOTH;
    Thu Jan 07 13:19:16 2010
    Archiver process freed from errors. No longer stopped
    Thu Jan 07 13:21:06 2010
    Shutting down archive processes
    Thu Jan 07 13:21:11 2010
    ARCH shutting down
    ARC2: Archival stopped
    Thu Jan 07 13:32:19 2010
    Cleared LOG_ARCHIVE_DEST_1 parameter default value
    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
    ************************************************** ********
    WARNING: Files may exists in db_recovery_file_dest
    that are not known to the database. Use the RMAN command
    CATALOG RECOVERY AREA to re-catalog any such files.
    One of the following events caused this:
    1. A backup controlfile was restored.
    2. A standby controlfile was restored.
    3. The controlfile was re-created.
    4. db_recovery_file_dest had previously been enabled and
    then disabled.
    ************************************************** ********
    Thu Jan 07 13:32:19 2010
    ALTER SYSTEM SET db_recovery_file_dest='F:\BACKUP\MANU_HP\FLASH_REC OVERY_AREA' SCOPE=BOTH;
    Thu Jan 07 13:38:49 2010
    Thread 1 cannot allocate new log, sequence 8839 Private strand flush not complete
    Current log# 3 seq# 8838 mem# 0: F:\ORACLE\ORADATA\MANU_HP\REDO03.LOG
    Thread 1 advanced to log sequence 8839
    Current log# 5 seq# 8839 mem# 0: F:\ORACLE\ORADATA\MANU_HP\REDO5.ORA
    Thu Jan 07 13:38:54 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc1_4668.trc:
    ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 bytes is 100.00% used, and has 0 remaining bytes available.

    Thu Jan 07 13:38:54 2010
    ***********************
    You have following choices to free up space from flash recovery area:...
    Thu Jan 07 13:38:54 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc1_4668.trc:
    ORA-19809: limit exceeded for recovery files
    ORA-19804: cannot reclaim 31564800 bytes disk space from 10737418240 limit

    ARC1: Error 19809 Creating archive log file to 'F:\BACKUP\MANU_HP\FLASH_RECOVERY_AREA\MANU_HP\ARC HIVELOG\2010_01_07\O1_MF_1_8838_U_.ARC'
    ARC1: Failed to archive thread 1 sequence 8838 (19809)
    ARCH: Archival stopped, error occurred. Will continue retrying
    Thu Jan 07 13:38:54 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc1_4668.trc:
    ORA-16038: log 3 sequence# 8838 cannot be archived
    ORA-19809: limit exceeded for recovery files
    ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\MANU_HP\REDO03.LOG'

    Thu Jan 07 13:39:11 2010
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive thread 1 sequence 8838 (4)
    ARCH: Archival stopped, error occurred. Will continue retrying
    Thu Jan 07 13:39:11 2010
    Errors in file e:\oracle\product\10.2.0\admin\manu_hp\bdump\manuh p_arc0_4856.trc:
    ORA-16014: log 3 sequence# 8838 not archived, no available destinations
    ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\MANU_HP\REDO03.LOG'

    Thu Jan 07 13:39:32 2010
    Cleared LOG_ARCHIVE_DEST_10 parameter default value
    Using LOG_ARCHIVE_DEST_1 parameter default value as E:\oracle\product\10.2.0\db_1\RDBMS
    Thu Jan 07 13:39:32 2010
    ALTER SYSTEM SET db_recovery_file_dest='' SCOPE=BOTH;
    Thu Jan 07 13:39:34 2010
    Archiver process freed from errors. No longer stopped
    Thu Jan 07 13:53:05 2010
    Thread 1 advanced to log sequence 8840
    Current log# 4 seq# 8840 mem# 0: F:\ORACLE\ORADATA\MANU_HP\REDO4.ORA
    Thu Jan 07 13:59:44 2010
    Thread 1 advanced to log sequence 8841
    Current log# 6 seq# 8841 mem# 0: F:\ORACLE\ORADATA\MANU_HP\REDO6.ORA
    Thu Jan 07 14:00:33 2010
    Thread 1 advanced to log sequence 8842
    Current log# 1 seq# 8842 mem# 0: F:\ORACLE\ORADATA\MANU_HP\REDO01.LOG
    Thread 1 advanced to log sequence 8843
    Current log# 2 seq# 8843 mem# 0: F:\ORACLE\ORADATA\MANU_HP\REDO02.LOG


    Currently I've disabled the flash recovery area and I haven't had any more problems, but obviously this is not the ideal situation. I would appreciate it if anyone can decipher what is going on from my log.

    Thanks

Posting Permissions

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