Oracle DBA, How To, Error, Cause and Action

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.



Action:


Specify the DROP option or leave the file online.

No comments:

Post a Comment

Thanks for your comment.