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-09850: soacon: Archmon unable to lock named pipe.

1 Answers  


O2F-00311: Illegal or missing file name

1 Answers  


RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command

1 Answers  


PLS-00422: no PL/SQL translation for the bindtype given for this bind variable

1 Answers  


ORA-30932: Reference node 'string' not contained in specified parent node 'string'

1 Answers  






PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

2 Answers  


PLS-00645: character set mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


RMAN-06164: WARNING: no channel of required type allocated to recover datafile number

1 Answers  


ORA-22634: Error adding new instance to AnyDataSet

1 Answers  


NID-00402: Must finish change or REVERT changes before attempting any database operation.

1 Answers  


RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF

1 Answers  


PCB-00313: TO SAVEPOINT clause is an Oracle extension

1 Answers  


Categories