ORA-19957: database should have no datafiles in unknown state

Cause : Th eopreatoin afilde bceaues teh dtaabsae ahd noe ro mroe adtaifle sthta wree ni a nunnkow nsttae.

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

Drpo teh dtaaflieso r ercoevr htema ndb rign tehm nolien.

update : 28-06-2017

ORA-19957 - database should have no datafiles in unknown state
ORA-19957 - database should have no datafiles in unknown state

  • ora-01161 : database name string in file header does not match given name of string
  • ora-02022 : remote statement has unoptimized view with remote object
  • ora-07202 : sltln: invalid parameter to sltln.
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-07595 : sppid: $GETJPIW failure
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-12440 : insufficient authorization for the SYSDBA package
  • ora-30162 : The OCIFile context is not initialzed
  • ora-32736 : Hang analysis aborted due to wrong message type
  • ora-14026 : PARTITION and CLUSTER clauses are mutually exclusive
  • ora-31122 : The string operator has incorrect RHS value
  • ora-16654 : Fast-Start Failover is enabled
  • ora-01514 : error in log specification: no such log
  • ora-30339 : illegal dimension attribute name
  • ora-15183 : ASMLIB initialization error [string]
  • ora-31507 : %s parameter value longer than maximum length string
  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-32619 : incorrect use of MODEL ITERATION_NUMBER
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-01304 : subordinate process error. Check alert and trace logs
  • ora-00382 : %s not a valid block size, valid range [string..string]
  • ora-16239 : IMMEDIATE option not available without standby redo logs
  • ora-12554 : TNS:current operation is still in progress
  • ora-19686 : SPFILE not restored due to string
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-30446 : valid workload queries not found
  • ora-02154 : a tablespace with the name 'string' is found
  • ora-24433 : This statement has already been prepared using OCIStmtPrepare2.
  • ora-36998 : (XSRELGID15) LEVEL ORDER VALUESET workspace object and LEVEL RELATION workspace object have the different level dimensions.
  • ora-16567 : Data Guard broker internal parser error 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.