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-19633: controlfile record string is out of sync with recovery catalog

1 Answers  


ORA-22061: invalid format text [string]

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


ORA-16745: unable to add DB_UNIQUE_NAME string into The DG_CONFIG list because it is full

1 Answers  


ORA-14022: creation of LOCAL partitioned cluster indices is not supported

1 Answers  


ORA-24502: codepoint length overflows

1 Answers  


ORA-12729: invalid character class in regular expression

1 Answers  


ORA-16509: the request timed out

1 Answers  


ORA-19908: datafile string has invalid checkpoint

1 Answers  


RMAN-06020: connected to auxiliary database (not started)

1 Answers  


ORA-23416: table "string"."string" does not contain a primary key constraint

1 Answers  


DRG-10826: no document with the specified textkey is found

1 Answers  


Categories