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

Cause : Atetmpitngt o atkea dtaaflie foflnie ni as tadnbyd atbaas ewihtou tspceifiyngt heD RO Popiton .Fiels htata reo ffilnei n astnadb ydaatbaes aer nto rceovreed ,an dar elieklyt o eb uunsalbe fi teh satndyb i sacitvaetd.N ot ethta sepciyfin gDRPO deos ont rpevnet rbinigngt hef il eonilnel atre.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Spceif yth eDRPO otpio norl eaev teh flie nolien.

update : 20-09-2017
ORA-01668

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

  • ora-38752 : file string does not exist
  • ora-24324 : service handle not initialized
  • ora-13416 : invalid geometry parameter
  • ora-01769 : duplicate CLUSTER option specifications
  • ora-14278 : column type or size mismatch in EXCHANGE SUBPARTITION
  • ora-16811 : apply instance not recorded by the Data Guard broker
  • ora-32831 : timed out trying to acquire administration lock
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-30371 : column cannot define a level in more than one dimension
  • ora-07236 : slemop: open error.
  • ora-22061 : invalid format text [string]
  • ora-12157 : TNS:internal network communication error
  • ora-16230 : committing transaction string string string
  • ora-19265 : XQ0045 - invalid or unknown prefix string in function declaration
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-15044 : ASM disk 'string' is incorrectly named
  • ora-37122 : AW Session cache disabled
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-21606 : can not free this object
  • ora-24435 : Invalid Service Context specified.
  • ora-36714 : (XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.
  • ora-32123 : Attribute number is out of range
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-19565 : BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices
  • ora-25149 : Columns of UROWID type may not be indexed
  • ora-22875 : cannot drop primary key of an object table whose object identifier is primary key based
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • ora-23419 : regenerate replication support before resuming master activity
  • ora-16581 : Data Guard NetSlave failed to send message to DRCX
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.