ORA-01668: standby database requires DROP option for offline
of data file



ORA-01668: standby database requires DROP option for offline of data file..

Answer / guest

Cause: Attempting to take a datafile offline in a standby
database without specifying the DROP option. Files that are
offline in a standby database are not recovered, and are
likely to be unusable if the standby is activated. Note that
specifying DROP does not prevent bringing the file online later.

Action: Specify the DROP option or leave the file online.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09920: Unable to get sensitivity label from connection

1 Answers  


PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL

1 Answers  


ORA-36274: (XSCGMDLAGG05) The operator used in this equation needs a weight variable.

1 Answers  


ORA-27411: An empty string is not a valid repeat interval.

1 Answers  


TNS-12210: TNS:error in finding Navigator data

1 Answers  


DRG-10825: stored query does not exist: string

1 Answers  


ORA-16716: clearing parameter LOG_ARCHIVE_DEST failed

1 Answers  


ORA-24335: cannot support more than 1000 columns

1 Answers  


NNL-00959: Time until cache dump to trace file: string

1 Answers  


TNS-00006: INTCTL: HOST variable is not defined

1 Answers  


IMG-00706: unsupported or corrupted output format

1 Answers  


ORA-12448: policy string not applied to schema string

1 Answers  


Categories