ORA-19589: %s is not a snapshot or backup control file

Cause : The control file that is the source for a backup or copy operation is not a snapshot or backup control file.

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

Specify the name of a snapshot or backup control file.

update : 28-04-2017
ORA-19589

ORA-19589 - %s is not a snapshot or backup control file
ORA-19589 - %s is not a snapshot or backup control file

  • ora-12535 : TNS:operation timed out
  • ora-00271 : there are no logs that need archiving
  • ora-14170 : cannot specify clause in CREATE TABLE|INDEX
  • ora-01167 : two files are the same file/group number or the same file
  • ora-04028 : cannot generate diana for object stringstringstringstringstring
  • ora-14261 : partition bound may not be specified when adding this Hash partition
  • ora-16724 : the intended state for the database has been set to OFFLINE
  • ora-00279 : change string generated at string needed for thread string
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-01317 : Not attached to a Logminer session
  • ora-28134 : object cannot have fine-grained access control policy
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-12326 : database string is closing immediately; no operations are permitted
  • ora-12405 : invalid label list
  • ora-00231 : snapshot control file has not been named
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-00223 : convert file is invalid or incorrect version
  • ora-14133 : ALTER TABLE MOVE cannot be combined with other operations
  • ora-28578 : protocol error during callback from an external procedure
  • ora-38489 : predicate table creation failed due to: ORAstring
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-26004 : Tables loaded through the direct path may not be clustered
  • ora-01347 : Supplemental log data no longer found
  • ora-23504 : columns added to table do not match list of columns to be added
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-24342 : unable to destroy a mutex
  • ora-29284 : file read error
  • ora-32812 : subscriber string does not exist
  • ora-23478 : object group "string" is already mastered at string
  • 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.