Urgent - Archive log RECOVERY in Oracle 9i


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Urgent - Archive log RECOVERY in Oracle 9i

  1. #1
    Ashok Guest

    Urgent - Archive log RECOVERY in Oracle 9i



    Hello Friends

    I need your help on a notorious problem being faced after executing "RECOVER
    Standby Database" command for a Oracle 9i standby database setup.

    To brief, all the data files, archived log files and standby control file
    were copied from production site to standby site. Then, standby database
    was mounted in the exclusive mode, and on execution of "RECOVER From '/uo1/product/9.0.1/dbs/arc/'
    "
    command following error message is being displayed:

    ==============================================================
    ORA - 00283 Recovery Session Canceled.
    ORA - 00600 Internal Error Code arguments [3020, 8388729, [1], [4], [305],
    [16]

    ORA - 1057 -Redo is inconsistent with database ( file # 2, block #21)
    ORA- 10564 - Table space UNDOTBS
    ORA - 1110 : Data file 2 '/u01/..veres/undotbs01.dbf'
    ORA - 10560 : Block type 'KTUSMU ....'

    ORA - 0112 : Media Recovery not started.
    ===============================================================

    I've rummaged through google.com search, finally seek your supportive thoughts
    towards the resolution.
    Please let me know, if needed, I will pass the IP for remote observations.

    Waiting for your reply.

    Thanks always,
    Ashok



  2. #2
    dnagel Guest

    Re: Urgent - Archive log RECOVERY in Oracle 9i

    Ora 600 means that an Oracle executable died doing what ever it was that
    you asked it to do...

    Only Oracle can tell you why, and you must supply then numbers after the 600
    for them to identify
    the module, line number, etc to figure out what happened.

    Sorry I can't be more helpful, but Orqacle does not publish the meanings of
    an ORA 600.
    They are version specific and there are an infinite number of reasons... far
    to many to publish.

    They will want a stack trace and other stuff from you.

    D.

    "Ashok" <agoyal@health-outcomes.com> wrote in message
    news:3bbd0653$1@news.devx.com...
    >
    >
    > Hello Friends
    >
    > I need your help on a notorious problem being faced after executing

    "RECOVER
    > Standby Database" command for a Oracle 9i standby database setup.
    >
    > To brief, all the data files, archived log files and standby control file
    > were copied from production site to standby site. Then, standby database
    > was mounted in the exclusive mode, and on execution of "RECOVER From

    '/uo1/product/9.0.1/dbs/arc/'
    > "
    > command following error message is being displayed:
    >
    > ==============================================================
    > ORA - 00283 Recovery Session Canceled.
    > ORA - 00600 Internal Error Code arguments [3020, 8388729, [1], [4],

    [305],
    > [16]
    >
    > ORA - 1057 -Redo is inconsistent with database ( file # 2, block #21)
    > ORA- 10564 - Table space UNDOTBS
    > ORA - 1110 : Data file 2 '/u01/..veres/undotbs01.dbf'
    > ORA - 10560 : Block type 'KTUSMU ....'
    >
    > ORA - 0112 : Media Recovery not started.
    > ===============================================================
    >
    > I've rummaged through google.com search, finally seek your supportive

    thoughts
    > towards the resolution.
    > Please let me know, if needed, I will pass the IP for remote observations.
    >
    > Waiting for your reply.
    >
    > Thanks always,
    > Ashok
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center