ORA-27030: skgfwrt: sbtwrite2 returned error

Cause : sbtwrite2 returned an error. This happens while writing a backup file during a backup operation.

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

This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.

update : 24-05-2017
ORA-27030

ORA-27030 - skgfwrt: sbtwrite2 returned error
ORA-27030 - skgfwrt: sbtwrite2 returned error

  • ora-01854 : julian date must be between 1 and 5373484
  • ora-39953 : the range value specified is beyond allowed range
  • ora-40217 : priors table mismatched with training data
  • ora-25287 : Invalid value string, string should be non-negative
  • ora-12063 : unable to apply transaction from site string
  • ora-07747 : slemrd: $READ failure
  • ora-28006 : conflicting values for parameters string and string
  • ora-13110 : cannot drop topology with associated topo_geometry tables
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-15069 : ASM file 'string' not accessible; timed out waiting for lock
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-29936 : NULL association is allowed only with a column or an index
  • ora-38902 : errors in array insert exceed string
  • ora-02823 : Buffer is not aligned.
  • ora-01091 : failure during startup force
  • ora-19611 : backup piece out of order. Expected string but found string
  • ora-31108 : Action failed as resource string is locked
  • ora-25329 : AQ array operations not allowed on 8.0 queues
  • ora-19634 : filename required for this function
  • ora-24092 : invalid value string specified
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-08104 : this index object string is being online built or rebuilt
  • ora-29865 : indextype is invalid
  • ora-30956 : invalid option for XML Index
  • ora-19660 : some files in the backup set could not be verified
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-00283 : recovery session canceled due to errors
  • ora-37127 : (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-30119 : unable to obtain a valid value for '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.