You are here: Home // Oracle 11g // ORA-01668: standby database requires DROP option for offline of data file

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

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. See the solution below.

Error solution: Specify the DROP option or leave the file online.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Borelioza kontrola dostępu Piła taśmowa do drewna loans payday advances