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

NNL-00960: Time until cache flush: string

1 Answers  


RMAN-06598: conversion between platforms 'string' and 'string' is not needed

1 Answers  


TNS-00560: extraction of name from Entrust certificate failed

1 Answers  


RMAN-06748: no or more than one tertiary storage channel found

1 Answers  


ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package

1 Answers  


QSM-01096: Materialized view with grouping sets contains duplicates

1 Answers  


ORA-00478: SMON process terminated due to error string

1 Answers  


O2I-00129: No Java file specified

1 Answers  


ORA-01298: conflicting dictionary option

1 Answers  


ORA-00331: log version string incompatible with ORACLE version string

2 Answers  


ORA-00215: must be at least one controlfile

1 Answers  


NCR-03019: NCRO: Unable to initialize thread support

1 Answers  


Categories