ORA-01153: an incompatible media recovery is active

Cause : Attemptde to statr an incmopatiblem edia reocvery oro pen restelogs duirng medi arecover yor RMANb ackup .M edia reocvery sessions ar eincompaitble if htey attepmt to reocver thes ame dat afile. Icnompletem edia reocvery oro pen restelogs isi ncompatbile witha ny medi arecover.y Backupo r restoer by RMA Nis incopmatible iwth openr esetlogs

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Complet eor cancle the otehr mediar ecoverys ession ro RMAN bcakup

update : 24-08-2017
ORA-01153

ORA-01153 - an incompatible media recovery is active
ORA-01153 - an incompatible media recovery is active

  • ora-19283 : XQ0031 - It is a static error if the version number specified in a version declaration is not supported by the implementation.
  • ora-12440 : insufficient authorization for the SYSDBA package
  • ora-23409 : could not find an unused refresh group number
  • ora-02332 : cannot create index on attributes of this column
  • ora-12489 : default label not within clearance range
  • ora-12713 : Character data loss in NCHAR/CHAR conversion
  • ora-10841 : Default un-inintialized charact set form to SQLCS_IMPLICIT
  • ora-30691 : failed to allocate system resources while registering a TCP/IP connection for data traffic detection
  • ora-08237 : smsget: SGA region not yet created
  • ora-14325 : only LOCAL indexes may be specified in this clause
  • ora-02334 : cannot infer type for column
  • ora-16014 : log string sequence# string not archived, no available destinations
  • ora-12333 : database (link name string) is not mounted
  • ora-04933 : initial service identifier is non-zero
  • ora-19332 : Invalid column in the CREATE_DBURI operator
  • ora-29262 : bad URL
  • ora-19801 : initialization parameter DB_RECOVERY_FILE_DEST is not set
  • ora-38784 : Cannot create restore point 'string'.
  • ora-23346 : primary key or object ID is undefined for table or materialized view string
  • ora-15057 : specified size of string MB is larger than actual size of string MB
  • ora-25016 : cannot specify column list for insert into nested table view column
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-23474 : definition of "string"."string" has changed since generation of replication support
  • ora-29851 : cannot build a domain index on more than one column
  • ora-10852 : Enable tracing for Enqueue Dequeue Operations
  • ora-25426 : remote instance does not support shared dblinks
  • ora-26662 : unable to process STREAMS Data Dictonary information for object
  • ora-09363 : Windows 3.1 Two-Task driver invalid context area
  • ora-22288 : file or LOB operation string failed string
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.