Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-00393: log string of thread string is needed for
recovery of offline datafiles



ORA-00393: log string of thread string is needed for recovery of offline datafiles..

Answer / guest

Cause: Log cannot be cleared because the redo in it is
needed to recover offline datafiles. It has not been
archived so there is no other copy available. If the log is
cleared the tablespaces containing the files will have to be
dropped.

Action: Archive the log then repeat the clear command. If
archiving is not possible, and dropping the tablespaces is
acceptible, then add the clause UNRECOVERABLE DATAFILE at
the end of the clear command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

UDI-00016: 'string' parameter requires a value.

1 Answers  


ORA-01858: a non-numeric character was found where a numeric was expected

1 Answers  


ORA-31423: change table string does not contain column string

1 Answers  


RMAN-03015: error occurred in stored script string

1 Answers  


NNL-00501: set|show log_stats_interval [<seconds>] [<server_list>] : set|show the server's statistic counter logging interval

1 Answers  


IMG-00518: invalid value for height or width

1 Answers  


NZE-29013: SSL MAC verification failure

1 Answers  


LPX-00219: invalid digit '~c' in character reference

1 Answers  


SQL*Loader-00132: invalid argument for external table option

1 Answers  


ORA-16622: Two or more broker database objects resolve to one physical database.

1 Answers  


ORA-29557: Java system class string cannot be modified

1 Answers  


ORA-01908: EXISTS keyword expected

1 Answers  


Categories