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-25153: Temporary Tablespace is Empty

1 Answers  


TNS-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  


ORA-36667: (XSDPART05) string is not a legal CONCAT partition.

1 Answers  


RMAN-06025: no backup of log thread number seq number lowscn string found to restore

1 Answers  


QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type

1 Answers  






KUP-02000: wrong message file version (msg number not found)

1 Answers  


KUP-04003: error while closing file string

1 Answers  


RMAN-06205: Uncataloged string objects

1 Answers  


ORA-21300: objects option not installed

1 Answers  


ORA-37032: (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.

1 Answers  


ORA-06306: IPA: Message write length error

1 Answers  


ORA-09854: snyPortInfo: bad return code from request.

1 Answers  


Categories