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

ORA-19714: length for generated name longer than string

1 Answers  


ORA-01294: error occurred while processing information in dictionary file string, possible corruption

2 Answers  


ORA-24274: no row exists in the string table for these parameters

1 Answers  


ORA-14036: partition bound value too large for column

1 Answers  


ORA-16060: Log file is current

1 Answers  


ORA-16059: Log file is empty or invalid next available block

1 Answers  


ORA-01075: you are currently logged on

1 Answers  


TNS-00013: INTCTL: error while performing NS disconnect command

1 Answers  


ORA-30189: reserved for future use

1 Answers  


NNC-00403: program interface has not been initialised

1 Answers  


ORA-38466: user does not have privileges to CREATE/MODIFY expressions

1 Answers  


RMAN-06730: no channel to restore a backup of the SPFILE

1 Answers  


Categories