ORA-01153 an incompatible media recovery is active
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01153 an incompatible media recovery is active

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    ORA-01153 an incompatible media recovery is active

    Hi guys
    I need help solving this issue please

    On my standby database I run the following query and got ORA-01153 below.

    SQL> alter database recover managed standby database NODELAY disconnect from session
    *
    ERROR at line 1:
    ORA-01153: an incompatible media recovery is active

    How to resolve this?

    Thank you for your help
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Jan 2008
    Posts
    45
    i think there is an other recovery process taking place... U should either allow it complte or stop the other process....

    try OERR NUmber to get the details in the window....

    Thanks

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,441

    Cool Rman?

    You may have hit bug# 3597439, check it out in Metalink.

    Here is an excerpt:

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE command will fail with
    ORA-1153, "incompatible media recovery active" if an RMAN backup is
    in progress.

    Workaround:
    Start managed recovery before starting RMAN backup,
    (They will run at the same time, but only if managed recovery is started first)
    or
    Wait until the RMAN backup is complete before starting managed recovery.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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